LOGbinder log format and field mapping

Prev Next

Log format (Sharepoint)

The expected formats for this device is:

Syslog:

syslogTimestamp syslogHost signatureID LOGbinder SP|deviceVersion|type|eventTimestamp|message|name=“key1” label=“Key 1” value=“value1”|name=“key2” label=“Key 2” value=“value2”|…

CEF:

CEF:version|LOGbinder|SP|deviceVersion|signatureID|message key1=value1 key2=value2…

Log format (Exchange)

The expected format for this device is:

Syslog:

syslogTimestamp syslogHost signatureID LOGbinder EX|deviceVersion|type|eventTimestamp|message|name=“key1” label=“Key 1” value=“value1”|name=“key2” label=“Key 2” value=“value2”|…

CEF:

CEF:version|LOGbinder|EX|deviceVersion|signatureID|message key1=value1 key2=value2…

Log format (SQL)

The expected format for this device is:

Syslog:

syslogTimestamp syslogHost signatureID LOGbinder SQL|deviceVersion|type|eventTimestamp|message|name=“key1” 
label=“Key 1” value=“value1”|name=“key2” label=“Key 2” value=“value2”|…

CEF:

CEF:version|LOGbinder|SQL|deviceVersion|signatureID|message key1=value1 key2=value2…

Log sample (Exchange)

This is a sample log from a LOGbinder EX device:

Syslog:

Jan 01 01:01:01 192.0.2.1 25190 LOGbinder EX|2.0|success|2015-01-01T01:01:01.0000001-00:00|
New-AdminAuditLogSearch Exchange cmdlet issued|name="occurred" label="Occurred" value="1/1/2015 1:01:01
AM"|name="cmdlet" label="Cmdlet" value="New-AdminAuditLogSearch"|name="performedby" label="Performed By" 
value="testUser"|name="succeeded" label="Succeeded" value="Yes"|name="error" label="Error" value="n/a"| 
name="originatingserver" label="Originating Server" value="DEV1 (198.51.100.1)"|name="objectmodified" 
label="Object Modified" value="AuditLogSearch\\f8376002-c01c-45e3-ad9c-0c1dd7cfe780"|name="parameters" 
label="Parameters" value="Name: StartDate, Value: [1/1/2015 1:01:01 AM]Name: EndDate, Value: [9/6/2013 
6:55:00 PM]Name: StatusMailRecipients, Value: [test@test.com]Name: Name, Value:
[8e41b65d-46ee-4f41-9e4d-f8996c19ce04]"|name="properties" label="Modified Properties" value="n/a"| 
name="additionalinfo" label="Additional Information" value="CmdletParameters/Parameter/Name\= [StartDate];
CmdletParameters/Parameter/Value\= [1/1/2015 1:01:01 AM]; CmdletParameters/Parameter/Name\= [EndDate];
CmdletParameters/Parameter/Value\= [1/1/2015 1:01:06 AM]; CmdletParameters/Parameter/Name\=
[StatusMailRecipients]; CmdletParameters/Parameter/Value\= [test@test.com]; CmdletParameters/Parameter/Name
\= [Name]; CmdletParameters/Parameter/Value\= [8e41b65d-46ee-4f41-9e4d-f8996c19ce04]"|name="support" 
value="For more information, see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/ 
event.aspx?eventid=25190"

CEF:

Jan 01 01:01:01 192.0.2.1 CEF:0|LOGbinder|EX|3.0|25190|New-AdminAuditLogSearch Exchange cmdlet 
issuedrt=1/1/2015 1:01:01 AM act=Error suser=testUser outcome=Yes msg=New-AdminAuditLogSearch 
Exchange cmdlet issued dvchost=DEV1 fname= AuditLogSearch\\f8376002-c01c-45e3-ad9c-0c1dd7cfe780 
filePermission=n/a cs4=n/a cs4Label=Modified Properties cs3= name="additionalinfo" label="Additional 
Information" value="CmdletParameters/Parameter/Name\= [StartDate]; CmdletParameters/Parameter/Value\= 
[1/1/2015 1:01:01 AM]; CmdletParameters/Parameter/Name\= [EndDate]; CmdletParameters/Parameter/Value\= 
[1/1/2015 1:01:06 AM]; CmdletParameters/Parameter/Name\= [StatusMailRecipients]; CmdletParameters/Parameter/
Value\=[test@test.com]; CmdletParameters/Parameter/Name\= [Name]; CmdletParameters/Parameter/Value\=
[8e41b65d-46ee-4f41-9e4d-f8996c19ce04]" cs3Label=Additional Info reason=For more information, 
see http:// www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=25190

Log sample (SharePoint)

This is a sample log from a LOGbinder SP device:

Syslog:

Jan 01 01:01:01 192.0.2.1 65 LOGbinder SP|5.1|success|2015-01-01T01:01:01.0000001-00:00|Item declared 
as a record|name="occurred" label="Occurred" value="2015-01-01T01:01:01.0000001-00:00"|name="site" 
label="Site" value="testSite"|name="user" label="User" value="testUser"|name="objecturl" label="Object URL" 
value="\\testSite\place\thing\"|name="support" value="For more information, see http:// 
www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=65"

CEF:

