Office 365 report

Copper Contributor

Hi, i have a question. I need to make report from Office 365 admin center. Idealy i want 1 excel table where i ll have User name, User license and date when license was activated. Is this posible to do in powershell? I know how to make report with only user name and license, but i dont know about the date.

2 Replies

We've covered this before: https://techcommunity.microsoft.com/t5/Admin-Center/See-the-assignment-date-of-a-license/m-p/153369

 

TL;DR, to get the actual assignment date, you need to crawl the audit logs. But you can report on the assignment date for the individual plans, and usually this is good enough. See the example in the above thread.

@VasilMichev Thank you, at least i know it can be done. Now the hard part to make the script 🙂