Microsoft Office 365 log format and field mapping

Prev Next

Log format

The expected format for this device is:

<Date-Time> <Id> <Operation> <OrganizationId> <RecordType> <ResultStatus> <UserKey> <UserType>
<Version><Workload> <UserId> <ClientIPAddress> <ClientInfoString> <Client> <ExternalAccess>
<InternalLogonType> <LogonType> <LogonUserSid><MailboxGuid> <MailboxOwnerSid> <MailboxOwnerUPN>
<OrganizationName> <OriginatingServer> <Item>

Log sample

This is a sample Microsoft Office 365 log:

{"CreationTime":"2000-01-01T22:00:04","Id":"00000000-0000-0000-0000-000000000000","Operation":"Create",
"Org anizationId":"00000000-0000-0000-0000-000000000000","RecordType":2,"ResultStatus":"Succeeded","UserKey":
"00 00A0AA0A0000A0","UserType":2,"Version":1,"Workload":"Exchange","UserId":"S-1-5-21-0000000000-0000000000-000 
0000000-0000000","ClientIPAddress":"10.10.10.10","ClientInfoString":"Client=WebServices;ExchangeServicesCli ent/ 
00.00.0000.010;","ExternalAccess":false,"InternalLogonType":0,"LogonType":1,"LogonUserSid":"S-1-5-21-000000 
0000-0000000000-0000000000-0000000","MailboxGuid":"00000000-0000-0000-0000-000000000000","MailboxOwnerSid":
"S-1-5-21-0000000000-0000000000-0000000000-2026015","MailboxOwnerUPN":"user1@example.com","OrganizationName ":
"server.example.com","OriginatingServer":"NEWSERVER (00.01.0000.001)\r\n","Item":{"Attachments":"newfile.xls 
(000000)","Id":"AAAAAAAAAAAAA/ AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA",
"ParentFolder": {"Id":"AAAAAAAAAAAAA/AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA","Path":"\\My Folders\\
Personal Folders - 2000\\Jan 2000"},"Subject":"AA00: RTF - AAA "}}

Field mapping

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

Log fields

Trellix ESM fields

CreationTime

first time, last time

ResultStatus

action

Workload

application

ClientIP, ClientIPAddress, ActorIpAddress

source IP address

Operation

sid, msg, sigid

UserId, MailboxOwnerUPN

user name

RecordType

request type

ua, UserAgent

user agent

AzureActiveDirectoryEventType

attribute type

UserType

authentication type

ObjectID

URL

ItemType

object type

OrganizationName

domain

Subject

subject

ExternalAccess

access privileges

ClientApplication

process name

ChannelGuid

instance GUID