Filter Sign in by Location in Azure AD

Dan Burt 21 Reputation points

Hi Is there a way I can see all logins not from GB locations, I see you can filter by location but not exclude a location. We get thousands off logins so it would take a while to export through the interface? Thanks Dan

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,529 questions
0 comments No comments
{count} votes

Accepted answer
  1. VipulSparsh-MSFT 16,251 Reputation points Microsoft Employee

    @Daniel Burt Under normal reports you would not be able to exclude the location. If you are using Log analytics and sending your Sign in logs to Workspace, you might be able to do it,

    You can use a KQL query (Kusto query language ) to find sign in logs and exclude particular location.


    Do note that exporting sign in logs will need Azure AD P1 or P2.



    If the suggested response helped you resolve your issue, please do not forget to accept the response as Answer and "Up-Vote" for the answer that helped you for benefit of the community.

    0 comments No comments

0 additional answers

Sort by: Most helpful