Share via

How to create a azure workbook where only affected resources are displayed with details

Pritesh Kamble 0 Reputation points
2025-04-03T14:56:23.98+00:00

I want to create a workbook that displays only affected resources on dashboard. For example, out of my 50 storage accounts, 20 of them have used 80% or above storage capacity. so i want to display only those storage accounts on my dashboard.

Another scenario, i have 50 VMs and 17 of them have CPU usage above 90%. So out of 50 only 17 VMs should be displayed in the workbook.

I have tried creating a workbook with resource graph query but unable to achieve above mentioned scenario.

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 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Luke Murray 11,521 Reputation points MVP Volunteer Moderator
    2025-04-09T08:36:02.8366667+00:00

    Try the workbook here: https://pastebin.com/2XaGUNKx

    It was modified using AI, and I haven't been able to test it.

    User's image

    0 comments
  2. Clive Watson 7,946 Reputation points MVP Volunteer Moderator
    2025-04-16T09:04:50.37+00:00

    Like the storage Workbook you'll need a some KQL like this to find the CPU threshold, its not in the ARG, so you'll need some other data. This will form the dropdown in the workbook or just hardcoded into a query/grid.

    InsightsMetrics 
| where Name == 'UtilizationPercentage'
| where Val > 90
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.