O365 - Export of total number of licenses

[StandaCZE]

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

[#2]

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...