An analysis of 3.26 million allocated licenses across 137 SKUs showing 0.13% utilization, with 9,061 users consuming 4,217 licenses. Generated by AI via Proxuma Power BI MCP server.
An analysis of 3.26 million allocated licenses across 137 SKUs showing 0.13% utilization, with 9,061 users consuming 4,217 licenses. Generated by AI via Proxuma Power BI MCP server.
The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.
Who should use this: Microsoft 365 administrators, security teams, and account managers
How often: Weekly for license management, monthly for adoption reviews, quarterly for optimization
An analysis of 3.26 million allocated licenses across 137 SKUs showing 0.13% utilization, with 9,061 users consuming 4,217 licenses. Generated by AI via Proxuma Power BI MCP server.
EVALUATE ROW("TotalSKUs", COUNTROWS('BI_MicrosoftPartnerCenter_Subscribed_Skus'), "ActiveUnits", SUM('BI_MicrosoftPartnerCenter_Subscribed_Skus'[active_units]), "ConsumedUnits", SUM('BI_MicrosoftPartnerCenter_Subscribed_Skus'[consumed_units]), "AvailableUnits", SUM('BI_MicrosoftPartnerCenter_Subscribed_Skus'[available_units]), "SuspendedUnits", SUM('BI_MicrosoftPartnerCenter_Subscribed_Skus'[suspended_units]), "WarningUnits", SUM('BI_MicrosoftPartnerCenter_Subscribed_Skus'[warning_units]), "TotalUsers", COUNTROWS('BI_MicrosoftPartnerCenter_Users'))Where 3.26 million licenses are distributed
| Category | Count | % of Total | Status |
|---|---|---|---|
| Active | 3,255,762 | 99.99% | |
| Consumed | 4,217 | 0.13% | |
| Warning | 424 | 0.01% | |
| Suspended | 99 | <0.01% |
EVALUATE
SUMMARIZECOLUMNS(
"ActiveLicenses", [Total Licenses] - [Consumed Licenses] - [Warning Licenses] - [Suspended Licenses],
"ConsumedLicenses", [Consumed Licenses],
"WarningLicenses", [Warning Licenses],
"SuspendedLicenses", [Suspended Licenses]
)Context for the license numbers
This data covers 1 tenant with 9,061 users and 137 unique SKUs. The tenant holds 3.26 million license units in total, which works out to roughly 359 license units per user.
That ratio sounds extreme, but it is expected. Most of these are bundled SKUs. A single Microsoft 365 E3 license includes 20+ individual service plans (Exchange Online, SharePoint, Teams, OneDrive, Intune, and others), and each of those counts as a separate license unit in the API.
EVALUATE
ROW(
"TotalUsers", [Total Users],
"UniqueSKUs", [Unique SKUs],
"TotalLicenses", [Total Licenses],
"LicensesPerUser", DIVIDE([Total Licenses], [Total Users])
)The 0.13% utilization number looks alarming, but context matters. Microsoft 365 licensing counts individual service plans as separate license units. A single E3 license includes Exchange, SharePoint, Teams, OneDrive, and 15+ other services, each counted separately. That is why 9,061 users generate millions of "licenses."
The real question is whether any paid SKUs have zero or near-zero consumption. The 424 licenses in warning state and 99 suspended licenses are worth reviewing. Warning status usually means a subscription is approaching expiration or has billing issues.
With 137 unique SKUs, there is almost certainly overlap and redundancy. Microsoft licensing is notoriously complex. A focused audit of the top 20 SKUs by cost would likely reveal 2 to 5 that can be downgraded or removed.
These may be subscriptions about to expire or with payment issues. Resolve before they become suspended.
Suspended means the license is no longer functional. Either remove them or reactivate. Paying for suspended licenses is waste.
But do run a per-SKU audit to find actually unused paid subscriptions. Filter by paid SKUs only, then compare consumed vs available per SKU.
Microsoft counts each service plan within a bundle as a separate license. An E3 license appears as 20+ individual license units. The "total licenses" number reflects service plan entitlements, not purchased seats. That inflates the denominator and makes utilization look artificially low.
A license approaching its renewal date or with a billing issue. It still works but needs attention. If left unresolved, warning licenses typically transition to suspended status after a grace period.
Filter by paid SKUs only, then compare consumed vs available per SKU. Look for SKUs where consumed is below 50% of available. Those are your candidates for downsizing or removal. Free trial SKUs and included service plans can be excluded from the analysis.
Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.
See more reports Get started