How to get assignedLicenses from Microsoft Graph

Question

Hi,

I am using a C# program to retrieve user information from Microsoft Graph. Currently I am passing the following URL to get the information I need.

https://graph.microsoft.com/v1.0/users?$filter=accountEnabled eq true&$select=displayName,id

I want to extract only users who have any valid license i.e. exclude users who don't have a license. I don't know how to filter using assignedLicenses on this URL. Can someone please help?

Thanks.

Answer 1

You can use the following query to list only licensed users:

https://graph.microsoft.com/v1.0/users?$filter=assignedLicenses/$count

Do note that this is an "advanced" query, thus it requires the consistencyLevel=eventual header:

https://learn.microsoft.com/en-us/graph/aad-advanced-queries?tabs=http

Answer 2

Hi Robin,

Thanks for reaching out.

There is no such direct way in Graph Api to get only those users which have anyone of the licenses assigned.

However, there are few work arounds which I can suggest you.

• You can use the following graph api end point in case you want to check for a particular license. GET https://graph.microsoft.com/v1.0/users?$select=id,mail,assignedLicenses&$filter=assignedLicenses/any(u:u/skuId eq cbdc14ab-d96c-4c30-b9f4-6ada7cdc1d46) More details can be found out at https://learn.microsoft.com/en-us/graph/api/user-list?view=graph-rest-1.0&tabs=http#example-9-use-filter-to-get-users-who-are-assigned-a-specific-license
• Get all user with license info, you must issue GET request by adding $select=assignedLicenses Get all the users and store it in a list and check where value is present in assigned license field of the response. If the field is empty, then that user does not have any license.

    GET https://graph.microsoft.com/v1.0/users?$select=displayName,givenName,userPrincipalName,assignedLicenses,surname
  

• Thirdly you can try if the following helps you in your use case. getOffice365ActivationsUserDetail api This will give you details in Csv format. More details can be found at following link. https://learn.microsoft.com/en-us/graph/api/reportroot-getoffice365activationsuserdetail?view=graph-rest-1.0&tabs=http. However, if you want to get response in Json format you can refer to beta version of this api mentioned at following link. https://learn.microsoft.com/en-us/graph/api/reportroot-getoffice365activationsuserdetail?view=graph-rest-beta&tabs=http It is not recommended to use Beta endpoints in production applications.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".