IBM Guardium log format and field mapping

Prev Next

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