--- title: "LOGbinder log format and field mapping" slug: "logbinder-log-format-and-field-mapping" tags: ["ESM", "Reference"] updated: 2026-10-27T15:50:49Z published: 2026-10-27T15:50:49Z canonical: "docs.trellix.com/logbinder-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. # LOGbinder log format and field mapping **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 | :