fetch the stringid

Question

Hi All,

I need to find the string IDs for the following subscriptions. For example, the string ID for Office 365 E5 is ENTERPRISEPREMIUM, and for Office 365 E3 it is ENTERPRISEPACK. Please guide me on how to obtain the string IDs for the products listed below?

Visual Studio Enterprise

Visual Studio Enterprise with GitHub Enterprise

Visual Studio Professional with GitHub Enterprise

Visual Studio Professional

Visual Studio Test Professional

MSDN Platforms

Answer 1

Hi Glenn,

You can check Product names and service plan identifiers for licensing, or you can use Powershell as follows.

# Connect to Graph.
Connect-MgGraph

# Get license skus
$licenseSkus

# Download the document from Microsoft
$translationTable

# Foreach Sku in your tenant, get the Friendly name.
$skus
foreach
    
}

Be careful in Product_Display_Name. You'll see I've added  because it is being read from the file. Possibly a weird character.

The output should look like this.

Product_Display_Name                      String_Id
-----------------------                      ---------
Visio Plan 2                                 VISIOCLIENT
Microsoft Stream                             STREAM
Power BI Pro                                 POWER_BI_PRO
Microsoft Copilot for Microsoft 365          Microsoft_365_Copilot
Windows Store for Business                   WINDOWS_STORE
Office 365 E3                                ENTERPRISEPACK
Microsoft Power Automate Free                FLOW_FREE
Microsoft Power Apps Plan 2 Trial            POWERAPPS_VIRAL
Microsoft Teams Premium Introductory Pricing Microsoft_Teams_Premium

Enjoy!