How to get the number of active licenses use Microsoft Graph's cmd

Question

How to get the number of active licenses use Microsoft Graph's cmd

Anonymous

Hi

How do I get the number of active licenses use Microsoft Graph's cmd ?

Before, I used 'Get-MsolAccountSku' in PowerShell to get 'ActiveUnits', but now I use'Get-MgSubscribedSku'. After execution, there is no' ActiveUnits'. I am a novice in this field. Although I have

also conducted an investigation, I can't find it, so please help me.

Thanks in advance

Tyler Montney 16 Reputation points

2023-02-14T22:30:33.2266667+00:00
Extending on the accepted answer...

$MsolSkus = Get-MgSubscribedSKU -All -Property @("SkuId", "ConsumedUnits", "PrepaidUnits") | Select-Object *, @{Name = "ActiveUnits"; Expression = { ($_ | Select-Object -ExpandProperty PrepaidUnits).Enabled } } | Select-Object SkuId, ActiveUnits, ConsumedUnits

If you want to get the SKUs "friendly name", grab the CSV from https://learn.microsoft.com/en-us/azure/active-directory/enterprise-users/licensing-service-plan-reference.

Chris King 5

Here is what I do as I only care about a few skus. This shows the friendly name and balance left.

# could do a bunch of where/ors but I already have these separate in other scripts
$e5sku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'SPE_E5'
$e3sku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'SPE_E3'
$e1sku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'standardpack'
$emssku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'ems'

($e5sku, $e3sku, $e1sku, $emssku) | 
Select-Object *, @{Name = "Balance"; Expression = { ($_ | Select-Object -ExpandProperty PrepaidUnits).Enabled - $_.ConsumedUnits}}, 
@{Name = "ActiveUnits"; Expression = { ($_ | Select-Object -ExpandProperty PrepaidUnits).Enabled}} |
Select-Object SkuPartNumber, ActiveUnits, Balance

Accepted answer

2 additional answers

Your answer

Tyler Montney 16 Reputation points

2023-02-14T22:30:33.2266667+00:00

Extending on the accepted answer...

$MsolSkus = Get-MgSubscribedSKU -All -Property @("SkuId", "ConsumedUnits", "PrepaidUnits") | Select-Object *, @{Name = "ActiveUnits"; Expression = { ($_ | Select-Object -ExpandProperty PrepaidUnits).Enabled } } | Select-Object SkuId, ActiveUnits, ConsumedUnits

If you want to get the SKUs "friendly name", grab the CSV from https://learn.microsoft.com/en-us/azure/active-directory/enterprise-users/licensing-service-plan-reference.
Chris King 5 Reputation points

2025-03-24T18:33:24.3866667+00:00

Here is what I do as I only care about a few skus. This shows the friendly name and balance left.

# could do a bunch of where/ors but I already have these separate in other scripts $e5sku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'SPE_E5' $e3sku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'SPE_E3' $e1sku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'standardpack' $emssku = Get-MgSubscribedSku | Where-Object SkuPartNumber -eq 'ems' ($e5sku, $e3sku, $e1sku, $emssku) | Select-Object *, @{Name = "Balance"; Expression = { ($_ | Select-Object -ExpandProperty PrepaidUnits).Enabled - $_.ConsumedUnits}}, @{Name = "ActiveUnits"; Expression = { ($_ | Select-Object -ExpandProperty PrepaidUnits).Enabled}} | Select-Object SkuPartNumber, ActiveUnits, Balance

Answer 1

Vasil Michev 119.7K MVP Volunteer Moderator

The info is there, you just need to display it:

Get-MgSubscribedSku | select -First 1 -Skip 1 | select -ExpandProperty PrepaidUnits

Anonymous

2021-12-13T07:21:10.77+00:00

Thank you. This is very useful.
In addition, "Get-MgSubscribedSku | select -ExpandProperty PrepaidUnits" may be better.

Answer 2

Keerthi Jakkam 1

I saw equalant command for Get-MsolSubscription in https://learn.microsoft.com/en-us/powershell/microsoftgraph/azuread-msoline-cmdlet-map?view=graph-powershell-1.0 is Get-MgSubscription

But I am not able to get any details status,DateCreated,TotalLicenses,SkuPartNumber,NextLifecycleDate,OcpSubscriptionId.

Answer 3

Aarts, Jan 16

Get-MgSubscribedSku | | select {$_.PrepaidUnits.enabled}, ConsumedUnits, skupartnumber
gives you the list you want I think

Share via

How to get the number of active licenses use Microsoft Graph's cmd

2 additional answers

Your answer