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 …
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 …
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 …
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 …
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 …
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 …
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 …