Report licence by user (Office 365)

[PhilippS]

Hello,

maybe someone has an idea 🙂

What I want to show: I want an report, that shows the user and his activated license ( Office 365 ) and perfectly the activation date. I want to create reports monthly, which shows, which user hast a licence active in this month.

I have activated the Microsoft 365 usage analytics for power bi. There are a lot of tables, but I cant find a link, between the table TenantOfficeLicence and maybe UserState.

You see a way? Or do I have to fetch the data with powershell by myself?

Thanks so far

Philipp

[v-juanli-msft · Accepted solution]

Hi @PhilippS 

Is this what you want?

If so, you could get data and reports as below:

https://docs.microsoft.com/en-us/office365/admin/usage-analytics/enable-usage-analytics?view=o365-wo...

https://techcommunity.microsoft.com/t5/office-365/how-do-you-find-the-tenant-id/m-p/89018#

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

fff