Email Download Link

PowerShellGet Office 365 user license report using PowerShell

Get Office 365 user license report using PowerShell

The following is a comparison between obtaining Office 365 user license details with Windows PowerShell and ADManager Plus:

Windows PowerShell

Steps to obtain Office 365 user license reports using PowerShell:

Identify the Office 365 tenant from which you want to retrieve the report.
Identify the cmdlets you need to fetch the report.
Compile the script.
Execute it in Windows PowerShell.
The report will be exported in the given format.
To obtain the report in a different format, modify the script according to the needs of the user.

Sample Windows PowerShell script:

Copied

Get-MsolUser -All | where {$_.isLicensed -eq $true}

Click to copy entire script

ADManager Plus

Steps to obtain Office 365 user licenses:

Click Office 365 -> License Reports ->Licensed users.
Select the desired Office 365 account and click Generate.
Click Generate and export the report in any of the preferred formats.

Screenshot

Generate Microsoft 365 user license report in ADManager Plus

» Start 30-day Free Trial

Following are the limitations to obtain Office 365 licensed users report using native tools like Windows PowerShell:

Adding even minor details to the report—such as adding additional attributes—require scripts to be modified and executed again, which is time-consuming.
Exporting a report in a specific format requires a script to be modified accordingly, which increases the complexity of the scripts.
Troubleshooting is not easy in case of errors.

ADManager Plus can retrieve Office 365 licensed users report in CSV, PDF, HTML, or XLSX format in a simple and intuitively designed UI.

Find information on Office 365 licensed users from preconfigured reports.

Get 30-day free trial.

Related Powershell How-to Guides:

The one-stop solution toActive Directory Management and Reporting

Email Download Link