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