With Microsoft progressing with how licensing works with Office 365, we are able to mix and match multiple license types in their cloud service. Overtime it can become cumbersome to manage licenses, where users will have the wrong license attached. The following hammer will allow you to run through all your users and attach the correct licenses, assuming you have enough licenses to float.
This hammer assumes you connect to Microsoft Online Licensing through PowerShell using the following code
|
1 2 3 |
$objUserCredential = get-credential Import-Module MSOnline Connect-MsolService -Credential $objUserCredential |
Once connected to Microsoft Online Licensing, run the following hammer. This assumes the CSV that is being loaded in has two columns, UserPrincipalName and LicenseSkuId.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
$objMsolUsers = @() Import-CSV '.\twah_UserLicenses.csv' | ForEach-Object { $sUPN = $_.UserPrincipalName $sLicenseSkuIdToAdd = $_.LicenseSkuId $objMsolUser = (Get-MsolUser -userPrincipalName $sUPN -EA silentlycontinue) if ($objMsolUser -ne $null) { $sOID = $objMsolUser.ObjectID $sLicenseSkuIds = @() if ($objMsolUser.Licenses.count -gt 0) { $objMsolUser.Licenses | ForEach-Object { $sLicenseSkuId = $_.AccountSkuId if ($sLicenseSkuId -ne "$sLicenseSkuIdToAdd") { $sLicenseSkuIds += $sLicenseSkuId } } if ($sLicenseSkuIds.count -gt 0 -and ($sLicenseSkuIds.count -eq 1 -and $sLicenseSkuIds -ne $sLicenseSkuIdToAdd)) { Set-MsolUserLicense -ObjectID $sOID -AddLicenses "$sLicenseSkuIdToAdd" -RemoveLicenses "$sLicenseSkuIds" -wa SilentlyContinue } } else { Set-MsolUserLicense -ObjectID $sOID -AddLicenses $sLicenseSkuIdToAdd } $objMsolUser = (Get-MsolUser -userPrincipalName $sUPN -EA silentlycontinue) $objMsolUsers += $objMsolUser } } $objMsolUsers | ft UserPrincipalName,Licenses |
This hammer was used to remove the trial licenses from a test account and applied the correct licenses. We were setting up roughly 400 users with a mixture of E3 and Business Premium licenses, so we needed to remove all the techwithahammer:O365_BUSINESS_PREMIUM licenses and replace them with techwithahammer:ENTERPRISEPACK and techwithahammer:SMB_BUSINESS_PREMIUM.