Please help me to Get the list of user license status with real product name rather then cryptic SKU

%3CLINGO-SUB%20id%3D%22lingo-sub-2198362%22%20slang%3D%22en-US%22%3EPlease%20help%20me%20to%20Get%20the%20list%20of%20user%20license%20status%20with%20real%20product%20name%20rather%20then%20cryptic%20SKU%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2198362%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20script%20to%20get%20the%20list%20of%20user%20license%20status%20its%20giving%20me%20%22cryptic%20SKU%22%2C%20Please%20help%20me%20to%20get%20the%20real%20product%20names%20instead%20of%20cryptic%20SKU%20ID%20strings%20like%20%E2%80%9CSPE_E3%E2%80%9D%20(which%20stands%20for%20%E2%80%9CMicrosoft%20365%20E3%E2%80%9D).%26nbsp%3Bpowershell%20script.%20To%20import%20and%20export%20with%20license%20status.%3C%2FP%3E%3CP%3EMany%20thanks%20in%20advance.%3C%2FP%3E%3CP%3EMy%20script%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%24UserCredential%20%3D%20Get-Credential%3CBR%20%2F%3EConnect-MsolService%20-Credential%20%24UserCredential%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet-content%20C%3A%5CUsers%5CAdmin%5CDesktop%5Cconver.csv%20%7C%20foreach%20%7BGet-MsolUser%20-UserPrincipalName%20%24_%20%7C%20Where-Object%20%7B(%24_.licenses).AccountSkuId%20%7D%7D%20%7C%20Select-Object%20UserPrincipalname%2Cislicensed%2C%20%7B%24_.Licenses.AccountSkuId%7D%7C%20Export-csv%20C%3A%5CUsers%5CAdmin%5CDownloads%5CLicensestatus.csv%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2198362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWindows%20PowerShell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello All,

 

I have a script to get the list of user license status its giving me "cryptic SKU", Please help me to get the real product names instead of cryptic SKU ID strings like “SPE_E3” (which stands for “Microsoft 365 E3”). powershell script. To import and export with license status.

Many thanks in advance.

My script:

 

$UserCredential = Get-Credential
Connect-MsolService -Credential $UserCredential

 

Get-content C:\Users\Admin\Desktop\conver.csv | foreach {Get-MsolUser -UserPrincipalName $_ | Where-Object {($_.licenses).AccountSkuId }} | Select-Object UserPrincipalname,islicensed, {$_.Licenses.AccountSkuId}| Export-csv C:\Users\Admin\Downloads\Licensestatus.csv

2 Replies
You cannot get the "real product names" directly via PowerShell, though you can "translate" them using the information from this article: https://docs.microsoft.com/en-us/azure/active-directory/active-directory-licensing-product-and-servi...
Hi Vasil,

A script or command to do that in powershell would be more helpful.