Show licenses overview on Azure Workbooks

Marino Valentino 25 Reputation points
2023-03-25T14:13:50.4933333+00:00

Hi,

I would like to add the following Graph query:

https://graph.microsoft.com/v1.0/subscribedSkus?$select=skuPartNumber,consumedUnits,prepaidUnits on an Azure Workbooks. Is there a way to show missing licenses on a Azure Workbooks.

Thanks

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,960 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,231 questions
Accepted answer
  1. Patchfox 3,806 Reputation points
    2023-03-25T16:39:26.2333333+00:00

    Hi Marino Valentino, thanks for answering my question.

    If I understood you correctly, you want to create an Azure Workbook that requests data from the mentioned Microsoft Graph endpoint and displays it in the Workbook.

    Unfortunately, this is not currently possible because Azure Workbook does not have an OAuth function to query the Access Token. A one-time creation of the Access Token would be possible with an AzureAD Enterprise App but makes no sense as I assume you need live data which is only possible with an OAuth lifecycle in the background.

    If the reply was helpful, please don’t forget to upvote or accept it as an answer, thank you.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Crowley 126 Reputation points
    2024-06-29T16:13:03.81+00:00

    This can be done by having the workbook query a log analytics workspace, which is populated by Power Automate.

    0 comments