Sign-In Logs

Sign-In Log Overview

Sign-in logs in Azure can be used to answer questions such as how many users signed into a particular application, the number of failed sign-in attempts, the types of browsers or operating systems used, and which Azure resources were accessed by managed identities and service principals. These logs provide details about who performed the sign-in, how it was done, and what resource was accessed. The types of sign-in logs available include interactive user sign-ins, non-interactive user sign-ins, service principal sign-ins, and managed identity sign-ins. These specific sign-in log types are included in subsequent sub-sections.

Permissions:

Log / Report	Roles	Licenses
Sign-ins	Reports Reader Security Reader Security Administrator Global Reader	All editions of Microsoft Entra ID

SignInLogs Table Schema:

olumn	Type	Description
AADTenantId	string
AlternateSignInName	string	The identification that the user provided to sign in. It may be the userPrincipalName but it's also populated when a user signs in using other identifiers.
AppDisplayName	string	The application name displayed in the Azure Portal.
AppId	string	The application identifier in Azure Active Directory.
AppliedConditionalAccessPolicies	string
AppliedEventListeners	dynamic	Detailed information about the listeners, such as Azure Logic Apps and Azure Functions, that were triggered by the corresponding events in the sign-in event.
AuthenticationContextClassReferences	string	Contains a collection of values that represent the conditional access authentication contexts applied to the sign-in.
AuthenticationDetails	string	The result of the authentication attempt and additional details on the authentication method.
AuthenticationMethodsUsed	string	The authentication methods used. Possible values: SMS, Authenticator App, App Verification code, Password, FIDO, PTA, or PHS.
AuthenticationProcessingDetails	string	Additional authentication processing details, such as the agent name in case of PTA/PHS or Server/farm name in case of federated authentication.
AuthenticationProtocol	string	Lists the protocol type or grant type used in the authentication. The possible values are: none, oAuth2, ropc, wsFederation, saml20, deviceCode. For authentications that use protocols other than the possible values listed, the protocol type is listed as none.
AuthenticationRequirement	string	This holds the highest level of authentication needed through all the sign-in steps, for sign-in to succeed.
AuthenticationRequirementPolicies	string	Sources of authentication requirement, such as conditional access, per-user MFA, identity protection, and security defaults.
AutonomousSystemNumber	string	The Autonomous System Number (ASN) of the network used by the actor.
_BilledSize	real	The record size in bytes
Category	string
ClientAppUsed	string	The legacy client used for sign-in activity. For example: Browser, Exchange ActiveSync, Modern clients, IMAP, MAPI, SMTP, or POP.
ConditionalAccessPolicies	dynamic	A list of conditional access policies that are triggered by the corresponding sign-in activity.
ConditionalAccessStatus	string	The status of the conditional access policy triggered. Possible values: success, failure, or notApplied.
CorrelationId	string	The identifier that's sent from the client when sign-in is initiated. This is used for troubleshooting the corresponding sign-in activity when calling for support.
CreatedDateTime	datetime	The date and time the sign-in was initiated. The Timestamp type is always in UTC time. For example, midnight UTC on Jan 1, 2014 is 2014-01-01T00:00:00Z.
CrossTenantAccessType	string	Describes the type of cross-tenant access used by the actor to access the resource.
DeviceDetail	dynamic	The device information from where the sign-in occurred. Includes information such as deviceId, OS, and browser.
DurationMs	long
FlaggedForReview	bool	During a failed sign in, a user may click a button in the Azure portal to mark the failed event for tenant admins. If a user clicked the button to flag the failed sign in, this value is true.
HomeTenantId	string	The tenant identifier of the user initiating the sign in. Not applicable in Managed Identity or service principal sign ins.
Id	string	The identifier representing the sign-in activity.
Identity	string	The display name of the actor identified in the signin.
IPAddress	string	The IP address of the client from where the sign-in occurred.
IPAddressFromResourceProvider	string	The IP address a user used to reach a resource provider, used to determine Conditional Access compliance for some policies. For example, when a user interacts with Exchange Online, the IP address Exchange receives from the user may be recorded here. This value is often null.
_IsBillable	string	Specifies whether ingesting the data is billable. When _IsBillable is false ingestion isn't billed to your Azure account
IsInteractive	bool	Indicates whether a user sign in is interactive. In interactive sign in, the user provides an authentication factor to Azure AD. These factors include passwords, responses to MFA challenges, biometric factors, or QR codes that a user provides to Azure AD or an associated app. In non-interactive sign in, the user doesn't provide an authentication factor. Instead, the client app uses a token or code to authenticate or access a resource on behalf of a user. Non-interactive sign ins are commonly used for a client to sign in on a user's behalf in a process transparent to the user.
IsRisky	bool
Level	string
Location	string	The 2 letter country code from where the sign-in occurred. Depending on IP address provided, this value may not always resolve to a city or region level of detail.
LocationDetails	dynamic	Provides the city, state, country/region and latitude and longitude from where the sign-in happened.
MfaDetail	dynamic	This property is deprecated.
NetworkLocationDetails	string	The network location details including the type of network used and its names.
OperationName	string
OperationVersion	string
OriginalRequestId	string	The request identifier of the first request in the authentication sequence.
ProcessingTimeInMilliseconds	string
Resource	string
ResourceDisplayName	string	The name of the resource that the user signed in to.
ResourceGroup	string
ResourceId	string	The identifier of the resource that the user signed in to.
ResourceIdentity	string	The resource that the user signed in to.
ResourceProvider	string
ResourceServicePrincipalId	string	The identifier of the service principal representing the target resource in the sign-in event.
ResourceTenantId	string	The tenant identifier of the resource referenced in the sign in.
ResultDescription	string	Provides the error message or the reason for failure for the corresponding sign-in activity.
ResultSignature	string
ResultType	string	Provides the 5-6 digit error code that's generated during a sign-in event. 0 indicates success; other values are failures. You can find more information using the Azure AD Error Codes documentation or https://login.microsoftonline.com/error.
RiskDetail	string	The reason behind a specific state of a risky user, sign-in, or a risk event. Possible values: none, adminGeneratedTemporaryPassword, userPerformedSecuredPasswordChange, userPerformedSecuredPasswordReset, adminConfirmedSigninSafe, aiConfirmedSigninSafe, userPassedMFADrivenByRiskBasedPolicy, adminDismissedAllRiskForUser, or adminConfirmedSigninCompromised. The value none means that no action has been performed on the user or sign-in so far. Note: Details for this property are only available for Azure AD Premium P2 customers. All other customers are returned hidden.
RiskEventTypes	string	This property is deprecated.
RiskEventTypes_V2	string	The list of risk event types associated with the sign-in. Possible values: unlikelyTravel, anonymizedIPAddress, maliciousIPAddress, unfamiliarFeatures, malwareInfectedIPAddress, suspiciousIPAddress, leakedCredentials, investigationsThreatIntelligence, or generic.
RiskLevel	string
RiskLevelAggregated	string	The aggregated risk level. Possible values: none, low, medium, high, or hidden. The value hidden means the user or sign-in was not enabled for Azure AD Identity Protection. Note: Details for this property are only available for Azure AD Premium P2 customers. All other customers are returned hidden.
RiskLevelDuringSignIn	string	The risk level during sign-in. Possible values: none, low, medium, high, or hidden. The value hidden means the user or sign-in was not enabled for Azure AD Identity Protection. Note: Details for this property are only available for Azure AD Premium P2 customers. All other customers are returned hidden.
RiskState	string	The risk state of a risky user, sign-in, or a risk event. Possible values: none, confirmedSafe, remediated, dismissed, atRisk, or confirmedCompromised.
ServicePrincipalId	string	The application identifier used for sign-in. This field is populated when you are signing in using an application.
ServicePrincipalName	string	The application name used for sign-in. This field is populated when you are signing in using an application.
SessionLifetimePolicies	string	Any conditional access session management policies that were applied during the sign-in event.
SignInIdentifier	string	The identification that the user provided to sign in. It may be the userPrincipalName but it's also populated when a user signs in using other identifiers.
SignInIdentifierType	string	The type of sign in identifier. Possible values are: userPrincipalName, phoneNumber, proxyAddress, qrCode, onPremisesUserPrincipalName.
SourceSystem	string	The type of agent the event was collected by. For example, OpsManager for Windows agent, either direct connect or Operations Manager, Linux for all Linux agents, or Azure for Azure Diagnostics
Status	dynamic	The sign-in status. Includes the error code and description of the error (in case of a sign-in failure).
TimeGenerated	datetime
TokenIssuerName	string	The name of the identity provider. For example, sts.microsoft.com.
TokenIssuerType	string	The type of identity provider. The possible values are: AzureAD, or ADFederationServices, AzureADBackupAuth, ADFederationServicesMFAAdapter, NPSExtension.
Type	string	The name of the table
UniqueTokenIdentifier	string	A unique base64 encoded request identifier used to track tokens issued by Azure AD as they are redeemed at resource providers.
UserAgent	string	The user agent information related to sign-in.
UserDisplayName	string	The display name of the user.
UserId	string	The identifier of the user.
UserPrincipalName	string	The UPN of the user.
UserType	string	Identifies whether the user is a member or guest in the tenant. Possible values are: member and guest.

Microsoft References:

Learn about the sign-in log activity details - Microsoft Entra IDMicrosoftLearn