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
» 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.