Azure Resource Graph

Purpose

To provide a example queries for Azure Resource Graph.

Many of these queries are from Azure Iventory Workbook you can find here. https://github.com/scautomation/Azure-Inventory-Workbook

Jump to queries

Overview queries https://github.com/scautomation/AzureResourceGraph-Examples/blob/master/resourceQueries/Overview.MD

PaaS https://github.com/scautomation/AzureResourceGraph-Examples/tree/master/resourceQueries/PaaS

Compute https://github.com/scautomation/AzureResourceGraph-Examples/tree/master/resourceQueries/Compute

Monitor and Security https://github.com/scautomation/AzureResourceGraph-Examples/blob/master/resourceQueries/Monitor%20and%20Security/Monitor.MD

Networking https://github.com/scautomation/AzureResourceGraph-Examples/blob/master/resourceQueries/Networking/Networking.MD

Orhaned Resources https://github.com/scautomation/AzureResourceGraph-Examples/blob/master/resourceQueries/Orphaned%20Resources/OrphanedResource.MD

Resource Tagging https://github.com/scautomation/AzureResourceGraph-Examples/tree/master/tagQueries

Kusto Query Language

Azure Resource Graph uses a subset of the Kusto Query Language. At this time not all functions found in Kusto are available in Resource Graph. Kusto is also used in Log Analytics, Azure Sentinel, Application Insights, Azure Data Explorer, SCCM CMPivot, Windows Defender ATP.

Azure Resource Grpah language reference. https://docs.microsoft.com/en-us/azure/governance/resource-graph/samples/starter?tabs=azure-cli