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