We have a constant churn of staff, as does any large organisation. One of the challenges is to ensure that anyone who has left has their account disabled in AD. All good, we have that process. We also use Azure AD Sync to sync users to our Office 365 tenant.
Disabling a user however, does not remove the licence assigned them, so I decided to create a simple PowerShell script that I can run periodically to find all the blocked users in Office365 and remove any licences they had.
This script requires PowerShell 5..
#clear the screen
CLS
#Lets log the output.. Remeber to change this to a location you want!
Start-Transcript -path C:\temp\output.txt -append
#Connect To your tenant..
Connect-MsolService
#get a list of all users who's sign in status is blocked..
Write-Output "getting Blocked users..."
$users = Get-MsolUser -All | Where-Object {$_.BlockCredential -eq "True"} | Select -Property UserPrincipalName
Write-Output "Starting unlicense module.."
#remove licences from these users..
foreach ($user in $users)
{
#ok, lets see what license they have..
$license = Get-MsolUser -UserPrincipalName $user.UserPrincipalName | Select-Object -ExpandProperty Licenses
#make sure you change this to your country!
Set-MsolUser -UserPrincipalname $user.UserPrincipalName -UsageLocation "GB"
#go ahead and remove the licence
if ($license.AccountSkuId -ne $null)
{
Set-MsolUserLicense -UserPrincipalName $user.UserPrincipalName -RemoveLicense $license.AccountSkuId
#lets log what we did so we can report on it. Managers love reports..
Write-Output $user.UserPrincipalName removed $license.AccountSkuId
}
}
Write-Output "Finished"
Stop-Transcript
Projector, Vili Nice 6000 Lux WiFi Projector, Bluetooth Mini Projector with Synchronize Smartphone Screen, Supports 1080P HD 240"Display, Compatible with Laptop, TV Stick, HDMI, VGA, USB, DVD, PS4
£93.99【UPGRADED VIDEO PROJECTOR】Vili Nice WiFi projector is adopts latest multilayer optical film technology, can reduce reflection and increase light transmittance, ensure clear images. 1280 * 720 native resolution, support 1080P full HD display, 6000 Lux... read more
(as of 2nd August 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Nooie Baby Monitor WiFi Dog Pet Camera Indoor,360-degree Wireless IP Camera,1080P Home Security Camera,Motion Tracking,Night Vision,Works with Alexa
£34.99360 °MOTION TRACKING: Automatically senses and tracks the action in your baby room in full 360°. Nooie Cam 360 has 101° field of view -- rotates 355° horizontally and 94° vertically. Pan and tilt easily with the Nooie App. Never miss a thing about yo... read more
(as of 2nd August 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
AMD Ryzen 5 5600X Processor (6C/12T, 35MB Cache, up to 4.6 GHz Max Boost)
£245.00The fastest in the game Get the high-speed gaming performance of the world’s best desktop processor Testing by AMD performance labs as of 9/2/2020 based on the average FPS of 40 PC games at 1920x1080 with the High image quality preset using an AMD Ry... read more
(as of 2nd August 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Garmin Venu 2S Smaller-sized GPS smartwatch with all-day health monitoring, Slate Bezel with Graphite Case and Silicone Band
£279.99Know your body better with extensive health monitoring features, including the Health Snapshot feature, Body Battery energy levels, sleep score, fitness age, stress tracking and more Find new ways to keep your body moving with more than 25 built-in i... read more
(as of 2nd August 2021 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)