Get user count - Graph API

(0) Share

Report

Posted on by da1ve

340

Hi guys,

So I am trying to get a user count for multiple tenants so thought I would run a Graph API query.

I have created the app registration in the target tenants and then running the following in flow:

This is working fine but the problem is I cant differentiate between current and old users. I have set the header to check for accounts that are enabled. This returns active users, archived users (shared mailboxes) as well as guest users. I tried to filter by active domain name using:

https://graph.microsoft.com/v1.0/users?$count=true&$filter=endsWith(mail,'@domain.com')

But that returns

{
 "error": {
 "code": "Request_UnsupportedQuery",
 "message": "Unsupported Query.",
 "innerError": {

According to this MS doc, this should be supported (https://docs.microsoft.com/en-us/graph/query-parameters#filter-parameter)

Any idea where this is going wrong or perhaps you know of a better way to count active users?

Thanks,
David

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Adam-Symplifier 51 on at

Like (1)

Report

You need to add a consistency level header, this function works:
https://graph.microsoft.com/v1.0/users?$count=true&ConsistencyLevel=eventual&$filter=endsWith(mail,'@domain.com')

Also FYI the Graph Explorer is great for repeat testing of API calls https://developer.microsoft.com/en-us/graph/graph-explorer

If this resolves your query please mark this as a solution.

Was this reply helpful? Yes No
da1ve 340 on at

Like (0)

Report

Perfect - thank you @Adam-Symplifier

Was this reply helpful? Yes No