Jan 01 01:01:01 192.0.2.1 CEF:0|LOGbinder|SP|5.1|65|Item declared as a recordrt=2015-01-01T01:01:01.0000001-00:00 
request=testSite duser=testUser filePath=\\testSite\place\thing\ reason=For more information, 
see http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/ event.aspx?eventid=65

Log sample (SQL)

This is a sample log from a LOGBinder SQL device:

SQL:

Jan 01 01:01:01 192.0.2.1 24000 LOGbinder SQL|2.0|failure|2015-01-01T01:01:01.0000001-00:00|SQL audit 
event|name="occurred" label="Occurred" value="1/1/2015 1:01:01.0000000 AM"|name="action_id" label="Action" 
value="RWC"|name="succeeded" label="Succeeded" value="False"|name="permissionbitmask" label="Permission 
bitmask" value="16"|name="iscolumnpermission" label="Is column permission" value="False"|name="sessionid" 
label="Session ID" value="78"|name="serverprincipalid" label="Server Principal ID" value="2"| name=
"databaseprincipalid" label="Database Principal ID" value="1"|name="targetserverprincipalid" label="Target 
Server Principal ID" value="0"|name="targetdatabaseprincipalid" label="Target Database Principal ID" 
value="0"|name="objectid" label="Object ID" value="n/a"|name="classtype" label="Class Type" value="n/a"
|name="sessionserverprincipalname" label="Session Server Principal Name" value="LB\\Administrator"|name=
"serverprincipalname" label="Server Principal Name" value="LB\\Administrator"| name="serverprincipalsid" 
label="Server Principal SID" value="n/a"|name="databaseprincipalname" label="Database Principal Name" 
value="2015-01-01T01:01:01.0000001"|name="targetserverprincipalname" label="Target Server Principal Name" 
value="dbo"|name="targetserverprincipalsid" label="Target Server Principal SID" value="n/a"|name=
"targetdatabaseprincipalname" label="Target Database Principal Name" value="n/a"|name="serverinstancename" 
label="Server Instance Name" value="n/a"|name="databasename" label="Database Name" value="DEV2"|name=
"schemaname" label="Schema Name" value="master"|name="objectname" label="Object Name" value="n/a"|name=
"statement" label="Statement" value="n/a"| name="additionalinformation" label="Additional Information" 
value="REVOKE ALTER ON XML SCHEMA COLLECTION:: [dbo].[$(SchemaCollectionName)] TO [$(UserName2)] 
CASCADE"|name="support" value="For more information, see 
http://www.ultimatewindowssecurity.com/securitylog/encyclopedia/event.aspx?eventid=24000"

CEF:

Sep 23 15:46:10 host CEF:0|LOGbinder|SQL|2.0|24000|SQL audit eventrt=1/1/2015 1:01:01.0000000 AM cfp1=RWA 
cfp1Label=Action oldFileId=False filePermission=16 fileHash=N/A dpid=78 suid=1 cn3=1 cn3Label=Database
Principal ID cn1=1 cn1Label=Target Server Principal ID cn2=0 cn2Label=Target Database Principal ID 
fileId=n/a cfp2=n/a cfp2Label=Class Type duser=LB\\Administrator suser=n/a spriv=n/acs2=2015-01-01T01:01:01.0000001 
cs2Label=Database Principal Name cs4=n/a cs4Label=Target Server Principal Name cs3=1 cs3Label=Target 
Server Principal SID cs5=0 cs5Label=Target Database Principal Name deviceExternalId=n/a filePath=n/a 
cs6=master cs6Label=Schema Name fname=n/a cs1=n/a cs1Label=Statement reason=n/a reason=For more information, 
see http://www.ultimatewindowssecurity.com/securitylog/ encyclopedia/event.aspx?eventid=24000

Field mapping (Exchange)

This table shows the mapping between the data source and Trellix ESM fields.

Log fields

Trellix ESM fields

Signature ID

Signature ID

rt | occurred

First Time | Last Time

src | ClientIPAddress

Source IP

Cmdlet

Command

oldFileId | folderid

Filename

deviceHostName | dvchost | originatingserver

Host

fname | objectmodified

Object

suser | performedby

Source User

Suid

Security_ID

sproc | clientprocess

Process_Name

performedlogonType

Logon Type

Mailboxguid

Instance GUID

itemsubject

Subject

Field mapping (Sharepoint)

This table shows the mappings between the data source and Trellix ESM fields.

Log fields

Trellix ESM fields

Signature ID

Signature ID

rt | occurred

First Time | Last Time

fname | fileName | objecttitle

Filename

site | request

Object

user | duser | requestedby | membername | administratorname

Destination User

suser | user

Source User

objecturl | filepath

URL

source | filepath

File_Path

newauditpolicy

Policy_Name

Field mapping (SQL)

This table shows the mappings between the data source and Trellix ESM fields.

Log fields

Trellix ESM fields

Signature ID

Signature ID

rt | occurred

First Time | Last Time

cfp1 | action_id

Device_Action

FileId | succeeded

Action

duser | sessionserverprincipalname

Destination User

dpid | sessionid

Session ID

Schemaname

Database_Name

Memberdomainname

Domain

Targetobjectname

Object

suser | member | targetobjectname

Source User

deviceExternalId | server

External_Device_ID