Microsoft Graph signIn log format and field mapping

Prev Next

Log format:

{
  "id": "String (identifier)",
  "createdDateTime": "String (timestamp)",
  "appDisplayName": "String",
  "appId": "String",
  "ipAddress": "String",
  "clientAppUsed": "String",
  "correlationId": "String",
  "conditionalAccessStatus": "string",
  "appliedConditionalAccessPolicies": [{"@odata.type": "microsoft.graph.appliedConditionalAccessPolicy"}],
  "isInteractive": true,
  "deviceDetail": {"@odata.type": "microsoft.graph.deviceDetail"},
  "location": {"@odata.type": "microsoft.graph.signInLocation"},
  "riskDetail": "string",
  "riskLevelAggregated": "string",
  "riskLevelDuringSignIn": "string",
  "riskState": "string",
  "riskEventTypes": ["string"],
  "riskEventTypes_v2": ["String"],
  "resourceDisplayName": "string",
  "resourceId": "string",
  "status": {"@odata.type": "microsoft.graph.signInStatus"},
  "userDisplayName": "string",
  "userId": "string",
  "userPrincipalName": "string"
}

Example log:

{
  "id": "66ea54eb-6301-4ee5-be62-ff5a759b0100",
  "createdDateTime": "2023-12-01T16:03:35Z",
  "userDisplayName": "Test Contoso",
  "userPrincipalName": "testaccount1@contoso.com",
  "userId": "26be570a-ae82-4189-b4e2-a37c6808512d",
  "appId": "de8bc8b5-d9f9-48b1-a8ad-b748da725064",
  "appDisplayName": "Graph explorer",
  "ipAddress": "131.107.159.37",
  "clientAppUsed": "Browser",
  "correlationId": "d79f5bee-5860-4832-928f-3133e22ae912",
  "conditionalAccessStatus": "notApplied",
  "isInteractive": true,
  "riskDetail": "none",
  "riskLevelAggregated": "none",
  "riskLevelDuringSignIn": "none",
  "riskState": "none",
  "riskEventTypes": [],
  "resourceDisplayName": "Microsoft Graph",
  "resourceId": "00000003-0000-0000-c000-000000000000",
  "status": {
    "errorCode": 0,
    "failureReason": null,
    "additionalDetails": null
  },
  "deviceDetail": {
    "deviceId": "",
    "displayName": null,
    "operatingSystem": "Windows 10",
    "browser": "Edge 80.0.361",
    "isCompliant": null,
    "isManaged": null,
    "trustType": null
  },
  "location": {
    "city": "Redmond",
    "state": "Washington",
    "countryOrRegion": "US",
    "geoCoordinates": {
      "altitude": null,
      "latitude": 47.68050003051758,
      "longitude": -122.12094116210938
    }
  },
  "appliedConditionalAccessPolicies": [
      {
        "id": "de7e60eb-ed89-4d73-8205-2227def6b7c9",
        "displayName": "SharePoint limited access for guest workers",
        "enforcedGrantControls": [],
        "enforcedSessionControls": [],
        "result": "notEnabled"
      },
      {
        "id": "6701123a-b4c6-48af-8565-565c8bf7cabc",
        "displayName": "Medium signin risk block",
        "enforcedGrantControls": [],
        "enforcedSessionControls": [],
        "result": "notEnabled"
      },
    ]
}

Field mapping:

Log fields

ESM fields

resultType

action

status.errorCode

action

clientAppUsed

AppID

userType

ObjectID

category

Category

resourceDisplayName

Category

riskEventTypes.0 riskEventTypes.1

CommandID, Message_Text

createdDateTime

firsttime, lasttime

appDisplayName

Group_Name

deviceDetail.displayName

HostID

deviceDetail.trustType

Message_Text

riskDetail

Message_Text

deviceDetail.operatingSystem - deviceDetail.browser

Operating_System

appliedConditionalAccessPolicies.15.displayName

Organizational_Unit

servicePrincipalName

Organizational_Unit

status.failureReason

Reason

riskLevelDuringSignIn

Severity

appDisplayName

sigdesc

callerIpAddress

src_ip

ipAddress

src_ip

userPrincipalName

UserIDSrc

status.additionalDetails

Sub_Status

userAgent

User_Agent

deviceDetail.browser

User_Agent