--- title: "IBM Guardium log format and field mapping" slug: "ibm-guardium-log-format-and-field-mapping" tags: ["ESM", "Reference"] updated: 2026-10-27T15:50:33Z published: 2026-10-27T15:50:33Z canonical: "docs.trellix.com/ibm-guardium-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. # IBM Guardium log format and field mapping **Log format** The expected syslog format for this device is: ``` Date Time Username Application[pid]: Alert based on rule ID ruleDescription|Category: category| Classification: classification|Severity severity|Rule # ruleID [ruleDescription ]|Request Info: [Session start: sessionStart]|Server Type: serverType|Client IP clientIP|ServerIP:serverIP|Client PORT: clientPort|Server Port: serverPort|Net Protocol:netProtocol|DB Protocol: DBProtocol|DB Protocol Version: DBProtocolVersion|DBUser: DBUser|Application User Name AppUserName|Source Program: SourceProgram| Authorization Code: AuthorizationCode|Request Type: requestType|Last Error: lastError|SQL: SQLString|To add to baseline: addBaselineConstruct ``` The expected CEF format for this device is: ``` CEF:0|IBM|Guardium|8.0|%%ruleID|%%ruleDescription|5|rt=%%receiptTimeMills cs1=%%severity cs1Label=Severity cs2=%%serverType cs2Label=Server Type cs3=%%classification cs3Label=Classification cat=%%category app=%%DBProtocol cs4=%%DBProtocolVersion cs4Label=DB Protocol Version suser=%%AppUserName sproc=%%SourceProgram act=%%requestType start=%%sessionStartMills externalId=%%violationID duser=%%DBUser dst=%%serverIP dpt=% %serverPort src=%%clientIP spt=%%clientPort proto=%%netProtocol msg=%%SQLString ``` **Log sample** This is a sample syslog log from an IBM Guardium device: ``` <13>Jan 01 01:01:01 usr123456 guard_sender[0001]: Alert based on rule ID log full sql - US DBAs Oracle#012Category: Classification: Severity INFO #012Rule # 20251 [log full sql - US DBAs Oracle ]#012Request Info: [ Session start: 2001-01-01 01:01:01 Server Type: ORACLE Client: 192.0.2.1 (DEVICENAME1000) Server: 192.0.2.1 (DEVICENAME1000) Client PORT: 0001 Server Port: 0 Service Name: SERVICEOAX1111 Net Protocol: NetProtocolName Protocol: ProtocolName Protocol Version: 9.99 User: sys#012Application User Name :PU=SYS#012Source Program: Application Authorization Code: 0 Request Type: BIND_DATA Last Error: #012SQL: begin sys . command_name . Command_Name ( l0row_id => 11111 , l0row_stamp => 22222222 , row_id => 11111 , row_stamp => 22222222 , txt => 'backup piece handle=/Filepath/ recid=11111 stamp=22222222' , sameline => 0.00 ) ; end ;#012 To add to baseline: This is a sample CEF log from an IBM Guardium device: ``` This is a sample CEF log from an IBM Guardium device: ``` <13>Jan 1 01:01:01 usr123456 guard_sender[0001]: CEF:0|IBM|Guardium|8.0|20322|log full sql - US DBAs MSSQL|5|rt=1420074061000 cs1=INFO cs1Label=Severity cs2=MS SQL SERVER cs2Label=Server Type cs3= cs3Label=Classification cat= app=TDS cs4=8.0 cs4Label=DB Protocol Version suser= sproc= act=SQL_RPC start=1420074061000 externalId=123456789 duser=user2 dst=10.10.10.10 dpt=1234 src=10.10.10.11 spt=1234 proto=TCP msg= [ISDB].[dbo].[sp_ISDB_Obj_AD_AuditEvents_Insert] 'user2','usr123456','Logoff','AMC' ``` **Field mapping** This table shows the mapping between the data source and Trellix ESM. | Log fields | Trellix ESM fields | | --- | --- | | Application | Application | | Severity | Severity | | ClientIP | Source IP | | ClientPort | Source Port | | ServerIP | Destination IP | | ServerPort | Destination Port | | DB user | Source User | | Application User | Destination User | | Net Protocol | Protocol | | Category | Category | | Server | Destination_Hostname | | ExternalID | External_EventID | | Partition | File_Path | | Time, Start, Session Start | First Time, Last Time | | Host | Host | | Msg | Message_Text, Rule Name, SQL_Statement | | ObjectID | Object | | PID | PID | | Rule # | Policy_ID | | Rule Name | Policy_Name | | sproc | Process_Name | | Act, Request Type | Request_Type | | SID | Signature ID | | SQL | SQL_Statement | :