Quick Tip – Querying Licensed Users in Office 365


Hi all, we have been asked the question quite a lot recently about how to retrieve a list of users after a migration who have a mailbox but no license, something that needs to be remediated before the 30 Day grace period expires. This can be achieved with a single line of PowerShell once connected to Exchange Online PowerShell:

Get-Recipient -Filter {SKUAssigned -ne $true} -RecipientTypeDetails UserMailbox

Alternatively, if you have more users who have remained licensed past your license expiration, but been left with a mailbox or other features, you can find these with the following command:

 Get-MsolUser -LicenseReconciliationNeededOnly

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s