Im trying to use Get-AzureADUser to get a list of users that dont and do have alternate email set. The API endpoint for this is https://graph.microsoft.com/v1.0/users?$count=true&$filter=otherMails/$count eq 0 How do I do this in Powershell? Thanks

This query only works with ConsistencyLevel=eventual, and I'm not aware of any way to pass this via the Azure AD module. Use client-side filtering instead?

Powershell AzureAD Get-AzureADUser

Accepted answer

Vasil Michev 100.2K Reputation points MVP

2021-07-12T14:53:21.527+00:00

This query only works with ConsistencyLevel=eventual, and I'm not aware of any way to pass this via the Azure AD module. Use client-side filtering instead?
Please sign in to rate this answer.
Nathan B 21 Reputation points

2021-07-12T14:59:27.677+00:00

Thanks for getting back to me. B y client side filtering do you mean take the result of get all users and filter via bash or another language?

I would be happy to use the graph api with https://graph.microsoft.com/v1.0/users?$count=true&$filter=otherMails/$count eq 0

However I get an error when using the graph explorer.

"message": "Unsupported or invalid query filter clause specified for property 'otherMails' of resource 'User'.",

Vasil Michev 100.2K Reputation points MVP

2021-07-12T15:04:30.197+00:00

Did you add the header?

Nathan B 21 Reputation points

2021-07-13T08:25:48.473+00:00

Thank you I was missing this header. Request now working as expected.
Sign in to comment

Share via

Powershell AzureAD Get-AzureADUser

0 additional answers