Loading table information…
Contribute structured examples for this table using the PowerShell tool. Submit a synthetic example.
AADGraphActivityLogs Schema
Table description
| TableSection | TableType | TableSectionName | Description | Source |
|---|---|---|---|---|
| Usx | Regular | LogManagement | AAD Graph Activity Logs provide details of legacy API requests made to Azure Active Directory Graph for resources in the tenant. | Sentinel |
Table retention
| HotDays | ColdDays | TotalInteractiveDays |
|---|---|---|
| 14 | 76 | 90 |
Schema
| Name | Description | Type |
|---|---|---|
| _BilledSize | Double | |
| _IsBillable | String | |
| _ResourceId | A unique identifier for the resource that the record is associated with | String |
| _SubscriptionId | A unique identifier for the subscription that the record is associated with | String |
| AADTenantId | The identifier of the tenant where the request was made. | String |
| ActorType | The type of actor making the request (e.g., User, Application). | String |
| ApiVersion | The API version of the operation. | String |
| AppId | The identifier of the application making the request. | String |
| CallerIpAddress | The IP address of the caller making the request. | String |
| Category | The log category, e.g., AzureADGraphActivityLogs. | String |
| ClientAuthMethod | The authentication method used by the client. | String |
| DeviceId | The identifier of the device used in the request. | String |
| DurationMs | The duration of the request in milliseconds. | Int32 |
| IdentityProvider | The identity provider used during authentication. | String |
| Level | The severity level of the event (e.g., Informational). | String |
| Location | The name of the region that served the request. | String |
| OperationName | The name of the operation performed on the resource. | String |
| RequestId | The identifier representing the request. | String |
| RequestMethod | The HTTP method used (e.g., GET, POST). | String |
| RequestUri | The URI of the request sent to the AAD Graph API. | String |
| ResponseSizeBytes | The size of the response returned to the caller, in bytes. | Int32 |
| ResponseStatusCode | The HTTP status code returned in the response. | Int32 |
| ResultSignature | The HTTP response status or outcome of the operation. | String |
| Roles | The roles assigned in the token claims. | String |
| Scopes | The scopes included in the token claims. | String |
| ServicePrincipalId | The identifier of the service principal making the request. | String |
| SessionId | The session identifier from the request context. | String |
| SignInActivityId | The identifier representing the sign-in activity. | 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 |
| TimeRequested | The timestamp when the request was made. | DateTime |
| TokenIssuedAt | The timestamp when the token was issued. | DateTime |
| Type | The name of the table | String |
| UserAgent | The user agent string provided by the client. | String |
| UserId | The identifier of the user making the request. | String |
| Wids | The WIDs from the token claims. | String |
Schema changes
| Date | Action |
|---|---|
| 2026-10-08 | Table added to tracking |
Known observations
SignInActivityId formats
Fields: SignInActivityId.
SignInActivityId can contain padded token identifiers and GUID-shaped values. Remove trailing Base64 padding when correlating token identifiers and preserve case. Padding removal does not convert GUID-shaped values into token identifiers. Inspect unmatched GUID-shaped values separately.
Compare nonempty token identifiers with exact equality after removing only trailing Base64 padding. Keep tenant, actor, application, and time context.
Sources: Cloudbrothers: Now You See Me - AADGraphActivityLogs, Invictus IR: The missing link - AADGraphActivityLogs finally arrives.
AADGraphActivityLogs
| where TimeGenerated > ago(90d)
| summarize by SignInActivityId
| summarize
Padded=countif(SignInActivityId endswith "=="),
GUID=countif(SignInActivityId matches regex @"^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$"),
TotalUnique=dcount(SignInActivityId)