Loading table information…
Contribute structured examples for this table using the PowerShell tool. Submit a synthetic example.
EntraIdSpnSignInEvents Schema
Table description
| TableSection | TableType | TableSectionName | Description | Source |
|---|---|---|---|---|
| Itp | Regular | Information about sign-in events initiated by Microsoft Entra ID service principal or managed identities | Defender |
Table retention
| ColdDays | HotDays | TotalInteractiveDays |
|---|---|---|
| 0 | 30 | 30 |
Schema
| Name | Description | Type |
|---|---|---|
| Application | Application that performed the recorded action | String |
| ApplicationId | Unique identifier for the application | String |
| City | City where the client IP address is geolocated | String |
| CorrelationId | Unique identifier of the sign-in event | String |
| Country | Country/Region where the account user is located | String |
| ErrorCode | Contains the error code if a sign-in error occurs. To find a description of a specific error code, visit https://aka.ms/AADsigninsErrorCodes | Int32 |
| GatewayJA4 | The JA4 fingerprint is a hash derived from the TLS Client Hello request. This JA4 fingerprint serves as a unique identifier for the client’s TLS configuration. | 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 |
| IsConfidentialClient | Indicates if the sign in was done via confidential client applications | Boolean |
| IsManagedIdentity | Indicates whether the sign-in was initiated by a managed identity | Boolean |
| Latitude | The north to south coordinates of the sign-in location | String |
| Longitude | The east to west coordinates of the sign-in location | String |
| ReportId | Unique identifier for the event | String |
| RequestId | Unique identifier of the request | String |
| ResourceDisplayName | Display name of the resource accessed. The display name can contain any character. | String |
| ResourceId | Unique identifier of the resource accessed | String |
| ResourceTenantId | Unique identifier of the tenant of the resource accessed | String |
| ServicePrincipalId | Unique identifier of the service principal that performed the action | String |
| ServicePrincipalName | Name of the service principal that initiated the sign-in | String |
| SessionId | Unique number assigned to a user by a website’s server for the duration of the visit or session | String |
| SourceSystem | String | |
| State | State where the sign-in occurred, if available | String |
| TenantId | String | |
| TimeGenerated | DateTime | |
| Timestamp | Date and time when the record was generated | DateTime |
| Type | 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 |
Schema changes
| Date | Action |
|---|---|
| 2026-10-07 | Column TenantId added |
| 2026-10-07 | Column Type added |
| 2026-10-07 | Column SourceSystem added |
| 2026-10-07 | Column TimeGenerated added |
| 2026-03-08 | Column IsConfidentialClient added |
| 2026-02-27 | Column TenantId removed |
| 2026-02-27 | Column Type removed |
| 2026-02-27 | Column SourceSystem removed |
| 2026-02-27 | Column TimeGenerated removed |
| 2026-02-10 | Column UniqueTokenId added |
| 2026-01-02 | Table added to tracking |
Known observations
Value casing varies
Fields: Application, ServicePrincipalName, UniqueTokenId.
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.