Intro
Lately, I have been looking at Azure dashboards to provide a quick overview of services running in Azure. In this post, I want to show you how to create a dashboard showing the state of virtual machines, S2S VPN connections, and network peerings.

Azure Resource Graph Explorer (RGE)
The base for the dashboards in this post is RGE. I will create some queries to generate the data I want to show on my dashboard. RGE is a Kusto Query Language tool that allows you to query your Azure resource with lightning speed. You could find all the information with PowerShell or another tool, but using RGE is a lot faster. One important thing to remember is that RGE queries are case-sensitive, so check the casing if your results are not as expected. To query my VMs, I need to find which table contains information about VMs. I can see this table by going to a VM in the portal and selecting “Properties.” The portal will now show me the “Resource ID,” In that context, I can find the table name right after “/providers/.” In this case, the table I need to query will be “Microsoft.Compute/VirtualMachines.”