Query Details

Entra ID Tenant Restriction Failed Signin

Query

// Tenant restriction
SigninLogs
| where ResultType == "5000211"
| project TimeGenerated, ResultType, ResultDescription, UserPrincipalName,ClientAppUsed, AppDisplayName, HomeTenantId, CrossTenantAccessType, IPAddress

About this query

EntraID - Tenant Restriction - Failed sign-in

Query Information

Description

Use the below query to identify failed sign-insto Entra ID due to Tenant restriction policy

References

Microsoft Sentinel

Explanation

This query helps identify failed sign-ins to Entra ID due to Tenant restriction policy. It looks for sign-in logs with a ResultType of "5000211" and then displays relevant information like TimeGenerated, ResultDescription, UserPrincipalName, ClientAppUsed, AppDisplayName, HomeTenantId, CrossTenantAccessType, and IPAddress.

Details

Alex Verboon profile picture

Alex Verboon

Released: June 3, 2024

Tables

SigninLogs

Keywords

SigninLogsResultTypeUserPrincipalNameClientAppUsedAppDisplayNameHomeTenantIdCrossTenantAccessTypeIPAddress

Operators

whereproject

Actions

GitHub