Azure Monitor Alert Reports with Azure Resource Graph

In this post I’ll show you how to extract just about any Azure Monitor Alert information with Azure Resource Graph. With this data we can build some pretty neat Azure Monitor Alert reports. For Azure Monitor alerts we have two tables in Azure Resource Graph. Alertsmanagementresources and the resources table. Alerts management resources table has …

Read more

Find Orphaned Azure Resources

As a follow up to my Azure Resource Graph examples repo, I have a few queries to find orphaned Azure resources. These queries are all in the repo, but I’m doing a separate post on this because I feel its a pretty common problem to have orphaned resources. I will also be adding more queries …

Read more

Azure Resource Graph Examples and Github Repo

Today I’m releasing my Azure Resource Graph examples repo. This has been an internal repo I created and shared internally late 2019. Now everyone gets to benefit! Bonus, I have taken every query out of my Ultimate Azure Inventory workbook and added them to the repo as well. TLDR you can find the Azure Resource …

Read more

The Ultimate Azure Inventory Dashboard

Today I’m excited to finally share with you something that I’ve been working on for weeks. This project entailed many many hours of work. It is, An Azure Inventory Dashboard using Azure Monitor Workbooks. The original version of this Workbook was shown in my Workbooks video I made last year. In that same video I …

Read more

Azure Monitor, Sentinel QuickStart Workbook templates

If you’ve followed me at all over the last few years, I make a lot of workbooks. I have a number of them on my github. I have these workbooks for your usage, completely free. LogicApps/Azure Sentinel Playbooks Azure Automation Update Management Azure File Sync Syslog Windows Event Log But now I’m putting out the …

Read more

Extracting Nested Fields in Kusto

PSST: you could read this post. Orrrr you could check out the new 2.0 version, which has way more examples. Extracting Nested Fields in Kusto 2.0 – Cloud, Systems Management and Automation (cloudsma.com)     Pretty much every blog I’ve produced is a real world solution that I have used in production. Sometimes they are …

Read more

Azure Advent Calendar: Azure Monitor Workbooks

The Azure Advent Calendar is a great idea from Gregor Suttie and Richard Hooper. Community members the world over have contributed videos pertaining to Azure. My video is on Azure Monitor Workbooks. In the video I take you through many of the useful features of Workbooks. Video Outline Below is the rough video outline with …

Read more