O365 - Export of total number of licenses

%3CLINGO-SUB%20id%3D%22lingo-sub-1358148%22%20slang%3D%22en-US%22%3EO365%20-%20Export%20of%20total%20number%20of%20licenses%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1358148%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20to%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20know%20how%20to%20export%20via%20PowerShell%20from%20O365%20total%20number%20of%20licenses%20with%20following%20parameters%20%3F%3C%2FP%3E%3CUL%3E%3CLI%3Echange%20SkuID%20to%20friendly%20name%3C%2FLI%3E%3CLI%3Enumber%20of%20active%20licenses%3C%2FLI%3E%3CLI%3Enumber%20of%20used%20licenses%3C%2FLI%3E%3CLI%3Eif%20possible%2C%20also%20information%20if%20this%20license%20is%20payed%20monthly%20or%20yearly%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20know%20how%20to%20export%20the%20second%20and%20third%20point%3A%3C%2FP%3E%3CBLOCKQUOTE%3E%3CP%3EGet-MsolAccountSku%20%7C%20ft%20SkuPartNumber%2CActiveUnits%2CConsumedUnits%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3CP%3EBut%20I%20can%20not%20find%20out%20how%20to%20do%20the%20first%20and%20fourth%20%3A(%3C%2Fimg%3E%20..%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20for%20your%20help!%3C%2FP%3E%3CP%3EBest%20regards%2C%20Standa%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1358148%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eexport%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20licensing%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Visitor

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
Highlighted

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