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:

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.


Get office 365 licensed users report using 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.
  • Embark on your script-free AD management, reporting, and automation journey with ADManager Plus.
  • By clicking 'Start your free trial now', you agree to processing of personal data according to the Privacy Policy.
  • Thanks
  • Your download should begin automatically in 15 seconds. If not, click here to download manually.

Related Powershell How-to Guides:

The one-stop solution toActive Directory Management and Reporting

Email Download Link