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 |