Oracle Audit (syslog) log format and field mapping

Prev Next

Log format

The expected format for this device is as follows:

<Priority Number>Process Name[]: LENGTH: '' ACTION:[] SQLTXT DATABASE USER:[] PRIVILEGE:[] CLIENT USER:[]
CLIENT TERMINAL:[] STATUS:[] DBID:[]

Log sample

This is a sample log from an Oracle Audit device:

<133>Oracle Audit[8435]: LENGTH : '317' ACTION :[168] 'select decode(status, 'OPEN', 1, 0), 
decode(archiver, 'FAILED', 1, 0), decode(database_status, 'SUSPENDED', 1, 0) into :status, :archstuck, 
:dbsuspended from v$instance' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[6] 'oracle' 
CLIENT TERMINAL:[0] '' STATUS:[1] '0' DBID:[10] '1234567890'

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

Log fields

Trellix ESM fields

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