Extract Office 365 License information for all users using Powershell
This script gathers O365 license information for all active users. It will populate fields within a csv for import into Excel which includes UPN, Licenses, whether it is a shared mailbox or not and whether or not the user is blocked. A separate row will be created for each license, with the user’s UPN detailed…