Loading table information…
Contribute structured examples for this table using the PowerShell tool. Submit a synthetic example.
MicrosoftGraphActivityLogs Schema
Table description
| TableSection | TableType | TableSectionName | Description |
|---|---|---|---|
| Other hunting tables | Microsoft Graph Activity Logs provide details of API requests made to Microsoft Graph for resources in the tenant. |
Schema
| Name | Description | Type |
|---|---|---|
| _BilledSize | Double | |
| _IsBillable | String | |
| AadTenantId | The Azure AD tenant ID. | String |
| ApiVersion | The API version of the event | String |
| AppId | The identifier for the application. | String |
| ATContent | Reserved for future use. | String |
| ATContentH | Reserved for future use. | String |
| ATContentP | Reserved for future use. | String |
| ClientAuthMethod | Indicates how the client was authenticated. For a public client, the value is 0. If client ID and client secret are used, the value is 1. If a client certificate was used for authentication, the value is 2. | Int32 |
| ClientRequestId | Identifier for the client request sent; if none is available, the operation identifier is used instead | String |
| ConditionalAccessStatus | Status of the conditional access policies applied to the sign-in. Possible values are 0 (policies applied), 1 (attempt to apply policies failed), or 2 (policies not applied). | String |
| DeviceId | Unique identifier for the device in Microsoft Defender for Endpoint | String |
| DurationMs | The duration of the request in milliseconds. | Int32 |
| IdentityProvider | Identity provider that authenticated the subject of the token | String |
| IPAddress | IP addresses of the clients on which the activity was performed; can contain multiple Ips if related to Microsoft Defender for Cloud Apps alerts | String |
| Location | City, country, or other geographic location associated with the event | String |
| OperationId | Identifier for a batch of requests; the same identifier is used for all requests in a batch but if requests are non-batched, the identifier is unique per request | String |
| RequestId | Unique identifier of the request | String |
| RequestMethod | HTTP method of the request | String |
| RequestUri | Uniform resource identifier (URI) of the request | String |
| ResponseSizeBytes | The size of the response in Bytes. | Int32 |
| ResponseStatusCode | HTTP response status code for the request | Int32 |
| Roles | The roles in token claims. | String |
| Scopes | Scopes in token claims | String |
| ServicePrincipalId | Unique identifier of the service principal that performed the action | String |
| SessionId | Unique number assigned to a user by a website’s server for the duration of the visit or session | String |
| SignInActivityId | The identifier representing the sign-in activitys. | String |
| SourceSystem | String | |
| TenantId | Unique identifier of the tenant into which the data connector ingests data. | String |
| TimeGenerated | The date and time the request was received. | DateTime |
| TokenIssuedAt | The timestamp the token was issued at. | DateTime |
| Type | The certificate’s type. It is one of the following: Machine, Server, Intermediate, Root, TrustedPublisher or Other | String |
| UniqueTokenId | A unique identifier for the token passed during sign-in. This identifier is used to correlate the sign-in with the token request. | String |
| UserAgent | User agent information from the web browser or other client application | String |
| UserId | The identifier of the user making the request. | String |
| Wids | Denotes the tenant-wide roles assigned to this user. | String |
Schema changes
| Date | Action |
|---|---|
| 2026-10-28 | Column ConditionalAccessStatus added |
| 2026-10-07 | Table added to tracking |
| 2026-01-02 | Table removed from tracking |
| 2024-10-18 | Table added to tracking |
Known observations
Value casing varies
Fields: RequestUri, SignInActivityId.
Values in this field have been observed with different casing. Choose comparison behavior according to the meaning of the value and the query intent.
Sources: Olaf Hartong.