Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Slowly but surely, the Office 365 dev team is adding reporting functionality to their platform, to the delight of admins and managers alike. For admins, it means a lot fewer scripts to write, for managers it means knowing....stuff.
If you have thousands of users, they all consume licenses, it's useful to have a list of assigned licenses...
Most customers very much like to strip licenses from users that haven't logged in since x amount of time.
Especially for companies with geographically dispersed users and inefficient exit procedures, this can save a lot of licensing costs over time by keeping your license pool in sync with your actual number of active information workers.
Toyed a little with Powershell, and ended up with a PowerShell script to generate a license and account overview, like this:

Download
You can download this script for free here:
https://gallery.technet.microsoft.com/office365/Office-365-License-User-8336dc24