O365 - Export of total number of licenses

New Contributor

Hello to all,


Do you know how to export via PowerShell from O365 total number of licenses with following parameters ?

  • change SkuID to friendly name
  • number of active licenses
  • number of used licenses
  • if possible, also information if this license is payed monthly or yearly

I know how to export the second and third point:

Get-MsolAccountSku | ft SkuPartNumber,ActiveUnits,ConsumedUnits

But I can not find out how to do the first and fourth :( ..

Thank you very much for your help!

Best regards, Standa

1 Reply

Billing info is not available via PS, only from the portal. As for "friendly names", you can transform them based on the table here: https://docs.microsoft.com/en-us/azure/active-directory/active-directory-licensing-product-and-servi...