How to know who has a pack?

[Andy Kw]

I'm running the command below 

Get-MsolAccountSku

 And these are the results

PS C:\Users\KW> Get-MsolAccountSku

AccountSkuId                            ActiveUnits  WarningUnits  ConsumedUnits
------------                            -----------  ------------  -------------
avocarbon:ENTERPRISEPACK                21            0            21
avocarbon:FLOW_FREE                     10000         0            1
avocarbon:EXCHANGEDESKLESS              58            0            57
avocarbon:EXCHANGESTANDARD              414           0            405
avocarbon:DYN365_ENTERPRISE_P1_IW       10000         0            1
avocarbon:POWER_BI_STANDARD             1000000       0            1
avocarbon:STANDARDPACK                  251           0            1

I want to know who has the only licence, the `avocarbon:STANDARDPACK` (see just above).

With which powershell command can I do that?

Cheers

[#2 · Accepted solution]

Get-MsolUser -ALL | Where { $_.Licenses.AccountSkuId -contains "avocarbon:STANDARDPACK" }

[#3]

If you are interested in GUI tool, then give it a try to AdminDroid Office 365 Reporter. The product provides you 100+ free reports on users, groups, licensing and has more excellent filtering capability. 

[#4]

Thanks Robert for the link.

[#5]

Thanks Pablo for the help, much appreciated.

[#6]

you're welcome