Azure Monitor Alert Workbook

Did you know there’s all sorts of data in Azure Resource Graph, specifically all your active Azure Monitor alerts and your Alert inventory? If not why didnt you read my last post? Anyway we have all this wonderful data, but not native built in reporting, in Azure Monitor like other monitoring tools like System Center …

Read more

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

Pretty much every blog I’ve produced is a real world solution that I have used in production. Sometimes they are solutions I have worked on recently, sometimes months or even a year has gone by before I finally wrote it down. Sometimes blogging and a real world solution occur at the exact same time. I …

Read more