question

DanielBurt-2526 avatar image
0 Votes"
DanielBurt-2526 asked vipulsparsh-MSFT answered

Filter Sign in by Location in Azure AD

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

azure-ad-msal
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

vipulsparsh-MSFT avatar image
0 Votes"
vipulsparsh-MSFT answered

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

78811-image.png

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

78600-image.png



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.



image.png (73.8 KiB)
image.png (52.0 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.