--- title: "Oracle Audit (syslog) log format and field mapping" slug: "oracle-audit-syslog-log-format-and-field-mapping" tags: ["ESM", "Reference"] updated: 2026-10-27T15:51:03Z published: 2026-10-27T15:51:03Z canonical: "docs.trellix.com/oracle-audit-syslog-log-format-and-field-mapping" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.trellix.com/llms.txt > Use this file to discover all available pages before exploring further. # Oracle Audit (syslog) log format and field mapping **Log format** The expected format for this device is as follows: ``` 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 | :