Forum Discussion
Report licence by user (Office 365)
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
Hi Anonymous
Is this what you want?
If so, you could get data and reports as below:
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
1 Reply
Hi Anonymous
Is this what you want?
If so, you could get data and reports as below:
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