Private/License/Get-Sku2Service.ps1

function Get-Sku2Service {
    Param (
        [Parameter(Mandatory = $false)]
        [switch] $friendly,

        [Parameter(Mandatory = $false)]
        [switch] $ugly,

        [Parameter(Mandatory = $false)]
        [switch] $both
    )

    $u2fSku = @{
        "ATA"                                = "Azure Advanced Threat Protection for Users"
        "ADALLOM_STANDALONE"                 = "Microsoft Cloud App Security"
        "RIGHTSMANAGEMENT"                   = "AZURE INFORMATION PROTECTION PLAN 1"
        "THREAT_INTELLIGENCE"                = "OFFICE 365 ADVANCED THREAT PROTECTION (PLAN 2)"
        "AX_ENTERPRISE_USER"                 = "AX ENTERPRISE USER";
        "AX_SELF-SERVE_USER"                 = "AX SELF-SERVE USER";
        "AX_SANDBOX_INSTANCE_TIER2"          = "AX_SANDBOX_INSTANCE_TIER2";
        "AX_TASK_USER"                       = "AX_TASK_USER";
        "AAD_PREMIUM"                        = "Azure Active Directory Premium P1";
        "RMS_S_ENTERPRISE"                   = "Azure Active Directory Rights Management";
        "RIGHTSMANAGEMENT_ADHOC"             = "Azure Rights Management Services Ad-hoc";
        "CRMPLAN2"                           = "Dynamics CRM Online Plan 2";
        "EMS"                                = "Enterprise Mobility + Security E3";
        "EMSPREMIUM"                         = "Enterprise Mobility + Security E5";
        "ENTERPRISEPACK_B_PILOT"             = "ENTERPRISEPACK_B_PILOT";
        "EXCHANGEENTERPRISE_FACULTY"         = "Exch Online Plan 2 for Faculty";
        "EXCHANGE_L_STANDARD"                = "Exchange Online (Plan 1)";
        "ATP_ENTERPRISE_FACULTY"             = "Exchange Online Advanced Threat Protection";
        "ATP_ENTERPRISE"                     = "Exchange Online ATP";
        "EXCHANGESTANDARD"                   = "Exchange Online Plan 1";
        "EXCHANGE_S_ENTERPRISE"              = "Exchange Online Plan 2 S";
        "EXCHANGEENTERPRISE"                 = "Exchange Online Plan 2";
        "RIGHTSMANAGEMENT_STANDARD_FACULTY"  = "Information Rights Management for Faculty";
        "RIGHTSMANAGEMENT_STANDARD_STUDENT"  = "Information Rights Management for Students";
        "INTUNE_A_VL"                        = "Intune (Volume License)";
        "MCOLITE"                            = "Lync Online (Plan 1)";
        "CRMSTORAGE"                         = "Microsoft Dynamics CRM Online Additional Storage";
        "FLOW_FREE"                          = "Microsoft Flow Free";
        "IT_ACADEMY_AD"                      = "Microsoft Imagine Academy";
        "POWERAPPS_INDIVIDUAL_USER"          = "Microsoft PowerApps and Logic flows";
        "STREAM"                             = "Microsoft Stream";
        "MICROSOFT_BUSINESS_CENTER"          = "MICROSOFT_BUSINESS_CENTER";
        "MEE_FACULTY"                        = "Minecraft Education Edition Faculty";
        "MEE_STUDENT"                        = "Minecraft Education Edition Student";
        "STANDARDWOFFPACK_STUDENT"           = "O365 Education E1 for Students";
        "STANDARDWOFFPACK_IW_FACULTY"        = "O365 Education for Faculty";
        "STANDARDWOFFPACK_IW_STUDENT"        = "O365 Education for Students";
        "STANDARDPACK_STUDENT"               = "Office 365 (Plan A1) for Students";
        "ENTERPRISEPACKLRG"                  = "Office 365 (Plan E3)";
        "EQUIVIO_ANALYTICS_FACULTY"          = "Office 365 Advanced Compliance for faculty";
        "STANDARDWOFFPACK_FACULTY"           = "Office 365 Education E1 for Faculty";
        "ENTERPRISEWITHSCAL_FACULTY"         = "Office 365 Education E4 for Faculty";
        "ENTERPRISEWITHSCAL_STUDENT"         = "Office 365 Education E4 for Students";
        "STANDARDPACK"                       = "Office 365 Enterprise E1";
        "STANDARDWOFFPACK"                   = "Office 365 Enterprise E2";
        "ENTERPRISEPACKWITHOUTPROPLUS"       = "Office 365 Enterprise E3 without ProPlus Add-on";
        "ENTERPRISEPACK"                     = "Office 365 Enterprise E3";
        "ENTERPRISEWITHSCAL"                 = "Office 365 Enterprise E4";
        "ENTERPRISEPREMIUM"                  = "Office 365 Enterprise E5";
        "DESKLESSPACK_YAMMER"                = "Office 365 Enterprise K1 with Yammer";
        "DESKLESSPACK"                       = "Office 365 Enterprise K1 without Yammer";
        "DESKLESSWOFFPACK"                   = "Office 365 Enterprise K2";
        "MIDSIZEPACK"                        = "Office 365 Midsize Business";
        "STANDARDWOFFPACKPACK_FACULTY"       = "Office 365 Plan A2 for Faculty";
        "STANDARDWOFFPACKPACK_STUDENT"       = "Office 365 Plan A2 for Students";
        "ENTERPRISEPACK_FACULTY"             = "Office 365 Plan A3 for Faculty";
        "ENTERPRISEPACK_STUDENT"             = "Office 365 Plan A3 for Students";
        "OFFICESUBSCRIPTION_FACULTY"         = "Office 365 ProPlus for Faculty";
        "LITEPACK_P2"                        = "Office 365 Small Business Premium";
        "WACSHAREPOINTSTD"                   = "Office Online STD";
        "SHAREPOINTWAC"                      = "Office Online";
        "OFFICESUBSCRIPTION_STUDENT"         = "Office ProPlus Student Benefit";
        "OFFICE_PRO_PLUS_SUBSCRIPTION_SMBIZ" = "Office ProPlus";
        "POWER_BI_INDIVIDUAL_USER"           = "Power BI for Office 365 Individual";
        "POWER_BI_STANDALONE"                = "Power BI for Office 365 Standalone";
        "POWER_BI_STANDARD"                  = "Power BI for Office 365 Standard";
        "POWER_BI_PRO"                       = "POWER_BI_PRO";
        "PROJECTESSENTIALS"                  = "Project Lite";
        "PROJECTONLINE_PLAN_1_FACULTY"       = "Project Online for Faculty Plan 1";
        "PROJECTONLINE_PLAN_2_FACULTY"       = "Project Online for Faculty Plan 2";
        "PROJECTONLINE_PLAN_1_STUDENT"       = "Project Online for Students Plan 1";
        "PROJECTONLINE_PLAN_2_STUDENT"       = "Project Online for Students Plan 2";
        "PROJECTPREMIUM"                     = "Project Online Premium";
        "PROJECTPROFESSIONAL"                = "Project Online Professional";
        "PROJECTONLINE_PLAN_1"               = "Project Online with Project for Office 365";
        "PROJECTCLIENT"                      = "Project Pro for Office 365";
        "PROJECT_MADEIRA_PREVIEW_IW_SKU"     = "PROJECT_MADEIRA_PREVIEW_IW";
        "SPE_E3"                             = "MICROSOFT 365 E3";
        "SPE_E5"                             = "MICROSOFT 365 E5";
        "SHAREPOINTLITE"                     = "SharePoint Online (Plan 1) Lite";
        "SHAREPOINTENTERPRISE_MIDMARKET"     = "SharePoint Online (Plan 1) MidMarket";
        "SHAREPOINTENTERPRISE"               = "SharePoint Online (Plan 2)";
        "SHAREPOINTSTANDARD"                 = "SharePoint Online Plan 1";
        "STANDARD_B_PILOT"                   = "STANDARD_B_PILOT";
        "STANDARDPACK_FACULTY"               = "STANDARDPACK_FACULTY";
        "VISIOCLIENT"                        = "Visio Pro for Office 365";
        "YAMMER_ENTERPRISE"                  = "Yammer Enterprise";
        "YAMMER_MIDSIZE"                     = "Yammer Midsize";
        "SPB"                                = "Microsoft 365 Business"
    }
    $u2fOpt = @{
        "FLOW_P2_VIRAL"                  = "Flow Free"
        "DYN365_CDS_VIRAL"               = "Common Data Service"
        "ATA"                            = "Azure Advanced Threat Protection"
        "AAD_PREMIUM"                    = "Azure Active Directory Premium Plan 1";
        "AAD_PREMIUM_P2"                 = "Azure Active Directory Premium P2";
        "IT_ACADEMY_AD"                  = "Microsoft Imagine Academy";
        "ADALLOM_S_O365"                 = "Office 365 Advanced Security Management";
        "ADALLOM_S_STANDALONE"           = "Microsoft Cloud App Security";
        "ATP_ENTERPRISE"                 = "Exchange Online Advanced Threat Protection";
        "BI_AZURE_P0"                    = "Power BI (free)";
        "BI_AZURE_P1"                    = "Power BI Reporting and Analytics";
        "BI_AZURE_P2"                    = "Power BI Pro";
        "CRMIUR"                         = "CRM for Partners";
        "CRMSTANDARD"                    = "CRM Online";
        "CRMSTORAGE"                     = "Microsoft Dynamics CRM Online Additional Storage";
        "CRMTESTINSTANCE"                = "CRM Test Instance";
        "Deskless"                       = "Microsoft StaffHub";
        "DESKLESSPACK_GOV"               = "Microsoft Office 365 (Plan K1) for Government";
        "DESKLESSWOFFPACK_GOV"           = "Microsoft Office 365 (Plan K2) for Government";
        "ENTERPRISEPACK_GOV"             = "Microsoft Office 365 (Plan G3) for Government";
        "ENTERPRISEWITHSCAL_GOV"         = "Microsoft Office 365 (Plan G4) for Government";
        "EOP_ENTERPRISE"                 = "Exchange Online Protection";
        "EOP_ENTERPRISE_FACULTY"         = "Exchange Online Protection for Faculty";
        "EQUIVIO_ANALYTICS"              = "Office 365 Advanced eDiscovery";
        "EXCHANGE_ANALYTICS"             = "Microsoft MyAnalytics";
        "EXCHANGE_S_ARCHIVE_ADDON_GOV"   = "Exchange Online Archiving Govt";
        "EXCHANGE_S_DESKLESS"            = "Exchange Online Kiosk";
        "EXCHANGE_S_DESKLESS_GOV"        = "Exchange Kiosk";
        "EXCHANGE_S_ENTERPRISE"          = "Exchange Online (Plan 2) Ent";
        "EXCHANGE_S_ENTERPRISE_GOV"      = "Exchange Plan 2G";
        "EXCHANGE_S_FOUNDATION"          = "Exchange Foundation for certain SKUs";
        "EXCHANGE_S_STANDARD"            = "Exchange Online (Plan 2)";
        "EXCHANGE_S_STANDARD_MIDMARKET"  = "Exchange Online (Plan 1)";
        "EXCHANGEARCHIVE"                = "Exchange Online Archiving";
        "EXCHANGEENTERPRISE_GOV"         = "Microsoft Office 365 Exchange Online (Plan 2) only for Government";
        "EXCHANGESTANDARD_GOV"           = "Microsoft Office 365 Exchange Online (Plan 1) only for Government";
        "EXCHANGESTANDARD_STUDENT"       = "Exchange Online (Plan 1) for Students";
        "EXCHANGETELCO"                  = "Exchange Online POP";
        "FLOW_O365_P2"                   = "Flow";
        "FLOW_O365_P3"                   = "Flow for Office 365";
        "FORMS_PLAN_E3"                  = "Microsoft Forms (Plan E3)";
        "FORMS_PLAN_E5"                  = "Microsoft Forms (Plan E5)";
        "INTUNE_A"                       = "Intune for Office 365";
        "INTUNE_O365"                    = "Mobile Device Management for Office 365";
        "LITEPACK"                       = "Office 365 (Plan P1)";
        "LOCKBOX_ENTERPRISE"             = "Customer Lockbox";
        "MCOEV"                          = "Skype for Business Cloud PBX";
        "MCOMEETADV"                     = "Skype for Business PSTN Conferencing";
        "MCOSTANDARD"                    = "Skype for Business Online (Plan 2)";
        "MCOSTANDARD_GOV"                = "Lync Plan 2G";
        "MCOSTANDARD_MIDMARKET"          = "Lync Online (Plan 1)";
        "MCVOICECONF"                    = "Lync Online (Plan 3)";
        "MDM_SALES_COLLABORATION"        = "Microsoft Dynamics Marketing Sales Collaboration";
        "MFA_PREMIUM"                    = "Azure Multi-Factor Authentication";
        "MICROSOFT_BUSINESS_CENTER"      = "Microsoft Business Center";
        "MINECRAFT_EDUCATION_EDITION"    = "Minecraft Education Edition Faculty";
        "NBPROFESSIONALFORCRM"           = "Microsoft Social Listening Professional";
        "OFFICE_FORMS_PLAN_2"            = "Microsoft Forms (Plan 2)";
        "OFFICESUBSCRIPTION"             = "Office 365 ProPlus";
        "OFFICESUBSCRIPTION_GOV"         = "Office ProPlus";
        "OFFICESUBSCRIPTION_STUDENT"     = "Office ProPlus Student Benefit";
        "ONEDRIVESTANDARD"               = "OneDrive";
        "POWERAPPS_O365_P2"              = "PowerApps";
        "POWERAPPS_O365_P3"              = "PowerApps for Office 365";
        "PROJECT_CLIENT_SUBSCRIPTION"    = "Project Pro for Office 365";
        "PROJECT_ESSENTIALS"             = "Project Lite";
        "PROJECTONLINE_PLAN_1"           = "Project Online (Plan 1)";
        "PROJECTONLINE_PLAN_2"           = "Project Online (Plan 2)";
        "PROJECTWORKMANAGEMENT"          = "Microsoft Planner";
        "RMS_S_ENTERPRISE"               = "Azure Rights Management";
        "RMS_S_ENTERPRISE_GOV"           = "Windows Azure Active Directory Rights Management";
        "RMS_S_PREMIUM"                  = "Azure Information Protection Plan 1";
        "RMS_S_PREMIUM2"                 = "Azure Information Protection Premium P2";
        "SCHOOL_DATA_SYNC_P1"            = "School Data Sync (Plan 1)";
        "SHAREPOINT_PROJECT"             = "SharePoint Online (Plan 2) Project";
        "SHAREPOINT_PROJECT_EDU"         = "Project Online Service for Education";
        "SHAREPOINTDESKLESS"             = "SharePoint Online Kiosk";
        "SHAREPOINTDESKLESS_GOV"         = "SharePoint Online Kiosk Gov";
        "SHAREPOINTENTERPRISE"           = "SharePoint Online (Plan 2)";
        "SHAREPOINTENTERPRISE_EDU"       = "SharePoint Plan 2 for EDU";
        "SHAREPOINTENTERPRISE_GOV"       = "SharePoint Plan 2G";
        "SHAREPOINTENTERPRISE_MIDMARKET" = "SharePoint Online (Plan 1)";
        "SHAREPOINTPARTNER"              = "SharePoint Online Partner Access";
        "SHAREPOINTSTANDARD_EDU"         = "SharePoint Plan 1 for EDU";
        "SHAREPOINTSTORAGE"              = "SharePoint Online Storage";
        "SHAREPOINTWAC"                  = "Office Online";
        "SHAREPOINTWAC_EDU"              = "Office Online for Education";
        "SHAREPOINTWAC_GOV"              = "Office Online for Government";
        "SQL_IS_SSIM"                    = "Power BI Information Services";
        "STANDARDPACK"                   = "Microsoft Office 365 (Plan E1)";
        "STANDARDPACK_FACULTY"           = "Microsoft Office 365 (Plan A1) for Faculty";
        "STANDARDPACK_GOV"               = "Microsoft Office 365 (Plan G1) for Government";
        "STANDARDPACK_STUDENT"           = "Microsoft Office 365 (Plan A1) for Students";
        "STANDARDWOFFPACK"               = "Microsoft Office 365 (Plan E2)";
        "STANDARDWOFFPACK_FACULTY"       = "Office 365 Education E1 for Faculty";
        "STANDARDWOFFPACK_GOV"           = "Microsoft Office 365 (Plan G2) for Government";
        "STANDARDWOFFPACK_IW_FACULTY"    = "Office 365 Education for Faculty";
        "STANDARDWOFFPACK_IW_STUDENT"    = "Office 365 Education for Students";
        "STANDARDWOFFPACK_STUDENT"       = "Microsoft Office 365 (Plan A2) for Students";
        "STREAM_O365_E3"                 = "Microsoft Stream for O365 E3 SKU";
        "STREAM_O365_E5"                 = "Microsoft Stream for O365 E5 SKU";
        "SWAY"                           = "Sway";
        "TEAMS1"                         = "Microsoft Teams";
        "THREAT_INTELLIGENCE"            = "Office 365 Threat Intelligence";
        "VISIO_CLIENT_SUBSCRIPTION"      = "Visio Pro for Office 365 Subscription";
        "VISIOCLIENT"                    = "Visio Pro for Office 365";
        "WACONEDRIVESTANDARD"            = "OneDrive Pack";
        "WIN10_PRO_ENT_SUB"              = "Windows 10 Enterprise E3";
        "YAMMER_EDU"                     = "Yammer for Academic";
        "YAMMER_ENTERPRISE"              = "Yammer Enterprise";
        "YAMMER_MIDSIZE"                 = "Yammer"
    }
    $resultArray = @()
    $skus = (Get-AzureADSubscribedSku)
    if ($friendly) {
        foreach ($sku in $skus) {
            $sku2service = [ordered]@{ }
            foreach ($plan in $sku.serviceplans.serviceplanname) {
                if ($u2fSku.($sku.SkuPartNumber)) {
                    $sku2service['Sku'] = ($u2fSku.($sku.SkuPartNumber))
                }
                Else {
                    $sku2service['Sku'] = $sku.SkuPartNumber
                }
                if ($u2fOpt.$plan) {
                    $sku2service['Service'] = ($u2fOpt.$plan)
                }
                Else {
                    $sku2service['Service'] = $plan
                }
                $sku2service['Consumed'] = (($sku.prepaidunits.enabled) - ($sku.prepaidunits.enabled - $sku.consumedunits))
                $sku2service['Total'] = ($sku.prepaidunits.enabled)
                $resultArray += [psCustomObject]$sku2service
            }
        }
    }
    if ($both) {
        foreach ($sku in $skus) {
            $sku2service = [ordered]@{ }
            foreach ($plan in $sku.serviceplans.serviceplanname) {
                if ($u2fSku.($sku.SkuPartNumber)) {
                    $sku2service['FriendlySku'] = ($u2fSku.($sku.SkuPartNumber))
                }
                Else {
                    $sku2service['FriendlySku'] = $sku.SkuPartNumber
                }
                $sku2service['Sku'] = $sku.SkuPartNumber
                if ($u2fOpt.$plan) {
                    $sku2service['FriendlyService'] = ($u2fOpt.$plan)
                }
                Else {
                    $sku2service['FriendlyService'] = $plan
                }
                $sku2service['Service'] = $plan
                $sku2service['Consumed'] = (($sku.prepaidunits.enabled) - ($sku.prepaidunits.enabled - $sku.consumedunits))
                $sku2service['Total'] = ($sku.prepaidunits.enabled)
                $resultArray += [psCustomObject]$sku2service
            }
        }
    }
    If ($ugly) {
        foreach ($sku in $skus) {
            $sku2service = [ordered]@{ }
            foreach ($plan in $sku.serviceplans.serviceplanname) {
                $sku2service['Sku'] = $sku.SkuPartNumber
                $sku2service['Service'] = $plan
                $sku2service['Consumed'] = (($sku.prepaidunits.enabled) - ($sku.prepaidunits.enabled - $sku.consumedunits))
                $sku2service['Total'] = ($sku.prepaidunits.enabled)
                $resultArray += [psCustomObject]$sku2service
            }
        }
    }
    $resultArray
}