How to get Microsoft 365 subscriptions using Get-MgSubscribedSku

Tracking license usage helps cut costs and reclaim unused licenses. While Graph PowerShell’s Get-MgSubscribedSku helps fetch Microsoft 365 license data, it requires precise commands and filter syntax. On the other hand, ADManager Plus, a Microsoft 365 management and reporting tool , simplifies license usage tracking with a visual interface that lets you generate and filter reports without any scripts.

  • ADManager Plus
  • PowerShell
 

Get subscribed Microsoft 365 licenses using ADManager Plus

  1. Log in to ADManager Plus and navigate to the Microsoft 365 tab.
  2. Under the Report section, click on License Reports → License Details.
  3. Choose the Microsoft 365 account and click Generate. ADManager Plus lets you filter the report based on various parameters.
A comprehensive report showing subscribed Microsoft 365 licenses in ADManager Plus

Get subscribed Microsoft 365 licenses using Microsoft Graph PowerShell

Prerequisites

Before using the Get-MgSubscribedSku cmdlet, make sure the following prerequisites are met:

  • Install the Microsoft Graph PowerShell module.
    Install-Module Microsoft.Graph -Scope CurrentUser
  • Connect to Microsoft Graph PowerShell with the required scope.
    Connect-MgGraph -Scopes "Organization.Read.All"

Using the Get-MgSubscribedSku command to get subscribed Microsoft 365 licenses

The Get-MgSubscribedSku cmdlet can be used in Microsoft Graph PowerShell to get subscribed Microsoft 365 licenses.

Here's the syntax:

Get-MgSubscribedSku
[-Property <String[ ]>]
[-ExpandProperty <String[ ]>]
[-Filter <String>]
[-Search <String>]
[-Skip <Int32>]
[-Sort <String[ ]>]
[-Top <Int>]
[-ResponseHeadersVariable <String>]
[-Headers <IDictionary>]
[-PageSize <Int32>]
[-All]
[-CountVariable <String>]
[<CommonParameters>]

Supported parameters:

The following table contains some parameters that can be used along with the Get-MgSubscribedSku command to efficiently get subscribed Microsoft 365 licenses.

Parameter Description
-UserId Specifies the user (by UPN or Object ID) whose licenses are being updated.
-AddLicenses An array of license objects to assign. Each object must include at least the Sku ID. You can also specify disabled plans inside.
-RemoveLicenses An array of license SKU IDs to remove from the user.
-AdditionalProperties Used to pass any extra parameters in the request body that the API supports.
-ResponseHeadersVariable Stores response headers in a variable. Useful for logging or debugging.
-Headers Custom HTTP headers if needed during the request.
-WhatIf Simulates the command without making any changes.
-Confirm Prompts you to confirm before applying changes.

Limitations of using Graph PowerShell scripts to get subscribed Microsoft 365 licenses

  • Since there's no graphical interface, Microsoft Graph PowerShell requires familiarity with complex scripting.
  • Filtering depends on exact property names and syntax, so even small errors can cause empty or failed results.
  • There's no direct export option, and formatting data for reporting needs additional script logic.
  • The lack of built-in visual summaries makes the experience less user-friendly, particularly for those new to scripting.
  • Throttling limits in the Graph API can slow down large queries or frequent report runs.
  • When errors occur, such as invalid inputs or missing permissions, resolving them often demands technical debugging skills.

Highlights of using ADManager Plus to get subscribed Microsoft 365 licenses

  • Manage licenses and track usage in one unified dashboard.
  • Filter license data instantly using various parameters.
  • Export license reports in multiple formats for audits or internal review.
  • Delegate reporting access to technicians without granting full administrative rights.

Track Microsoft 365 licenses using ADManager Plus

 
  • Get subscribed Microsoft 365 licenses using ADManager Plus
  • Get subscribed Microsoft 365 licenses using Microsoft Graph PowerShell
  • Supported parameters
  • Limitations of using Graph PowerShell scripts to get subscribed Microsoft 365 licenses
  • Highlights of using ADManager Plus to get subscribed Microsoft 365 licenses
The one-stop solution to Active Directory Management and Reporting
Email Download Link Email the ADManager Plus download link