admin管理员组

文章数量:1318563

We are currently getting a CSV file which lists all the users of the anization along with their Office 365 Licenses. It is in below format:

[email protected], "Cena, John", contaso:STANDARDPACK
[email protected], "Brownie, David", contaso:ENTERPRISEPACK

The process that is generating this file is getting deprecated. We have been asked to use Microsoft Graph API.

Which Microsoft Graph API REST endpoint will give me the above information?

We are currently getting a CSV file which lists all the users of the anization along with their Office 365 Licenses. It is in below format:

[email protected], "Cena, John", contaso:STANDARDPACK
[email protected], "Brownie, David", contaso:ENTERPRISEPACK

The process that is generating this file is getting deprecated. We have been asked to use Microsoft Graph API.

Which Microsoft Graph API REST endpoint will give me the above information?

Share Improve this question edited Jan 21 at 10:46 Sridevi 22.6k1 gold badge10 silver badges27 bronze badges Recognized by Microsoft Azure Collective asked Jan 21 at 10:41 CleanBoldCleanBold 1,6022 gold badges17 silver badges39 bronze badges
Add a comment  | 

1 Answer 1

Reset to default 0

Based on this documentation:

  • Office 365 E1 (STANDARDPACK) has skuId 18181a46-0d4e-45cd-891e-60aabd171b4e
  • Office 365 E3 (ENTERPRISEPACK) has skuId 6fd2c87f-b296-42f0-b197-1e91e994b900

skuId is like product id

To filter users with the Office 365 E1 license

https://graph.microsoft/v1.0/users?$filter=assignedLicenses/any(l:l/skuId eq 18181a46-0d4e-45cd-891e-60aabd171b4e)&$select=id,displayName,userPrincipalName,assignedLicenses

To filter users with the Office 365 E3 license

https://graph.microsoft/v1.0/users?$filter=assignedLicenses/any(l:l/skuId eq 6fd2c87f-b296-42f0-b197-1e91e994b900)&$select=id,displayName,userPrincipalName,assignedLicenses

本文标签: azureMicrosoft Graph API REST endpoint for Office 365 LicenseStack Overflow