Oracle Audit (XML) log format and field mapping

Prev Next

Log format

The expected format for this device is:

<AuditRecord><Audit_Type></Audit_Type><Session_Id></Session_Id><StatementId></StatementId><EntryId></EntryId>
<Extended_Timestamp></Extended_Timestamp><DB_User></DB_User><Userhost></Userhost><OS_Process></ OS_Process>
<Terminal></Terminal><Instance_Number></Instance_Number><Returncode></Returncode><Scn></Scn>
<OSPrivilege></OSPrivilege><DBID></DBID> <Sql_Text></Sql_Text></AuditRecord>

Log sample

This is a sample log from an Oracle Audit device:

<AuditRecord><Audit_Type>0</Audit_Type><Session_Id>0</Session_Id><StatementId>0</StatementId><EntryId>0</EntryId>
<Extended_Timestamp>2015-01-01T00:00:00.0000000</Extended_Timestamp><DB_User>/</DB_User><Userhost>HOST.COMPANY.COM
</Userhost><OS_Process>12345</OS_Process><Terminal>UNKNOWN</Terminal><Instance_Number>2</Instance_Number>
<Returncode>0</Returncode><Scn>0</Scn><OSPrivilege>NONE</ OSPrivilege><DBID>1234567890</DBID> <Sql_Text>
select count(*), null, null from sys.default</Sql_Text> </AuditRecord>

Field mapping

This table shows the mapping between the data source and Trellix ESM fields.

Log fields

Trellix ESM fields

STATUS, RETURNCODE

Action

DBID

Database_ID

CLIENT USER, OS$USERID

Destination User

EXTENDEDTIMESTAMP

First Time, Last Time

USERHOST

Host

Message

Message

OBJ$NAME, OBJECTNAME

Object

POLICY NAME

Policy Name

PRIVILEGE

Privileged_User

PROTOCOL

Protocol

RETURNCODE, STATUS

Return_Code

Session ID

Session ID

Signature ID

Signature ID

HOST

Source IP

PORT

Source Port

DATABASE USER, USERID

Source User

SQL TEXT, ACTION

SQL_Statement