Azure Sign-in Logs – Use Wildcards and Filter Specific countries from search criteria

Unfortunately the Country Filter in the Azure AS Sign in Logs is hard match , ( not contains )

So you either have to download the logs to Excel and use filtering in there

You can download and filter in Excel.

Or use the Log Analytics workspace where the Azure AD sign in Logs are going to query this with country code

| where (LocationDetails["countryOrRegion"]) == "AU"
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)