Detailed Office 365 User License Report:ĭetailed Office 365 users’ assigned license report contains user’s Display Name, User Principal Name, License Plan, Friendly-name of License Plan, Service Name, Friendly-name of Service, and Service Status. Office 365 License Report – Sample Outputs:Įxported report shows list of licensed users and their assigned licenses.

You can include more attributes by easily modifying the script. Output file stores most required attributes like Display Name, User Principal Name, Country, Licenses, License Friendly Name, Service, Service Friendly Name, and Service Status.One with the detailed report of O365 Licensed users another with the simple details. The script can be executed with MFA enabled account.License Name is shown with its friendly name like ‘Office 365 Enterprise E3’ rather than ‘ENTERPRISEPACK’.You can choose to either “export license report for all office 365 users” or pass an input file to get license report of specific users alone.Exports Office 365 user license report to CSV file.Download Script: O365UserLicenseReport Script Highlights:

So! Let’s jump into the script right away. It reports all licensed users with their country, assigned licenses, services, and its status. We have created a PowerShell script that will get you the detailed license usage report covering all the above cases.

License subscription names are not user-friendly by default.

Some services might be enabled or disabled based on user needs.

A user might not have access to all services.

Each license gives access to a set of services.

Now, you can export O365 licensed users to CSV file.ĭo you think it’s easy? Definitely not! Because we need to consider following things before jumping right away. Get-Msoluser will get the details of all Office 365 users and Where condition used to filter out licensed users alone. To ease your work, you can use PowerShell commands. Using the O365 admin portal, you can get user’s license information, but you need to click each user to know about their license subscriptions and service status which is a cumbersome task. As an Office 365 Administrator, often you are in the situation to get all licensed users with their assigned licenses and services.

Office license removal tool