Get list of Azure users with specific License

Question

Hi,
I need to get a lsit of users with a specific O365License.
I'm using this:
$ulist=Get-AzureADUser -All 1 | Select userprincipalname -ExpandProperty AssignedLicenses | Where-Object {$_.SkuID -eq '6fd2c87f-b296-42f0-b197-1e91e994b900'} | select userprincipalname

Is there a better/faster way to achieve this?

Thanks,
JD

Answer 1

dear sir, i built on your path & did the following "get-azureaduser -all 1 | select upn -expandproperty licenses | select upn,skuid | ? skuid -match "skustring"
this is very fast, and if you can over look some psuedo syntax, allows for some pretty good results. * the 2nd select allows you to ? very easily.

Answer 2

Hi junidev,

An alternative to Powershell would be the portal.
Open the AAD blade->groups->members->Download members

-T

Answer 3

Hi @juni dev

Please find below script which will give you the all services for a user who has been assigned multiple license

$userUPN=""
$AllLicenses=(Get-MsolUser -UserPrincipalName $userUPN).Licenses
$licArray = @()
for($i = 0; $i -lt $AllLicenses.Count; $i++)
{
$licArray += "License: " + $AllLicenses[$i].AccountSkuId
$licArray += $AllLicenses[$i].ServiceStatus
$licArray += ""
}
$licArray

OR

This will give you the all users with specific license

Get-MsolUser | Where-Object {($_.licenses).AccountSkuId -match "EnterprisePremium"} | Out-file C:\temp\result.csv

Answer 4

There's no server-side way to filter this, as the stupid ODATA syntax used by the Graph has very limited filtering capabilities and the assignedLicenses practically cannot be used.

Answer 5

Hi, @juni dev see if this helps.