Forum Discussion
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...
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"
}
]
}
]
}
orchee I'm clearly going to have to do some reading up on Graph - that looks very powerful.
This endpoint though seems limited to summary data - number of each licence type.
I'm after something closer to the export data from the management console - A list of users for each licence type with data about last use timestamp and date created.
I will find a few hours to go through the Graph endpoints but, off the top of your head, do you know if this is possible?