Build Azure Policy Compliance Workbook

Did you know that your Azure Policy data is in Azure Resource Graph? It is under the policyresources table. Since it is in Azure Resource Graph that means we can query it from Azure Workbooks, and create Workbooks like my inventory workbook. If you’re not familiar with Azure Resource Graph I have a primer you …

Read more

How to use Grouping Azure Workbooks

This is the second post in some Azure Workbooks quick tips. You can find the first one here. As your Azure environment grows, you’re likely to encounter situations where you have 2 or more subscriptions. Or if you are using Azure Lighthouse you might have dozens or hundreds of subscriptions under your management. This can …

Read more

How to Show Azure Resource Icons in Workbooks

One of my favorite tricks when building Azure Monitor or Azure Sentinel workbooks is to include the Azure Resource specific icons next to resources. For metric based resources the icons are including for you automatically when using Grid visualization. But for logs, you need to bring in  ‘_ResourceId’ in Log Analytics. For Azure Resourec Graph …

Read more

Windows Virtual Desktop (WVD) Azure Monitor Workbook

Today I’ve got another Azure Monitor Workbook, this time for Windows Virtual Desktop (WVD). This workbook uses exclusively Log Analytics data IaaS data, so it will work with both WVD 1.0 and 2.0. Though there are some nice logs available in the diagnostic settings for WVD 2.0. If this is your first time on my …

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 SQL Insights Workbook

Today I have a workbook long in the making. This workbook is for Azure SQL DBs, SQL DW and Elastic Pool servers. This is my most in depth Azure Monitor workbook to date and brings in Metrics and Logs in from across your Azure SQL resources. I’ve said a few times on twitter that if …

Read more

Azure Monitor Change Tracking Workbook

I’m back again, with another workbook. This time for Azure Automation Change Tracking solution for Azure Monitor. If you’ve read my blog at all, you know Change Tracking is one of my favorite solutions for Azure Monitor. You can track your services, as well as registry and software and files, on both Linux and Windows. …

Read more