Forum Discussion

PWheeler's avatar
PWheeler
Copper Contributor
Mar 02, 2020
Solved

O365 licensing datasource?

I'd like to access my O365 licensing data in a more efficient way.  Currently I go to the admin console, go to a licence type, E3 for example, hit export and then import the resulting csv into Excel...
office 365
  • orchee's avatar
    orchee
    Mar 02, 2020

    PWheeler So there is List License details for users -> https://docs.microsoft.com/en-us/graph/api/user-list-licensedetails?view=graph-rest-1.0&tabs=http 

     

    If you want to go deeper on usage, then you need to go through usage reports, so just keep your expectations low on more details 🙂

orchee's avatar
orchee
Iron Contributor
Mar 02, 2020

PWheeler You can do it by accessing MS Graph:
https://graph.microsoft.com/v1.0/subscribedSkus

 

You need to give your account permissions listed https://docs.microsoft.com/en-us/graph/api/subscribedsku-list?view=graph-rest-1.0&tabs=http 

{
    "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#subscribedSkus",
    "value": [
        {
            "capabilityStatus": "Enabled",
            "consumedUnits": 1,
            "id": "xxxxx-xxx-xx-xxxxx-xxxxxxxxx-xxx-xxxx-xxx-xxxxxx",
            "skuId": "xxxxxx-xxxxx-xxx-xxxxx-xxxxx",
            "skuPartNumber": "O365_BUSINESS_ESSENTIALS",
            "appliesTo": "User",
            "prepaidUnits": {
                "enabled": 1,
                "suspended": 0,
                "warning": 0
            },
            "servicePlans": [
                {
                    "servicePlanId": "xxxxxx-xxxx-xxxxxx-xxxx-xxxxxxx",
                    "servicePlanName": "MICROSOFT_SEARCH",
                    "provisioningStatus": "Success",
                    "appliesTo": "Company"
                },
                {
                    "servicePlanId": "xxxxxxxx-xxxx-xxxxx-xxx-xxxxxxx",
                    "servicePlanName": "WHITEBOARD_PLAN1",
                    "provisioningStatus": "Success",
                    "appliesTo": "User"
                }
            ]
        }
    ]
}

 

Resources