Office 365 licenses and Service Plans
Licenses E3
#All licensed users list
Get-MsolUser –All | Where-Object { $_.isLicensed -eq “TRUE” } | Select-Object UserPrincipalName, DisplayName, Department | Export-Csv c:\Scripts\LicensedUsers.csv
#the list of users without license
get-mailbox | where {($_.recipienttypedetails -ne “Discoverymailbox”) -and ($_.skuassigned -ne “True”)} | ft name,skuassign*
#E3 license – Set Canada location for the user and disabling all products except MCOSTANDARD (Skype for business Online Plan 2) and EXCHANGE_S_ENTERPRISE (Exchange Online Plan 2). Please change your “username@email.com” and tenant:ENTERPRISEPACK information
$strMoveRequestPrimaryEmailAddress = “username@email.com”
Set-MsolUser -UserPrincipalName $strMoveRequestPrimaryEmailAddress -UsageLocation CA
Set-MsolUserLicense -UserPrincipalName $strMoveRequestPrimaryEmailAddress -AddLicenses tenant:ENTERPRISEPACK
$O365Sku = New-MsolLicenseOptions -AccountSkuId tenant:ENTERPRISEPACK -DisabledPlans FORMS_PLAN_E3,STREAM_O365_E3,Deskless,FLOW_O365_P2,POWERAPPS_O365_P2,TEAMS1,PROJECTWORKMANAGEMENT,SWAY,INTUNE_O365,YAMMER_ENTERPRISE,RMS_S_ENTERPRISE,OFFICESUBSCRIPTION,SHAREPOINTWAC,SHAREPOINTENTERPRISE
Set-MsolUserLicense -UserPrincipalName “$strMoveRequestPrimaryEmailAddress” -LicenseOptions $O365Sku
List of users who has some specific Plan:
$plan = “SHAREPOINTSTANDARD”
$sku = (Get-MsolAccountSku) | ? {$_.ServiceStatus.ServicePlan.ServiceName -eq $plan}
$index = ($sku).ServiceStatus.ServicePlan.ServiceName.IndexOf($plan)
Get-MsolUser -All | ? { ($_.Licenses) -and ($_.Licenses[-1].ServiceStatus[$index].Provisioningstatus -eq “Success”) -and ($_.Licenses.AccountSkuId -eq $sku.AccountSkuId)}
#List of all service plans for license
Get-MsolAccountSku | Select -ExpandProperty ServiceStatus
#List of all licenses
Get-MsolAccountSku
#List of all service plans for specific user
$strMoveRequestPrimaryEmailAddress = “username@email.com”
(Get-MsolUser -UserPrincipalName $strMoveRequestPrimaryEmailAddress ).Licenses.ServiceStatus
E3 Service Plans
| Microsoft Forms (Plan E3) | FORMS_PLAN_E3 |
| Stream for Office 365 | STREAM_O365_E3 |
| Microsoft StaffHub | Deskless |
| Flow for Office 365 | FLOW_O365_P2 |
| PowerApps for Office 365 | POWERAPPS_O365_P2 |
| Microsoft Teams | TEAMS1 |
| Microsoft Planner | PROJECTWORKMANAGEMENT |
| Sway | SWAY |
| Mobile Device Management for Office 365 | INTUNE_O365 |
| Yammer Enterprise | YAMMER_ENTERPRISE |
| Azure Rights Management | RMS_S_ENTERPRISE |
| Office 365 ProPlus | OFFICESUBSCRIPTION |
| Skype for Business Online (Plan 2) | MCOSTANDARD |
| Office Online (can’t be assigned without Sharepoint Online) | SHAREPOINTWAC |
| SharePoint Online (Plan 2) (include Onedrive) | SHAREPOINTENTERPRISE |
| Exchange Online (Plan 2) | EXCHANGE_S_ENTERPRISE |
E1 Service Plans
| Microsoft Forms (Plan E1) | FORMS_PLAN_E1 |
| Stream for Office 365 | STREAM_O365_E1 |
| Microsoft StaffHub | Deskless |
| Flow for Office 365 | FLOW_O365_P1 |
| PowerApps for Office 365 | POWERAPPS_O365_P1 |
| Microsoft Teams | TEAMS1 |
| Office Online (can’t be assigned without Sharepoint Online) | SHAREPOINTWAC |
| Microsoft Planner | PROJECTWORKMANAGEMENT |
| Sway | SWAY |
| Mobile Device Management for Office 365 | INTUNE_O365 |
| Yammer Enterprise | YAMMER_ENTERPRISE |
| Skype for Business Online (Plan 2) | MCOSTANDARD |
| SharePoint Online (Plan 1) (include Onedrive) | SHAREPOINTSTANDARD |
| Exchange Online (Plan 1) | EXCHANGE_S_STANDARD |
Sulich's Blog 