Filter Sign in by Location in Azure AD

Question

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

Answer 1

@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.