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 |