(Cloud) Tip of the Day: List of users and assigned licenses

Today’s Tip…

A while ago in another series of tips, I provided a lot of information around managing licenses in Azure AD. This one as an extension to that series.

This tip allows you to see a list of users and what licenses are assigned to them.

To do that, run the following Azure AD PowerShell cmdlet…

Get-MsolUser -All | where {$_.isLicensed -eq $True} | Select-Object -Property UserPrincipalName -ExpandProperty Licenses | ft UserPrincipalName,AccountSKUId

Note: The user will be listed multiple times for each license that is assigned to them.