Microsoft 365 License Count

Use Case

Retrieve a count of total consumed and available Microsoft 365 Licenses in your organization.


List Microsoft 365 Total and Available Licenses

Directions

  • Ensure you’ve installed the Azure AD module for Windows PowerShell. Follow this Microsoft post here for info
  • Connect to Azure AD using the command:
Connect-AzureAD
  • Once connected to Azure AD, enter the command:
Get-AzureADSubscribedSku | Select -Property Sku*,ConsumedUnits -ExpandProperty PrepaidUnits
  • Licenses will be listed by SkuID and SkuPart Number. To correlate the SKU to the Microsoft product, see the following Microsoft reference here

Screenshot of sample command output:

Additional Notes

  • The license listing can also be exported to CSV with the following command:
Get-AzureADSubscribedSku | Select-Object -Property Sku*,ConsumedUnits -ExpandProperty PrepaidUnits | export-csv C:\temp\AzureSubscribedSku.csv -notypeinformation

Leave a comment

Your email address will not be published. Required fields are marked *