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.

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 submitting 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 Email the ADManager Plus download link