Azure Service Health Workbook

Hello again, are you spending enough time in Azure Resource Graph (ARG) explorer? If not, you really should, there’s a treasure trove of data in there. The sad part is, either customers aren’t aware of it, or if they are the respective Product Groups aren’t doing a whole lot with the data. In particular with …

Read more

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

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