Log format
The expected syslog format for this device is:
<pri>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 |