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 |