Forum Discussion
Partner Center API: Getting subscription usage count
It's been a while since I tried to do something along those lines, and it may have been pre-NCE. But I recall having to use "Offers" to link up Subscriptions and Licenses, finding the same disconnect you did.
I got SubscribedSkus as you did, plus:
https://learn.microsoft.com/en-us/partner-center/developer/get-all-of-a-customer-s-subscriptions
To get all their Subscriptions, but Orders as you're doing probably works as well.
And was able to link them using Offers:
https://learn.microsoft.com/en-us/rest/api/partner-center/manage-orders/get-a-list-of-offers-for-a-market
Things may have changed since I last tried, but see if you can use a known Customer's SKUs, Subscriptions, various IDs and compare with Offers - I'm sure I found OfferID matched ProductID or something.
Microsoft has Products which are made up of Product SKUs, the product catalogue lists Offers of how these Products are sold. Customers get Subscriptions to Offers, and can have multiple Offers all for the same underlying License. (Again, fuzzy memory for all this, but it wasn't a straight line between SKU and Subscription, since from a License perspective it doesn't matter if it's an O365 E3 Trial or Charity or Gov't Offer of the O365 E3 Product, within the customer's tenant they would just have the total of all those Subscriptions). I was dealing with all this in the 2019 - 2020 timeframe, so could be dated.
There's also a semi-frequently updated list here:
https://learn.microsoft.com/en-us/entra/identity/users/licensing-service-plan-reference
But I've found it is never complete.
--Saul