graph api query or filter subscribedSku by skuPartNumber

Question

I have requirement to get the consumed units and prepaid units enabled based on skuPartNumber using graph api. is there way to apply query or filter conditions along with https://graph.microsoft.com/v1.0/subscribedSkus

Answer 1

Hello @Srinivas Gamidi , according to the documentation, this method currently supports a $select parameter to customize the response.

And I tested locally with the endpoint: https://graph.microsoft.com/v1.0/subscribedSkus?$select=capabilityStatus,skuPartNumber,consumedUnits,prepaidUnits to fetch the properties capabilityStatus,skuPartNumber,consumedUnits,prepaidUnits like below. Hope it is helpful to you.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Nice! Great for keeping others not in IT (finance) notified when the licenses are getting low.

Is it possible to filter the prepaidUnits down to just "enabled"?

I'm still fairly new to the Graph queries and would just like to flatten the data to have skupartnumber and enabled on the same tier.