Forum Discussion
PWheeler
Mar 02, 2020Copper Contributor
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...
orchee
Mar 02, 2020Iron Contributor
PWheeler You can do it by accessing MS Graph:
https://graph.microsoft.com/v1.0/subscribedSkus
You need to give your account permissions listed here
{
"@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"
}
]
}
]
}
VitalieCiobanu
Jan 20, 2021Brass Contributor
Hi Grzesiek,
Besides Graph and manual export, is there another way to export all licenses for each product and users using these licenses?
We need this data weekly in order to connect it with our internal data for some specific dashboards.
Thank you.
Besides Graph and manual export, is there another way to export all licenses for each product and users using these licenses?
We need this data weekly in order to connect it with our internal data for some specific dashboards.
Thank you.
- orcheeJan 26, 2021Iron Contributor
VitalieCiobanu : Are these options not enough in your case scenario? If you are looking for "click to generate report in csv" option OOTB I have not encountered one yet.
- VitalieCiobanuJan 26, 2021Brass Contributor
orchee Well, at the moment I don't have the time privilege to learn Graph and the manual export works fine, it's just "manual work".
I'm looking for a way to build a connection, like Power Query does, and then only refresh the data.
- orcheeJan 26, 2021Iron ContributorMaybe this can help you:
https://minkus.medium.com/easily-connecting-between-power-query-power-bi-and-microsoft-graph-72333eb95a35