I'm trying to help our accounting department by creating a monthly report that shows user counts per department and the total cost associated with each user's licenses in MS365. I've been attempting to create a PowerShell script to automate this, but I'm struggling. Does anyone have a script they can share or can you point me to a tool that might help with this?
1 Answer
You might want to check out the admin portal. I believe you can find an option under Billing > View Subscriptions/Licenses > Generate Report. It's a pretty handy feature for auditing, and it should provide you with the details you need without too much hassle.
That would be super helpful.