Forum Discussion

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
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 🙂

PWheeler

Copper Contributor

Mar 02, 2020

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?

orchee

Iron Contributor

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 🙂