My Oracle Support Banner

[ADB] How to get public IP of the client in UNIFIED_AUDIT_TRAIL view. (Doc ID 2781380.1)

Last updated on JUNE 02, 2021

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A to N/A
Information in this document applies to any platform.

Goal

While monitoring OCI events we can see 'DatabaseConnection' events with Public IP addresses of the clients.

Example below:
=============
  "request": null,
  "response": null,
  "stateChange": null,
  "additionalDetails": {
  "autonomousDatabaseType": "Shared Infrastructure",
  "dbName": "xxxxxx",
  "description": "New connection established for xxxxxxx with host 152.67.x.x",
  "eventName": "DatabaseConnection",
  "ipAddress": "152.67.x.x",
  "workloadType": "Data Warehouse"
  }
==============

If we query records from UNIFIED_AUDIT_TRAIL view, we don't see public IP address. How do we get public IP in the audit records in UNIFIED_AUDIT_TRAIL view?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.