--- title: "Oracle Audit (SQL) log format and field mapping" slug: "oracle-audit-sql-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-sql-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 (SQL) log format and field mapping **Log format** The expected format for this device is: ``` AUDIT_TYPE="" SESSION_ID="" PROXY_SESSIONID="" STATEMENTID="" ENTRYID="" EXTENDED_TIMESTAMP="" GLOBAL_UID="" DB_USER=" " CLIENT_ID="" ECONTEXT_ID="" EXT_NAME="" OS_USER="" USERHOST="" OS_PROCESS="" TERMINAL="" INSTANCE_NUMBER="" OBJECT_SCHEMA="" OBJECT_NAME="" POLICY_NAME="" NEW_OWNER="" NEW_NAME="" ACTION="" STATEMENT_TYPE="" AUDIT_OPTION="" TRANSACTIONID="" RETURNCODE="" SCN="" COMMENT_TEXT="" SQL_BIND="" SQL_TEXT="" OBJ_PRIVILEGE="" SYS_PRIVILEGE="" ADMIN_OPTION="" OS_PRIVILEGE="" GRANTEE="" PRIV_USED="" SES_ACTIONS="" LOGOFF_TIME="" LOGOFF_LREAD="" LOGOFF_PREAD="" LOGOFF_LWRITE="" LOGOFF_DLOCK="" SESSION_CPU="" OBJ_EDITION_NAME="" DBID="” ``` **Log sample** This is a sample log from an Oracle Audit device: ``` AUDIT_TYPE="Standard Audit" SESSION_ID="1" PROXY_SESSIONID="0" STATEMENTID="1" ENTRYID="1" EXTENDED_TIMESTAMP="2015-01-01 00:00:00.000" GLOBAL_UID="" DB_USER="QA" CLIENT_ID="" ECONTEXT_ID="" EXT_NAME="" OS_USER="root" USERHOST="exampleUser" OS_PROCESS="1000:1000" TERMINAL="unknown" INSTANCE_NUMBER="0" OBJECT_SCHEMA="" OBJECT_NAME="" POLICY_NAME="" NEW_OWNER="" NEW_NAME="" ACTION="100" STATEMENT_TYPE="LOGON" AUDIT_OPTION="" TRANSACTIONID="0013000D00AAFF2" RETURNCODE="0" SCN="0" COMMENT_TEXT="Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.1) (PORT=37063))" SQL_BIND="" SQL_TEXT="" OBJ_PRIVILEGE="" SYS_PRIVILEGE="" ADMIN_OPTION="" OS_PRIVILEGE="NONE" GRANTEE="" PRIV_USED="CREATE SESSION" SES_ACTIONS="" LOGOFF_TIME="" LOGOFF_LREAD="0" LOGOFF_PREAD="0" LOGOFF_LWRITE="0" LOGOFF_DLOCK="" SESSION_CPU="0" OBJ_EDITION_NAME="" DBID="1234567890" ``` This is a sample log from an Oracle Unified Audit device ``` AUDIT_TYPE="Standard Audit" SESSION_ID="1" PROXY_SESSIONID="0" STATEMENTID="1" ENTRYID="1" EXTENDED_TIMESTAMP="2015-01-01 00:00:00.000" ACTION_NAME "ALTER USER" GLOBAL_UID="" CLIENT_PROGRAM_NAME="sqlplus@hostname" DB_USER="TESTUSER" CLIENT_ID="" EXT_NAME="" OS_USER="root" USERHOST="exampleUser" OS_PROCESS="1000:1000" TERMINAL="unknown" DBID="1234567890" AUTHENTICATION_TYPE="(TYPE=(OS));(CLIENT ADDRESS=((ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=54526))))" INSTANCE_NUMBER="0" OBJECT_SCHEMA="" OBJECT_NAME="" POLICY_NAME="" NEW_NAME="" AUDIT_OPTION="" TRANSACTIONID="0013000D00AAFF2" RETURNCODE="0" SCN="0" COMMENT_TEXT="Text comment on the audit trail entry, if any" SQL_BIND="" SQL_TEXT="SELECT SYS_CONTEXT(‘USERENV‘,‘CDB_NAME‘), SYS_CONTEXT(‘USERENV‘, ‘CON_NAME‘) FROM SYS.DUAL" OBJ_PRIVILEGE="" SYS_PRIVILEGE="" ADMIN_OPTION="" PRIV_USED="CREATE SESSION" UNIFIED_AUDIT_POLICIES="ORA_SECURECONFIG, ORA_SECURECONFIG" ``` **Field mapping for DBA_COMMON_AUDIT_TRAIL** This table shows the mapping between the data source and Trellix ESM fields. | Log fields | Trellix ESM fields | | --- | --- | | RETURNCODE | Action, Return_Code | | AUDIT_TYPE | Category | | DBID | Database_ID | | OS_USER | Destination User | | EXTENDED_TIMESTAMP | First Time, Last Time | | USERHOST | Host | | STATEMENT_TYPE | Action, Rule Message | | OBJECT_NAME | Object | | POLICY NAME | Policy Name | | COMMENT_TEXT | Protocol, Source IP, Source Port | | SQL_TEXT | SQL_Statement | | SESSION_ID | Session_ID | | ACTION | SID | | DB_USER | Source User | **Field mapping for UNIFIED_AUDIT_TRAIL** This table shows the mapping between the data source and Trellix ESM fields. | Log fields | Trellix ESM fields | | --- | --- | | RETURN_CODE | Action, Return_Code | | AUDIT_TYPE | Category | | DBID | Database_ID | | OS_USERNAME | Destination User | | EVENT_TIMESTAMP | First Time, Last Time | | USERHOST | Host | | ADDITIONAL_INFO | Message_Text | | OBJECT_NAME | Object | | OBJECT_SCHEMA | Database_Name | | AUTHENTICATION_TYPE | Protocol, Source IP, Source Port | | FGA_POLICY_NAME | Policy_Name | | SESSIONID | Session_ID | | ACTION_NAME | SQL_Command, sid | | CLIENT_PROGRAM_NAME | Application | | Log fields | Trellix ESM fields | | UNIFIED_AUDIT_POLICIES | Rule_Name | | DBUSERNAME | Source User | | SQL_TEXT | SQL_Statement | | SYSTEM_PRIVILEGE_USED | Command | :