Checking SKU’s in Office 365 with Powershell
Powershell allows you to do many things within office 365, which makes it a very Powerful tool. There are times you will want to check the SKU’s in Office 365 Tenant and if you have many subscriptions and licenses, there is a simple way to check license counts with Powershell and provide a report to management.
Connect to Exchange Powershell Office 365
Use our previous article to connect to office 365 Exchange Online with PowerShell
To get the AccountSkuId and included ServicePlans for your tenant, do the following:
Enter Get-MsolAccountSku
As you can see we also get the Microsoft Online Domain, Active Units, Warning Units and consumed units. Now I have the account SKU’s, we can enter the following to get the included service plans.
Get-MsolAccountSku | Where-Object {$_.SkuPartNumber -eq "ENTERPRISEPREMIUM_FACULTY"} | ForEach-Object {$_.ServiceStatus}
Office 365 Service Plan SKU’s
| Office 365 Small Business Premium | LITEPACK_P2 | |
| EXCHANGE_L_STANDARD | Exchange Online (Plan 1) |
| MCOLITE | Lync Online (Plan 1) |
| SHAREPOINTLITE | SharePoint Online (Plan 1) |
| OFFICE_PRO_PLUS_SUBSCRIPTION_SMBIZ | Office ProPlus |
| Office 365 Midsize Business | MIDSIZEPACK | |
| EXCHANGE_S_STANDARD_MIDMARKET | Exchange Online (Plan 1) |
| MCOSTANDARD_MIDMARKET | Lync Online (Plan 1) |
| SHAREPOINTENTERPRISE_MIDMARKET | SharePoint Online (Plan 1) |
| SHAREPOINTWAC | Office Online |
| OFFICESUBSCRIPTION | Office ProPlus |
| YAMMER_MIDSIZE | Yammer |
| Office 365 Enterprise E3 | ENTERPRISEPACK | |
| EXCHANGE_S_STANDARD | Exchange Online (Plan 2) |
| MCOSTANDARD | Lync Online (Plan 2) |
| SHAREPOINTENTERPRISE | SharePoint Online (Plan 2) |
| SHAREPOINTWAC | Office Online |
| OFFICESUBSCRIPTION | Office ProPlus |
| RMS_S_ENTERPRISE | Azure Active Directory Rights Management |
| YAMMER_ENTERPRISE | Yammer |
| Office 365 Enterprise E4 | ENTERPRISEPACKWSCAL | |
| E3 | |
| + | |
| MCVOICECONF | Lync Online (Plan 3) |
| Office 365 Enterprise K1 with/without Yammer | DESKLESSPACK or DESKLESSPACK_YAMMER | |
| EXCHANGE_S_DESKLESS | Exchange Online Kiosk |
| SHAREPOINTDESKLESS | SharePoint Online Kiosk |
| YAMMER_ENTERPRISE | Yammer for the Starship Enterprise |
| Office 365 Enterprise K2 | DESKLESSWOFFPACK | |
| EXCHANGE_S_DESKLESS | Exchange Online Kiosk |
| SHAREPOINTDESKLESS | SharePoint Online Kiosk |
| SHAREPOINTWAC | Office Online |
| Education and Government plans (unverified) | |
| Office 365 for Education | |
| STANDARDPACK_STUDENT | Microsoft Office 365 (Plan A1) for Students |
| STANDARDPACK_FACULTY | Microsoft Office 365 (Plan A1) for Faculty |
| STANDARDWOFFPACK_FACULTY | Office 365 Education E1 for Faculty |
| STANDARDWOFFPACK_STUDENT | Microsoft Office 365 (Plan A2) for Students |
| STANDARDWOFFPACK_IW_STUDENT | Office 365 Education for Students |
| STANDARDWOFFPACK_IW_FACULTY | Office 365 Education for Faculty |
| EOP_ENTERPRISE_FACULTY | Exchange Online Protection for Faculty |
| EXCHANGESTANDARD_STUDENT | Exchange Online (Plan 1) for Students |
| OFFICESUBSCRIPTION_STUDENT | Office ProPlus Student Benefit |
| Office 365 for Government | |
| STANDARDPACK_GOV | Microsoft Office 365 (Plan G1) for Government |
| STANDARDWOFFPACK_GOV | Microsoft Office 365 (Plan G2) for Government |
| ENTERPRISEPACK_GOV | Microsoft Office 365 (Plan G3) for Government |
| ENTERPRISEWITHSCAL_GOV | Microsoft Office 365 (Plan G4) for Government |
| DESKLESSPACK_GOV | Microsoft Office 365 (Plan K1) for Government |
| ESKLESSWOFFPACK_GOV | Microsoft Office 365 (Plan K2) for Government |
| EXCHANGESTANDARD_GOV | Microsoft Office 365 Exchange Online (Plan 1) only for Government |
| EXCHANGEENTERPRISE_GOV | Microsoft Office 365 Exchange Online (Plan 2) only for Government |
| SHAREPOINTDESKLESS_GOV | SharePoint Online Kiosk |
| EXCHANGE_S_DESKLESS_GOV | Exchange Kiosk |
| RMS_S_ENTERPRISE_GOV | Windows Azure Active Directory Rights Management |
| OFFICESUBSCRIPTION_GOV | Office ProPlus |
| MCOSTANDARD_GOV | Lync Plan 2G |
| SHAREPOINTWAC_GOV | Office Online for Government |
| SHAREPOINTENTERPRISE_GOV | SharePoint Plan 2G |
| EXCHANGE_S_ENTERPRISE_GOV | Exchange Plan 2G |
| EXCHANGE_S_ARCHIVE_ADDON_GOV | Exchange Online Archiving |
| Other plans and add-ons (unverified) | |
| LITEPACK | Office 365 (Plan P1) |
| STANDARDPACK | Microsoft Office 365 (Plan E1) |
| STANDARDWOFFPACK | Microsoft Office 365 (Plan E2) |
| DESKLESSPACK | Office 365 (Plan K1) |
| EXCHANGEARCHIVE | Exchange Online Archiving |
| EXCHANGETELCO | Exchange Online POP |
| SHAREPOINTSTORAGE | SharePoint Online Storage |
| SHAREPOINTPARTNER | SharePoint Online Partner Access |
| PROJECTONLINE_PLAN_1 | Project Online (Plan 1) |
| PROJECTONLINE_PLAN_2 | Project Online (Plan 2) |
| PROJECT_CLIENT_SUBSCRIPTION | Project Pro for Office 365 |
| VISIO_CLIENT_SUBSCRIPTION | Visio Pro for Office 365 |
| INTUNE_A | Intune for Office 365 |
| CRMSTANDARD | CRM Online |
| CRMTESTINSTANCE | CRM Test Instance |
| ONEDRIVESTANDARD | OneDrive |
| WACONEDRIVESTANDARD | OneDrive Pack |
| SQL_IS_SSIM | Power BI Information Services |
| BI_AZURE_P1 | Power BI Reporting and Analytics |
| EOP_ENTERPRISE | Exchange Online Protection |
| PROJECT_ESSENTIALS | Project Lite |
| CRMIUR | CRM for Partners |
| NBPROFESSIONALFORCRM | Microsoft Social Listening Professional |
| AAD_PREMIUM | Azure Active Directory Premium |
| MFA_PREMIUM | Azure Multi-Factor Authentication |
Related Posts:
