Private/License/Get-CloudSkuTable.ps1
|
function Get-CloudSkuTable { <# .Synopsis Short description .DESCRIPTION Long description .EXAMPLE Example of how to use this cmdlet .EXAMPLE Another example of how to use this cmdlet #> Param ( [Parameter(Mandatory = $false)] [switch] $sIgnore, [Parameter(Mandatory = $false)] [string[]] $sourceSku, [Parameter(Mandatory = $false)] [switch] $destAdd, [Parameter(Mandatory = $false)] [switch] $all, [Parameter(Mandatory = $false)] [string[]] $destSku ) Begin { $resultArray = @() } Process { # Define Hashtables for lookup $u2fSku = @{ "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" = "Secure Productive Enterprise E3"; "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" } $u2fOpt = @{ "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" } # Get a list of all Licenses that exist in the tenant if ($sIgnore) { $licenses = Get-AzureADSubscribedSku | Where {$_.skupartnumber -eq $sourceSku} } if ($destAdd) { $licenses = Get-AzureADSubscribedSku | Where {$_.skupartnumber -eq $destSku} } if ($all) { $licenses = Get-AzureADSubscribedSku } # Loop through all License types found in the tenant foreach ($license in $licenses) { foreach ($row in $($license.ServicePlans.serviceplanname)) { $table = [ordered]@{} if ($u2fSku[$($license.SkuPartNumber)]) { $table['Sku'] = $u2fSku[$license.SkuPartNumber] } else { $table['Sku'] = $license.SkuPartNumber } if ($u2fOpt[$row]) { $table['Plan'] = $u2fOpt[$row] } else { $table['Plan'] = $row } $resultArray += [psCustomObject]$table } } } End { $array = $resultArray | ForEach-Object { '{0}*{1}' -f $_.Sku, $_.Plan } $array } } |