{ "version": "Notebook/1.0", "items": [ { "type": 1, "content": { "json": "# Azure Orphaned Resources v2.0\r\nUse this workbook to analyze all your Orphaned resources." }, "name": "text - Title" }, { "type": 9, "content": { "version": "KqlParameterItem/1.0", "parameters": [ { "id": "91c13326-3422-4d1c-b3e3-1aa27414e7ae", "version": "KqlParameterItem/1.0", "name": "Subscription", "type": 6, "isRequired": true, "multiSelect": true, "quote": "'", "delimiter": ",", "typeSettings": { "additionalResourceOptions": [ "value::all" ], "includeAll": true, "showDefault": false }, "timeContext": { "durationMs": 86400000 }, "value": [ "value::all" ] } ], "style": "pills", "queryType": 0, "resourceType": "microsoft.operationalinsights/workspaces" }, "name": "parameters - Filter by Subscription" }, { "type": 11, "content": { "version": "LinkItem/1.0", "style": "tabs", "links": [ { "id": "4d474c43-d09f-4c07-929e-82d46b1e90af", "cellValue": "mainTab", "linkTarget": "parameter", "linkLabel": "Overview", "subTarget": "overview", "style": "link", "linkIsContextBlade": true }, { "id": "0fb04c14-d289-4e05-aa49-ec7e34aed8e9", "cellValue": "mainTab", "linkTarget": "parameter", "linkLabel": "Compute", "subTarget": "compute", "style": "link" }, { "id": "36a36461-8f96-4d01-a9f9-b918dffeb4ff", "cellValue": "mainTab", "linkTarget": "parameter", "linkLabel": "Storage", "subTarget": "storage", "style": "link" }, { "id": "7688ca90-bb93-4017-b79c-c505b7f5ba46", "cellValue": "mainTab", "linkTarget": "parameter", "linkLabel": "Database", "subTarget": "database", "style": "link" }, { "id": "fe44dca2-c58c-419a-9dbf-899697e07bef", "cellValue": "mainTab", "linkTarget": "parameter", "linkLabel": "Networking", "subTarget": "networking", "style": "link" }, { "id": "3b796649-537c-44c2-be19-95cd16e4eae1", "cellValue": "mainTab", "linkTarget": "parameter", "linkLabel": "Others", "subTarget": "others", "style": "link" } ] }, "name": "links - Main Tabs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "### Azure Orphaned Resources Workbook\r\n\r\nThe purpose of this workbook is to provide an overview of your orphaned resources, enabling you to enhance eficiency by:\r\n\r\n- Saving money\r\n- Prevent misconfiguration\r\n- Simplify operations\r\n\r\n\r\n [Please submit any issues ](https://github.com/dolevshor/azure-orphan-resources/issues) with the workbook template to GitHub.", "style": "upsell" }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "overview" }, "showPin": false, "name": "text - Overview" }, { "type": 1, "content": { "json": "💲 This is a sign that the resource costs money", "style": "info" }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "overview" }, "name": "text - Overview - Cost" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.web/serverfarms\"\r\n| where properties.numberOfSites == 0\r\n| summarize count(type)", "size": 4, "title": "App Service Plans 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortCriteriaField": "count_type", "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - App Service Plans Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type =~ 'Microsoft.Compute/availabilitySets'\r\n| where properties.virtualMachines == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Availability Sets", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Availability Sets Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.compute/disks\"\r\n| extend diskState = tostring(properties.diskState)\r\n| where managedBy == \"\"\r\n| where not(name endswith \"-ASRReplica\" or name startswith \"ms-asr-\" or name startswith \"asrseeddisk-\")\r\n| summarize count(type)", "size": 4, "title": "Managed Disks 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Disks Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.sql/servers/elasticpools'\r\n| project elasticPoolId = tolower(id), Resource = id, type\r\n| extend Details = pack_all()\r\n| join kind=leftouter (resources\r\n| where type =~ 'Microsoft.Sql/servers/databases'\r\n| project id, properties\r\n| extend elasticPoolId = tolower(properties.elasticPoolId)) on elasticPoolId\r\n| summarize databaseCount = countif(id != '') by Resource, type\r\n| where databaseCount == 0\r\n| project-away databaseCount\r\n| summarize count(type)", "size": 4, "title": "SQL elastic pools 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - SQL elastic pools Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/publicipaddresses\"\r\n| where properties.ipConfiguration == \"\" and properties.natGateway == \"\" and properties.publicIPPrefix == \"\"\r\n| summarize count(type)", "size": 4, "title": "Public IPs 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Public IPs Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.network/networkinterfaces\"\r\n| where isnull(properties.privateEndpoint)\r\n| where isnull(properties.privateLinkService)\r\n| where properties.hostedWorkloads == \"[]\"\r\n| where properties !has 'virtualmachine'\r\n| summarize count(type)", "size": 4, "title": "Network Interfaces", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Network Interfaces Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/networksecuritygroups\" and isnull(properties.networkInterfaces) and isnull(properties.subnets)\r\n| summarize count(type)", "size": 4, "title": "Network Security Group", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Network Security Group Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/routetables\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type)", "size": 4, "title": "Route Tables", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Route Tables Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/loadbalancers\"\r\n| where properties.backendAddressPools == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Load Balancers 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Load Balancers Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/frontdoorwebapplicationfirewallpolicies\"\r\n| where properties.frontendEndpointLinks== \"[]\" and properties.securityPolicyLinks == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Front Door WAF Policy", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Front Door WAF Policy Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/trafficmanagerprofiles\"\r\n| where properties.endpoints == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Traffic Manager Profiles", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Traffic Manager Profiles Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.network/applicationgateways'\r\n| extend backendPoolsCount = array_length(properties.backendAddressPools),SKUName= tostring(properties.sku.name), SKUTier= tostring(properties.sku.tier),SKUCapacity=properties.sku.capacity,backendPools=properties.backendAddressPools , AppGwId = tostring(id)\r\n| project AppGwId, name, SKUName, SKUTier, SKUCapacity\r\n| join (\r\n resources\r\n | where type =~ 'microsoft.network/applicationgateways'\r\n | mvexpand backendPools = properties.backendAddressPools\r\n | extend backendIPCount = array_length(backendPools.properties.backendIPConfigurations)\r\n | extend backendAddressesCount = array_length(backendPools.properties.backendAddresses)\r\n | extend backendPoolName = backendPools.properties.backendAddressPools.name\r\n | extend AppGwId = tostring(id)\r\n | summarize backendIPCount = sum(backendIPCount) ,backendAddressesCount=sum(backendAddressesCount) by AppGwId\r\n) on AppGwId\r\n| project-away AppGwId1\r\n| where (backendIPCount == 0 or isempty(backendIPCount)) and (backendAddressesCount==0 or isempty(backendAddressesCount))\r\n| summarize count()", "size": 4, "title": "Application Gateway 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Application Gateway Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/virtualnetworks\"\r\n| where properties.subnets == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Virtual Networks", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Virtual Networks Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworks\"\r\n| extend subnet = properties.subnets\r\n| mv-expand subnet\r\n| extend ipConfigurations = subnet.properties.ipConfigurations\r\n| extend delegations = subnet.properties.delegations\r\n| where isnull(ipConfigurations) and delegations == \"[]\"\r\n| summarize count(subnet)", "size": 4, "title": "Subnets", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_subnet", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Subnets Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/natgateways\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type)", "size": 4, "title": "NAT Gateways 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - NAT Gateways Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ipgroups\"\r\n| where properties.firewalls == \"[]\" and properties.firewallPolicies == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "IP Groups", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - IP Groups Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/privatednszones\"\r\n| where properties.numberOfVirtualNetworkLinks == 0\r\n| summarize count(type)", "size": 4, "title": "Private DNS zones 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Private DNS zones Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/privateendpoints\"\r\n| extend connection = iff(array_length(properties.manualPrivateLinkServiceConnections) > 0, properties.manualPrivateLinkServiceConnections[0], properties.privateLinkServiceConnections[0])\r\n| extend stateEnum = tostring(connection.properties.privateLinkServiceConnectionState.status)\r\n| where stateEnum == \"Disconnected\"\r\n| summarize count(type)", "size": 4, "title": "Private Endpoints 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Private Endpoints Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworkgateways\"\r\n| extend vpnClientConfiguration = properties.vpnClientConfiguration\r\n| extend Resource = id\r\n| join kind=leftouter (\r\n resources\r\n | where type =~ \"microsoft.network/connections\"\r\n | mv-expand Resource = pack_array(properties.virtualNetworkGateway1.id, properties.virtualNetworkGateway2.id) to typeof(string)\r\n | project Resource, connectionId = id, ConnectionProperties=properties\r\n ) on Resource \r\n| where isempty(vpnClientConfiguration) and isempty(connectionId)\r\n| summarize count(type)", "size": 4, "title": "Virtual Network Gateways 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Virtual Network Gateway" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ddosprotectionplans\"\r\n| where isnull(properties.virtualNetworks)\r\n| summarize count(type)", "size": 4, "title": "DDoS protection plans 💲", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - DDoS protection plans" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "ResourceContainers\r\n| where type == \"microsoft.resources/subscriptions/resourcegroups\"\r\n| extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n| join kind=leftouter (\r\n Resources\r\n | extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n | summarize count() by rgAndSub\r\n) on rgAndSub\r\n| where isnull(count_)\r\n| summarize count(type)", "size": 4, "title": "Resource Groups", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Resource Groups Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'Microsoft.Web/connections'\r\n| project resourceId = id , apiName = name, subscriptionId, resourceGroup, tags, location\r\n| join kind = leftouter (\r\n resources\r\n | where type == 'microsoft.logic/workflows'\r\n | extend resourceGroup, location, subscriptionId, properties\r\n | extend var_json = properties[\"parameters\"][\"$connections\"][\"value\"]\r\n\t| mvexpand var_connection = var_json\r\n | where notnull(var_connection)\r\n | extend connectionId = extract(\"connectionId\\\":\\\"(.*?)\\\"\", 1, tostring(var_connection))\r\n | project connectionId, name\r\n )\r\n on $left.resourceId == $right.connectionId\r\n| where connectionId == \"\"\r\n| summarize count()", "size": 4, "title": "API Connections", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - API Connections Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == 'microsoft.web/certificates'\r\n| extend expiresOn = todatetime(properties.expirationDate)\r\n| where expiresOn <= now()\r\n| summarize count(type)", "size": 4, "title": "Certificates", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "16.5", "name": "query - Overview - Certificates Count" } ] }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "overview" }, "name": "group - Overview - Summary" } ] }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "overview" }, "name": "group - Overview" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 11, "content": { "version": "LinkItem/1.0", "style": "tabs", "links": [ { "id": "8e1c6962-5369-4cc3-9fe9-1ff6ed0d92af", "cellValue": "computeTab", "linkTarget": "parameter", "linkLabel": "App Service Plans 💲", "subTarget": "appsp", "style": "link", "linkIsContextBlade": true }, { "id": "85598350-5dc0-4087-ae66-b50d4aeadba7", "cellValue": "computeTab", "linkTarget": "parameter", "linkLabel": "Availability Sets", "subTarget": "avset", "style": "link" } ] }, "name": "links - Compute Tabs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned App Service Plans" }, "name": "text - Title - App Service Plan" }, { "type": 1, "content": { "json": "[App Service plans](https://learn.microsoft.com/en-us/azure/app-service/overview-hosting-plans) without hosting Apps.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.web/serverfarms\"\r\n| where properties.numberOfSites == 0\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - App Service Plan count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.web/serverfarms\"\r\n| where properties.numberOfSites == 0\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "conditionalVisibility": { "parameterName": "computeTab", "comparison": "isEqualTo", "value": "appsp" }, "name": "query - App Service Plan by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.web/serverfarms\"\r\n| where properties.numberOfSites == 0\r\n| summarize count(type) by tostring(sku.name)", "size": 4, "title": "Count by SKU", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "conditionalVisibility": { "parameterName": "computeTab", "comparison": "isEqualTo", "value": "appsp" }, "name": "query - App Service Plan by SKU" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.web/serverfarms\"\r\n| where properties.numberOfSites == 0\r\n| summarize count(type) by tostring(sku.tier)", "size": 4, "title": "Count by Tier", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "conditionalVisibility": { "parameterName": "computeTab", "comparison": "isEqualTo", "value": "appsp" }, "name": "query - App Service Plan by Tier" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.web/serverfarms\"\r\n| where properties.numberOfSites == 0\r\n| extend Details = pack_all()\r\n| project Resource=id, resourceGroup, location, subscriptionId, SKU=sku.name, Tier=sku.tier, tags ,Details", "size": 3, "title": "Orphaned App Service Plans", "noDataMessage": "No orphaned App Service Plans found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "SKU", "formatter": 1 }, { "columnMatch": "Tier", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Sku", "formatter": 1 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "SKU", "label": "Sku" }, { "columnId": "Tier", "label": "Tier" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - App Service Plans" } ] }, "conditionalVisibility": { "parameterName": "computeTab", "comparison": "isEqualTo", "value": "appsp" }, "name": "group - Compute - App Service Plan" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Availability Set" }, "name": "text - Title - Availability Set" }, { "type": 1, "content": { "json": "[Availability Sets](https://learn.microsoft.com/en-us/azure/virtual-machines/availability-set-overview) that not associated to any Virtual Machine (VM) or Virtual Machine Scale Set (VMSS).", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type =~ 'Microsoft.Compute/availabilitySets'\r\n| where properties.virtualMachines == \"[]\"\r\n| summarize count(type)\r\n", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Availability Set Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type =~ 'Microsoft.Compute/availabilitySets'\r\n| where properties.virtualMachines == \"[]\"\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Availability Set by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type =~ 'Microsoft.Compute/availabilitySets'\r\n| where properties.virtualMachines == \"[]\"\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tags, Details", "size": 3, "title": "Orphaned Availability Set", "noDataMessage": "No orphaned Availability Set found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "conditionalVisibility": { "parameterName": "computeTab", "comparison": "isEqualTo", "value": "avset" }, "name": "query - Orphan Availability Set" } ] }, "conditionalVisibility": { "parameterName": "computeTab", "comparison": "isEqualTo", "value": "avset" }, "name": "group - Compute - Availability Set" } ] }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "compute" }, "name": "group - Compute" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 11, "content": { "version": "LinkItem/1.0", "style": "tabs", "links": [ { "id": "b2a47b9d-1023-418a-8ffc-67a693c0d5a6", "cellValue": "storageTab", "linkTarget": "parameter", "linkLabel": "Managed Disks 💲", "subTarget": "disks", "style": "link", "linkIsContextBlade": true } ] }, "name": "links - Storage Tabs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Managed Disks" }, "name": "text - Title - Disks" }, { "type": 1, "content": { "json": "[Managed Disks](https://learn.microsoft.com/en-us/azure/virtual-machines/managed-disks-overview) with 'Unattached' state and not related to Azure Site Recovery.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.compute/disks\"\r\n| extend diskState = tostring(properties.diskState)\r\n| where managedBy == \"\"\r\n| where not(name endswith \"-ASRReplica\" or name startswith \"ms-asr-\" or name startswith \"asrseeddisk-\")\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Total Disks Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.compute/disks\"\r\n| extend diskState = tostring(properties.diskState)\r\n| where managedBy == \"\"\r\n| where not(name endswith \"-ASRReplica\" or name startswith \"ms-asr-\" or name startswith \"asrseeddisk-\")\r\n| extend SizeGB = tolong(properties.diskSizeGB)\r\n| summarize ['Total Disk Size (GB)']=sum(SizeGB)", "size": 4, "title": "Disks Size (GB)", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "Total Disk Size (GB)", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Disk Size (GB)" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.compute/disks\"\r\n| extend diskState = tostring(properties.diskState)\r\n| where managedBy == \"\"\r\n| where not(name endswith \"-ASRReplica\" or name startswith \"ms-asr-\" or name startswith \"asrseeddisk-\")\r\n| summarize Count=count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Disks by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.compute/disks\"\r\n| extend diskState = tostring(properties.diskState)\r\n| where managedBy == \"\"\r\n| where not(name endswith \"-ASRReplica\" or name startswith \"ms-asr-\" or name startswith \"asrseeddisk-\")\r\n| summarize Count=count(type) by DiskType=tostring(sku.name)", "size": 4, "title": "Count by Disk Type", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Disks by DiskType" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.compute/disks\"\r\n| extend diskState = tostring(properties.diskState)\r\n| where managedBy == \"\" or diskState == 'Unattached'\r\n| where not(name endswith \"-ASRReplica\" or name startswith \"ms-asr-\" or name startswith \"asrseeddisk-\")\r\n| extend Details = pack_all()\r\n| project id, resourceGroup, location, sku.name, properties.diskSizeGB, properties.timeCreated, tags, subscriptionId, Details\r\n", "size": 3, "title": "Orphaned Managed Disks", "noDataMessage": "No orphaned Managed Disks found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "sku_name", "formatter": 1 }, { "columnMatch": "properties_diskSizeGB", "formatter": 1 }, { "columnMatch": "properties_timeCreated", "formatter": 6 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "id", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "sku_name", "label": "Disk Type" }, { "columnId": "properties_diskSizeGB", "label": "Disk Size (GB)" }, { "columnId": "properties_timeCreated", "label": "Time Created" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Managed Disks" } ] }, "conditionalVisibility": { "parameterName": "storageTab", "comparison": "isEqualTo", "value": "disks" }, "name": "group - Storage - Manaded Disks" } ] }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "storage" }, "name": "group - Storage" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 11, "content": { "version": "LinkItem/1.0", "style": "tabs", "links": [ { "id": "b2a47b9d-1023-418a-8ffc-67a693c0d5a6", "cellValue": "databaseTab", "linkTarget": "parameter", "linkLabel": "SQL elastic pools 💲", "subTarget": "sqlelasticpools", "style": "link", "linkIsContextBlade": true } ] }, "name": "links - Database Tabs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned SQL elastic pools" }, "name": "text - Title - SQL elastic pools" }, { "type": 1, "content": { "json": "[SQL elastic pools](https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-overview) without databases.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.sql/servers/elasticpools'\r\n| project elasticPoolId = tolower(id), Resource = id, type\r\n| extend Details = pack_all()\r\n| join kind=leftouter (resources\r\n| where type =~ 'Microsoft.Sql/servers/databases'\r\n| project id, properties\r\n| extend elasticPoolId = tolower(properties.elasticPoolId)) on elasticPoolId\r\n| summarize databaseCount = countif(id != '') by Resource, type\r\n| where databaseCount == 0\r\n| project-away databaseCount\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Total SQL elastic pools Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.sql/servers/elasticpools'\r\n| project elasticPoolId = tolower(id), Resource = id, type, location\r\n| extend Details = pack_all()\r\n| join kind=leftouter (resources\r\n| where type =~ 'Microsoft.Sql/servers/databases'\r\n| project id, properties\r\n| extend elasticPoolId = tolower(properties.elasticPoolId)) on elasticPoolId\r\n| summarize databaseCount = countif(id != '') by Resource, type, location\r\n| where databaseCount == 0\r\n| project-away databaseCount\r\n| summarize Count=count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - SQL elastic pools by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.sql/servers/elasticpools'\r\n| project elasticPoolId = tolower(id), Resource = id, type, skuName = sku.name\r\n| extend Details = pack_all()\r\n| join kind=leftouter (resources\r\n| where type =~ 'Microsoft.Sql/servers/databases'\r\n| project id, properties\r\n| extend elasticPoolId = tolower(properties.elasticPoolId)) on elasticPoolId\r\n| summarize databaseCount = countif(id != '') by Resource, type, tostring(skuName)\r\n| where databaseCount == 0\r\n| project-away databaseCount\r\n| summarize Count=count(type) by skuName", "size": 4, "title": "Count by Type", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - SQL elastic pools by Type" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.sql/servers/elasticpools'\r\n| project elasticPoolId = tolower(id), Resource = id, type, skuTier = sku.tier\r\n| extend Details = pack_all()\r\n| join kind=leftouter (resources\r\n| where type =~ 'Microsoft.Sql/servers/databases'\r\n| project id, properties\r\n| extend elasticPoolId = tolower(properties.elasticPoolId)) on elasticPoolId\r\n| summarize databaseCount = countif(id != '') by Resource, type, tostring(skuTier)\r\n| where databaseCount == 0\r\n| project-away databaseCount\r\n| summarize Count=count(type) by skuTier", "size": 4, "title": "Count by Tier", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - SQL elastic pools by Tier" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.sql/servers/elasticpools'\r\n| project elasticPoolId = tolower(id), Resource = id, resourceGroup, location, skuName = sku.name, skuTier = sku.tier, subscriptionId, tags, properties, Details = pack_all()\r\n| join kind=leftouter (resources\r\n| where type =~ 'Microsoft.Sql/servers/databases'\r\n| project id, properties\r\n| extend elasticPoolId = tolower(properties.elasticPoolId)) on elasticPoolId\r\n| summarize databaseCount = countif(id != '') by Resource, resourceGroup, location, Type=tostring(skuName), Tier=tostring(skuTier), subscriptionId, Tags=tostring(tags), tostring(Details)\r\n| where databaseCount == 0\r\n| project-away databaseCount", "size": 3, "title": "Orphaned SQL elastic pools", "noDataMessage": "No orphaned SQL elastic pools found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Tags", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkIsContextBlade": true } }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "tags", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "sku_name", "formatter": 1 }, { "columnMatch": "properties_diskSizeGB", "formatter": 1 }, { "columnMatch": "properties_timeCreated", "formatter": 6 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "Type", "label": "Type" }, { "columnId": "Tier", "label": "Tier" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - SQL elastic pools" } ] }, "conditionalVisibility": { "parameterName": "databaseTab", "comparison": "isEqualTo", "value": "sqlelasticpools" }, "name": "group - Database - SQL elastic pools" } ] }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "database" }, "name": "group - Database" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 11, "content": { "version": "LinkItem/1.0", "style": "tabs", "links": [ { "id": "75dbecf0-d939-484a-a9b6-7ac357384d56", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Public IPs 💲", "subTarget": "publicips", "style": "link" }, { "id": "b2a47b9d-1023-418a-8ffc-67a693c0d5a6", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Network Interfaces", "subTarget": "nics", "style": "link", "linkIsContextBlade": true }, { "id": "08ce5f59-a9bd-4a43-93c6-1c6221ec734f", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Network Security Groups", "subTarget": "nsg", "style": "link" }, { "id": "66b996b0-d586-40d7-9097-c707ff68a6da", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Route Tables", "subTarget": "routetables", "style": "link" }, { "id": "6fcbb7f1-d77e-4efb-9f3f-d520801aa8f6", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Load Balancers 💲", "subTarget": "loadbalancers", "style": "link" }, { "id": "3582e9a9-f35a-4ebb-9077-09e22aae768c", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Front Door WAF Policy", "subTarget": "fdwafpolicy", "style": "link" }, { "id": "a63893e8-9852-4406-a6dd-22af3738b25c", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Traffic Managers", "subTarget": "tmprofiles", "style": "link" }, { "id": "de4a5d0f-4ad2-4616-931f-039bd72b9dc0", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Application Gateways 💲", "subTarget": "appgw", "style": "link" }, { "id": "1069ee4a-8cd4-4b81-8bdc-0f80a11f02ac", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Virtual Networks", "subTarget": "vnets", "style": "link" }, { "id": "388ae01a-7666-4f02-ae9e-fd6debfa177d", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "NAT Gateways 💲", "subTarget": "natgw", "style": "link" }, { "id": "4c4a8734-1a0c-4d83-826c-9c7310e2e9be", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "IP Groups", "subTarget": "ipgroup", "style": "link" }, { "id": "a538397c-15d8-449c-9068-1eef3caa9a80", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Private DNS zones 💲", "subTarget": "privatednszones", "style": "link" }, { "id": "30275d35-8385-4327-bb0e-4497057f63f0", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Private Endpoints 💲", "subTarget": "privateendpoints", "style": "link" }, { "id": "2b5c6c87-9f7e-4afa-894e-e2e0804dd473", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "Virtual Network Gateways 💲", "subTarget": "vngs", "style": "link" }, { "id": "5a32b401-ae7a-43da-897f-b6f18bbc125b", "cellValue": "networkingTab", "linkTarget": "parameter", "linkLabel": "DDoS protection plans 💲", "subTarget": "DDoSplans", "style": "link" } ] }, "name": "links - Networking Tabs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Public IPs" }, "name": "text - Title - Public IPs" }, { "type": 1, "content": { "json": "[Public IPs](https://learn.microsoft.com/en-us/azure/virtual-network/ip-services/public-ip-addresses) that are not attached to any resource (VM, NAT Gateway, Load Balancer, Application Gateway, Public IP Prefix, etc.).", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/publicipaddresses\"\r\n| where properties.ipConfiguration == \"\" and properties.natGateway == \"\" and properties.publicIPPrefix == \"\"\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Public IPs Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/publicipaddresses\"\r\n| where properties.ipConfiguration == \"\" and properties.natGateway == \"\" and properties.publicIPPrefix == \"\"\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Public IPs by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/publicipaddresses\"\r\n| where properties.ipConfiguration == \"\" and properties.natGateway == \"\" and properties.publicIPPrefix == \"\"\r\n| summarize count(type) by tostring(sku.name)", "size": 4, "title": "Count by Type", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Public IPs by Type" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/publicipaddresses\"\r\n| where properties.ipConfiguration == \"\" and properties.natGateway == \"\" and properties.publicIPPrefix == \"\"\r\n| summarize count(type) by AllocationMethod=tostring(properties.publicIPAllocationMethod)", "size": 4, "title": "Count by Allocation Method", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Public IPs by Allocation Method" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/publicipaddresses\"\r\n| where properties.ipConfiguration == \"\" and properties.natGateway == \"\" and properties.publicIPPrefix == \"\"\r\n| extend Details = pack_all()\r\n| project Resource=id, resourceGroup, location, subscriptionId, tostring(sku.name), AllocationMethod=tostring(properties.publicIPAllocationMethod), tags, Details", "size": 3, "title": "Orphaned Public IPs", "noDataMessage": "No orphaned Public IPs found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "sku_name", "formatter": 1 }, { "columnMatch": "AllocationMethod", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "sortBy": [ { "itemKey": "resourceGroup", "sortOrder": 2 } ], "labelSettings": [ { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "sku_name", "label": "Type" }, { "columnId": "AllocationMethod", "label": "Allocation Method" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [ { "itemKey": "resourceGroup", "sortOrder": 2 } ], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Public IPs" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "publicips" }, "name": "group - Networking - Public IPs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Network Interfaces" }, "name": "text - Title - Network Interfaces" }, { "type": 1, "content": { "json": "[Network Interfaces](https://learn.microsoft.com/en-us/azure/virtual-network/ip-services/private-ip-addresses) that are not attached to any resource.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.network/networkinterfaces\"\r\n| where isnull(properties.privateEndpoint)\r\n| where isnull(properties.privateLinkService)\r\n| where properties.hostedWorkloads == \"[]\"\r\n| where properties !has 'virtualmachine'\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Network Interfaces Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.network/networkinterfaces\"\r\n| where isnull(properties.privateEndpoint)\r\n| where isnull(properties.privateLinkService)\r\n| where properties.hostedWorkloads == \"[]\"\r\n| where properties !has 'virtualmachine'\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Network Interfaces by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type has \"microsoft.network/networkinterfaces\"\r\n| where isnull(properties.privateEndpoint)\r\n| where isnull(properties.privateLinkService)\r\n| where properties.hostedWorkloads == \"[]\"\r\n| where properties !has 'virtualmachine'\r\n| extend Details = pack_all()\r\n| project Resource=id, resourceGroup, location, tags, subscriptionId, Details", "size": 3, "title": "Orphaned Network Interfaces", "noDataMessage": "No orphaned Network Interfaces found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "sortBy": [ { "itemKey": "resourceGroup", "sortOrder": 2 } ], "labelSettings": [ { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [ { "itemKey": "resourceGroup", "sortOrder": 2 } ], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Network Interfaces" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "nics" }, "name": "group - Networking - Network Interfaces" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Network Security Groups" }, "name": "text - Title - Network Security Groups" }, { "type": 1, "content": { "json": "[Network Security Group](https://learn.microsoft.com/en-us/azure/virtual-network/network-security-groups-overview) (NSGs) that are not attached to any network interface or subnet.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/networksecuritygroups\" and isnull(properties.networkInterfaces) and isnull(properties.subnets)\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - NSGs Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/networksecuritygroups\" and isnull(properties.networkInterfaces) and isnull(properties.subnets)\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - NSGs by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "Resources\r\n| where type == \"microsoft.network/networksecuritygroups\" and isnull(properties.networkInterfaces) and isnull(properties.subnets)\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tags, Details", "size": 3, "title": "Orphaned Network Security Group", "noDataMessage": "No orphaned NSGs found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - NSGs" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "nsg" }, "name": "group - Networking - Network Security Groups" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Route Tables" }, "name": "text - Title - Route Tables" }, { "type": 1, "content": { "json": "[Route Tables](https://learn.microsoft.com/en-us/azure/virtual-network/virtual-networks-udr-overview) that not attached to any subnet.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/routetables\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type)\r\n", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Route Tables Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/routetables\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Route Tables by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/routetables\"\r\n| where isnull(properties.subnets)\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tags, Details", "size": 3, "title": "Orphaned Route Tables", "noDataMessage": "No orphaned Route Tables found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Route Tables" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "routetables" }, "name": "group - Networking - Route Tables" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Load Balancers" }, "name": "text - Title - Load Balancers" }, { "type": 1, "content": { "json": "[Load Balancers](https://learn.microsoft.com/en-us/azure/load-balancer/load-balancer-overview) with empty backend address pools.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/loadbalancers\"\r\n| where properties.backendAddressPools == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Load Balancers count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/loadbalancers\"\r\n| where properties.backendAddressPools == \"[]\"\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Load Balancers by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/loadbalancers\"\r\n| where properties.backendAddressPools == \"[]\"\r\n| summarize count(type) by tostring(sku.name)", "size": 4, "title": "Count by Type", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Load Balancers by Type" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/loadbalancers\"\r\n| where properties.backendAddressPools == \"[]\"\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tostring(sku.name), tags, Details", "size": 3, "title": "Orphaned Load Balances", "noDataMessage": "No orphaned Load Balances found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "sku_name", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "sku_name", "label": "Type" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Load Balancers" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "loadbalancers" }, "name": "group - Networking - Load Balancers" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Front Door WAF Policy" }, "name": "text - Title - Front Door WAF Policy" }, { "type": 1, "content": { "json": "[Front Door WAF Policy](https://learn.microsoft.com/en-us/azure/web-application-firewall/afds/afds-overview) without associations. (Frontend Endpoint Links, Security Policy Links)", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/frontdoorwebapplicationfirewallpolicies\"\r\n| where properties.frontendEndpointLinks== \"[]\" and properties.securityPolicyLinks == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Front Door WAF Policy count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/frontdoorwebapplicationfirewallpolicies\"\r\n| where properties.frontendEndpointLinks== \"[]\" and properties.securityPolicyLinks == \"[]\"\r\n| summarize count(type) by tostring(sku.name)", "size": 4, "title": "Count by SKU", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query Front Door WAF Policy by SKU" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/frontdoorwebapplicationfirewallpolicies\"\r\n| where properties.frontendEndpointLinks== \"[]\" and properties.securityPolicyLinks == \"[]\"\r\n| extend Details = pack_all()\r\n| project Resource=id, resourceGroup, location, subscriptionId, SKU=sku.name, tags, Details", "size": 3, "title": "Orphaned Front Door WAF Policy", "noDataMessage": "No orphaned Front Door WAF Policy found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "SKU", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "SKU", "label": "Sku" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Front Door WAF Policy" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "fdwafpolicy" }, "name": "group - Networking - Front Door WAF Policy" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Traffic Managers" }, "name": "text - Title - Traffic Manager Profiles" }, { "type": 1, "content": { "json": "[Traffic Manager](https://learn.microsoft.com/en-us/azure/traffic-manager/traffic-manager-overview) without endpoints.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/trafficmanagerprofiles\"\r\n| where properties.endpoints == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Traffic Manager Profiles" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/trafficmanagerprofiles\"\r\n| where properties.endpoints == \"[]\"\r\n| extend Details = pack_all()\r\n| project Resource=id, resourceGroup, location, subscriptionId, tags, Details", "size": 3, "title": "Orphaned Traffic Managers", "noDataMessage": "No orphaned Traffic Managers found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Traffic Managers" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "tmprofiles" }, "name": "group - Networking - Traffic Managers" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Application Gateway" }, "name": "text - Title - Application Gateway" }, { "type": 1, "content": { "json": "[Application Gateways](https://learn.microsoft.com/en-us/azure/application-gateway/overview) without backend targets. (in backend pools)", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.network/applicationgateways'\r\n| extend backendPoolsCount = array_length(properties.backendAddressPools),SKUName= tostring(properties.sku.name), SKUTier= tostring(properties.sku.tier),SKUCapacity=properties.sku.capacity,backendPools=properties.backendAddressPools , AppGwId = tostring(id)\r\n| project AppGwId, name, SKUName, SKUTier, SKUCapacity\r\n| join (\r\n resources\r\n | where type =~ 'microsoft.network/applicationgateways'\r\n | mvexpand backendPools = properties.backendAddressPools\r\n | extend backendIPCount = array_length(backendPools.properties.backendIPConfigurations)\r\n | extend backendAddressesCount = array_length(backendPools.properties.backendAddresses)\r\n | extend backendPoolName = backendPools.properties.backendAddressPools.name\r\n | extend AppGwId = tostring(id)\r\n | summarize backendIPCount = sum(backendIPCount) ,backendAddressesCount=sum(backendAddressesCount) by AppGwId\r\n) on AppGwId\r\n| project-away AppGwId1\r\n| where (backendIPCount == 0 or isempty(backendIPCount)) and (backendAddressesCount==0 or isempty(backendAddressesCount))\r\n| summarize count()", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Application Gateway" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.network/applicationgateways'\r\n| extend backendPoolsCount = array_length(properties.backendAddressPools),SKUName= tostring(properties.sku.name), SKUTier= tostring(properties.sku.tier),SKUCapacity=properties.sku.capacity,backendPools=properties.backendAddressPools , AppGwId = tostring(id)\r\n| project AppGwId, name, location, SKUName, SKUTier, SKUCapacity\r\n| join (\r\n resources\r\n | where type =~ 'microsoft.network/applicationgateways'\r\n | mvexpand backendPools = properties.backendAddressPools\r\n | extend backendIPCount = array_length(backendPools.properties.backendIPConfigurations)\r\n | extend backendAddressesCount = array_length(backendPools.properties.backendAddresses)\r\n | extend backendPoolName = backendPools.properties.backendAddressPools.name\r\n | extend AppGwId = tostring(id)\r\n | summarize backendIPCount = sum(backendIPCount) ,backendAddressesCount=sum(backendAddressesCount) by AppGwId\r\n) on AppGwId\r\n| project-away AppGwId1\r\n| where (backendIPCount == 0 or isempty(backendIPCount)) and (backendAddressesCount==0 or isempty(backendAddressesCount))\r\n| summarize count(AppGwId) by tostring(location)", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Application Gateway by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.network/applicationgateways'\r\n| extend backendPoolsCount = array_length(properties.backendAddressPools),SKUName= tostring(properties.sku.name), SKUTier= tostring(properties.sku.tier),SKUCapacity=properties.sku.capacity,backendPools=properties.backendAddressPools , AppGwId = tostring(id)\r\n| project AppGwId, name, SKUName, SKUTier, SKUCapacity\r\n| join (\r\n resources\r\n | where type =~ 'microsoft.network/applicationgateways'\r\n | mvexpand backendPools = properties.backendAddressPools\r\n | extend backendIPCount = array_length(backendPools.properties.backendIPConfigurations)\r\n | extend backendAddressesCount = array_length(backendPools.properties.backendAddresses)\r\n | extend backendPoolName = backendPools.properties.backendAddressPools.name\r\n | extend AppGwId = tostring(id)\r\n | summarize backendIPCount = sum(backendIPCount) ,backendAddressesCount=sum(backendAddressesCount) by AppGwId\r\n) on AppGwId\r\n| project-away AppGwId1\r\n| where (backendIPCount == 0 or isempty(backendIPCount)) and (backendAddressesCount==0 or isempty(backendAddressesCount))\r\n| summarize count(AppGwId) by tostring(SKUTier)", "size": 4, "title": "Count by SKU", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Application Gateway by SKU" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'microsoft.network/applicationgateways'\r\n| extend backendPoolsCount = array_length(properties.backendAddressPools),SKUName= tostring(properties.sku.name), SKUTier= tostring(properties.sku.tier),SKUCapacity=properties.sku.capacity,backendPools=properties.backendAddressPools , AppGwId = tostring(id)\r\n| project AppGwId, resourceGroup, location, subscriptionId, tags, name, SKUName, SKUTier, SKUCapacity\r\n| join (\r\n resources\r\n | where type =~ 'microsoft.network/applicationgateways'\r\n | mvexpand backendPools = properties.backendAddressPools\r\n | extend backendIPCount = array_length(backendPools.properties.backendIPConfigurations)\r\n | extend backendAddressesCount = array_length(backendPools.properties.backendAddresses)\r\n | extend backendPoolName = backendPools.properties.backendAddressPools.name\r\n | extend AppGwId = tostring(id)\r\n | summarize backendIPCount = sum(backendIPCount) ,backendAddressesCount=sum(backendAddressesCount) by AppGwId\r\n) on AppGwId\r\n| project-away AppGwId1\r\n| where (backendIPCount == 0 or isempty(backendIPCount)) and (backendAddressesCount==0 or isempty(backendAddressesCount))\r\n| extend Details = pack_all()\r\n| project Resource=AppGwId, resourceGroup, location, subscriptionId, SKUTier, SKUCapacity, tags, Details", "size": 3, "title": "Orphaned Application Gateway", "noDataMessage": "No orphaned Application Gateway found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "Group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true } }, { "columnMatch": "SKUTier", "formatter": 1 }, { "columnMatch": "SKUCapacity", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "SKUTier", "label": "Sku" }, { "columnId": "SKUCapacity", "label": "Capacity" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Application Gateway" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "appgw" }, "name": "group - Networking - Application Gateway" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 11, "content": { "version": "LinkItem/1.0", "style": "tabs", "links": [ { "id": "8e1c6962-5369-4cc3-9fe9-1ff6ed0d92af", "cellValue": "VirtualNetworksTab", "linkTarget": "parameter", "linkLabel": "Virtual Networks", "subTarget": "vnets", "style": "link", "linkIsContextBlade": true }, { "id": "85598350-5dc0-4087-ae66-b50d4aeadba7", "cellValue": "VirtualNetworksTab", "linkTarget": "parameter", "linkLabel": "Subnets", "subTarget": "subnets", "style": "link" } ] }, "name": "links - Virtual Networks Tabs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Virtual Networks" }, "name": "text - Title - Virtual Networks" }, { "type": 1, "content": { "json": "[Virtual Networks](https://learn.microsoft.com/en-us/azure/virtual-network/virtual-networks-overview) (VNETs) without subnets.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/virtualnetworks\"\r\n| where properties.subnets == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Virtual Networks" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/virtualnetworks\"\r\n| where properties.subnets == \"[]\"\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Virtual Networks by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/virtualnetworks\"\r\n| where properties.subnets == \"[]\"\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tags, Details", "size": 3, "title": "Orphaned Virtual Networks", "noDataMessage": "No orphaned Virtual Networks found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Virtual Networks" } ] }, "conditionalVisibility": { "parameterName": "VirtualNetworksTab", "comparison": "isEqualTo", "value": "vnets" }, "name": "group - Networking - Virtual Networks - VNETs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Subnets" }, "name": "text - Title - Subnets" }, { "type": 1, "content": { "json": "Subnets without Connected Devices or Delegation. (Empty Subnets)", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworks\"\r\n| extend subnet = properties.subnets\r\n| mv-expand subnet\r\n| extend ipConfigurations = subnet.properties.ipConfigurations\r\n| extend delegations = subnet.properties.delegations\r\n| where isnull(ipConfigurations) and delegations == \"[]\"\r\n| summarize count(subnet)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_subnet", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortCriteriaField": "count_subnet", "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Subnets" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworks\"\r\n| extend subnet = properties.subnets\r\n| mv-expand subnet\r\n| extend ipConfigurations = subnet.properties.ipConfigurations\r\n| extend delegations = subnet.properties.delegations\r\n| where isnull(ipConfigurations) and delegations == \"[]\"\r\n| summarize count(subnet) by location", "size": 4, "title": "Count by Location", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Subnets by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworks\"\r\n| extend subnet = properties.subnets\r\n| mv-expand subnet\r\n| extend ipConfigurations = subnet.properties.ipConfigurations\r\n| extend delegations = subnet.properties.delegations\r\n| where isnull(ipConfigurations) and delegations == \"[]\"\r\n| summarize count(subnet) by resourceGroup", "size": 4, "title": "Count by Resource Group", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Subnets by Resource Group" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworks\"\r\n| extend subnet = properties.subnets\r\n| mv-expand subnet\r\n| extend ipConfigurations = subnet.properties.ipConfigurations\r\n| extend delegations = subnet.properties.delegations\r\n| where isnull(ipConfigurations) and delegations == \"[]\"\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=subnet.id, VNetName=name, SubnetName=tostring(subnet.name) ,resourceGroup, location, Details", "size": 3, "title": "Orphaned Subnets", "noDataMessage": "No orphaned Subnets found", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "networkSecurityGroup", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "VNetName", "label": "Virtual Network" }, { "columnId": "SubnetName", "label": "Subnet" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Subnets" } ] }, "conditionalVisibility": { "parameterName": "VirtualNetworksTab", "comparison": "isEqualTo", "value": "subnets" }, "name": "group - Networking - Virtual Networks - Subnets" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "vnets" }, "name": "group - Networking - Virtual Networks" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned NAT Gateways" }, "name": "text - Title - NAT Gateway" }, { "type": 1, "content": { "json": "[NAT Gateways](https://learn.microsoft.com/en-us/azure/nat-gateway/nat-overview) that not attached to any subnet.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/natgateways\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - NAT Gateways" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/natgateways\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - NAT Gateways by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/natgateways\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type) by tostring(sku.name)", "size": 4, "title": "Count by SKU", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - NAT Gateways by SKU" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/natgateways\"\r\n| where isnull(properties.subnets)\r\n| summarize count(type) by tostring(sku.tier)", "size": 4, "title": "Count by Tier", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - NAT Gateways by Tier" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/natgateways\"\r\n| where isnull(properties.subnets)\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tostring(sku.name), tostring(sku.tier), tags, Details", "size": 3, "title": "Orphaned NAT Gateways", "noDataMessage": "No orphaned NAT Gateways found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "sku_name", "formatter": 1 }, { "columnMatch": "sku_tier", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "sku_name", "label": "Sku" }, { "columnId": "sku_tier", "label": "Tier" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - NAT Gateways" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "natgw" }, "name": "group - Networking - NAT Gateway" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# IP Groups" }, "name": "text - Title - IP Group" }, { "type": 1, "content": { "json": "[IP Groups](https://learn.microsoft.com/en-us/azure/firewall/ip-groups) that not attached to any Azure Firewall.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ipgroups\"\r\n| where properties.firewalls == \"[]\" and properties.firewallPolicies == \"[]\"\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - IP Group" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ipgroups\"\r\n| where properties.firewalls == \"[]\" and properties.firewallPolicies == \"[]\"\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - IP Group by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ipgroups\"\r\n| where properties.firewalls == \"[]\" and properties.firewallPolicies == \"[]\"\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tags, Details", "size": 3, "title": "Orphaned IP Groups", "noDataMessage": "No orphaned IP Groups found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "sku_name", "formatter": 1 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - IP Group" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "ipgroup" }, "name": "group - Networking - IP Group" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Private DNS zones" }, "name": "text - Title - Private DNS zones" }, { "type": 1, "content": { "json": "[Private DNS zones](https://learn.microsoft.com/en-us/azure/dns/private-dns-privatednszone) without [Virtual Network Links](https://learn.microsoft.com/en-us/azure/dns/private-dns-virtual-network-links).", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/privatednszones\"\r\n| where properties.numberOfVirtualNetworkLinks == 0\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Private DNS zones" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/privatednszones\"\r\n| where properties.numberOfVirtualNetworkLinks == 0\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Private DNS zones by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/privatednszones\"\r\n| where properties.numberOfVirtualNetworkLinks == 0\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, NumberOfRecordSets=properties.numberOfRecordSets, tags, Details", "size": 3, "title": "Orphaned Private DNS zones", "noDataMessage": "No orphaned Private DNS zones found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "NumberOfRecordSets", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "sku_name", "formatter": 1 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "NumberOfRecordSets", "label": "Number of Records" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Private DNS zones" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "privatednszones" }, "name": "group - Networking - Private DNS Zone Group" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Private Endpoints" }, "name": "text - Title - Private Endpoints" }, { "type": 1, "content": { "json": "[Private Endpoints](https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-overview) that are not connected to any resource.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/privateendpoints\"\r\n| extend connection = iff(array_length(properties.manualPrivateLinkServiceConnections) > 0, properties.manualPrivateLinkServiceConnections[0], properties.privateLinkServiceConnections[0])\r\n| extend stateEnum = tostring(connection.properties.privateLinkServiceConnectionState.status)\r\n| where stateEnum == \"Disconnected\"\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Private Endpoints" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/privateendpoints\"\r\n| extend connection = iff(array_length(properties.manualPrivateLinkServiceConnections) > 0, properties.manualPrivateLinkServiceConnections[0], properties.privateLinkServiceConnections[0])\r\n| extend stateEnum = tostring(connection.properties.privateLinkServiceConnectionState.status)\r\n| where stateEnum == \"Disconnected\"\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Private Endpoints by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/privateendpoints\"\r\n| extend connection = iff(array_length(properties.manualPrivateLinkServiceConnections) > 0, properties.manualPrivateLinkServiceConnections[0], properties.privateLinkServiceConnections[0])\r\n| extend serviceId = tostring(connection.properties.privateLinkServiceId)\r\n| extend serviceIdSplit = split(serviceId, \"/\")\r\n| extend serviceName = tostring(serviceIdSplit[8])\r\n| extend serviceTypeEnum = iff(isnotnull(serviceIdSplit[6]), tolower(strcat(serviceIdSplit[6], \"/\", serviceIdSplit[7])), \"microsoft.network/privatelinkservices\")\r\n| extend stateEnum = tostring(connection.properties.privateLinkServiceConnectionState.status)\r\n| where stateEnum == \"Disconnected\"\r\n| summarize count(type) by serviceTypeEnum", "size": 4, "title": "Count by Resource type", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Private Endpoints by Resource type" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/privateendpoints\"\r\n| extend connection = iff(array_length(properties.manualPrivateLinkServiceConnections) > 0, properties.manualPrivateLinkServiceConnections[0], properties.privateLinkServiceConnections[0])\r\n| extend stateEnum = tostring(connection.properties.privateLinkServiceConnectionState.status)\r\n| extend groupIds = tostring(connection.properties.groupIds[0])\r\n| where stateEnum == \"Disconnected\"\r\n| summarize count(type) by groupIds", "size": 4, "title": "Count by Target sub-resource", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "25", "name": "query - Private Endpoints by Target sub-resource" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/privateendpoints\"\r\n| extend connection = iff(array_length(properties.manualPrivateLinkServiceConnections) > 0, properties.manualPrivateLinkServiceConnections[0], properties.privateLinkServiceConnections[0])\r\n| extend subnetId = properties.subnet.id\r\n| extend subnetIdSplit = split(subnetId, \"/\")\r\n| extend vnetId = strcat_array(array_slice(subnetIdSplit,0,8), \"/\")\r\n| extend serviceId = tostring(connection.properties.privateLinkServiceId)\r\n| extend serviceIdSplit = split(serviceId, \"/\")\r\n| extend serviceName = tostring(serviceIdSplit[8])\r\n| extend serviceTypeEnum = iff(isnotnull(serviceIdSplit[6]), tolower(strcat(serviceIdSplit[6], \"/\", serviceIdSplit[7])), \"microsoft.network/privatelinkservices\")\r\n| extend stateEnum = tostring(connection.properties.privateLinkServiceConnectionState.status)\r\n| extend groupIds = tostring(connection.properties.groupIds[0])\r\n| where stateEnum == \"Disconnected\"\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, serviceName, serviceTypeEnum, groupIds, vnetId, subnetId, tags, Details", "size": 3, "title": "Orphaned Private Endpoints", "noDataMessage": "No orphaned Private Endpoints found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "vnetId", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "subTarget": "Privateendpoints", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subnetId", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": false } }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "subnet", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "NumberOfRecordSets", "formatter": 1 }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "sku_name", "formatter": 1 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "serviceName", "label": "Private link resource" }, { "columnId": "serviceTypeEnum", "label": "Resource type" }, { "columnId": "groupIds", "label": "Target sub-resource" }, { "columnId": "vnetId", "label": "Virtual Network" }, { "columnId": "subnetId", "label": "Subnet" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Private Endpoints" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "privateendpoints" }, "name": "group - Networking - Private Endpoint" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Virtual Network Gateways" }, "name": "text - Title - Virtual Network Gateways" }, { "type": 1, "content": { "json": "[Virtual Network Gateways](https://learn.microsoft.com/en-us/azure/vpn-gateway/vpn-gateway-about-vpngateways) without Point-to-site configuration or Connections.", "style": "upsell" }, "name": "text - Title - Info - Virtual Network Gateways" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworkgateways\"\r\n| extend vpnClientConfiguration = properties.vpnClientConfiguration\r\n| extend Resource = id\r\n| join kind=leftouter (\r\n resources\r\n | where type =~ \"microsoft.network/connections\"\r\n | mv-expand Resource = pack_array(properties.virtualNetworkGateway1.id, properties.virtualNetworkGateway2.id) to typeof(string)\r\n | project Resource, connectionId = id, ConnectionProperties=properties\r\n ) on Resource \r\n| where isempty(vpnClientConfiguration) and isempty(connectionId)\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Virtual Network Gateways" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworkgateways\"\r\n| extend vpnClientConfiguration = properties.vpnClientConfiguration\r\n| extend Resource = id\r\n| join kind=leftouter (\r\n resources\r\n | where type =~ \"microsoft.network/connections\"\r\n | mv-expand Resource = pack_array(properties.virtualNetworkGateway1.id, properties.virtualNetworkGateway2.id) to typeof(string)\r\n | project Resource, connectionId = id, ConnectionProperties=properties\r\n ) on Resource \r\n| where isempty(vpnClientConfiguration) and isempty(connectionId)\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "20", "name": "query - Virtual Network Gateways by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworkgateways\"\r\n| extend GatewayType = tostring(properties.gatewayType)\r\n| extend vpnClientConfiguration = properties.vpnClientConfiguration\r\n| extend Resource = id\r\n| join kind=leftouter (\r\n resources\r\n | where type =~ \"microsoft.network/connections\"\r\n | mv-expand Resource = pack_array(properties.virtualNetworkGateway1.id, properties.virtualNetworkGateway2.id) to typeof(string)\r\n | project Resource, connectionId = id, ConnectionProperties=properties\r\n ) on Resource \r\n| where isempty(vpnClientConfiguration) and isempty(connectionId)\r\n| summarize count(type) by GatewayType", "size": 4, "title": "Count by Gateway Type", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "20", "name": "query - Virtual Network Gateways by Gateway Type" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworkgateways\"\r\n| extend SKU = tostring(properties.sku.name)\r\n| extend vpnClientConfiguration = properties.vpnClientConfiguration\r\n| extend Resource = id\r\n| join kind=leftouter (\r\n resources\r\n | where type =~ \"microsoft.network/connections\"\r\n | mv-expand Resource = pack_array(properties.virtualNetworkGateway1.id, properties.virtualNetworkGateway2.id) to typeof(string)\r\n | project Resource, connectionId = id, ConnectionProperties=properties\r\n ) on Resource \r\n| where isempty(vpnClientConfiguration) and isempty(connectionId)\r\n| summarize count(type) by SKU", "size": 4, "title": "Count by Sku", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "20", "name": "query - Virtual Network Gateways by Sku" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworkgateways\"\r\n| extend Tier = tostring(properties.sku.tier)\r\n| extend vpnClientConfiguration = properties.vpnClientConfiguration\r\n| extend Resource = id\r\n| join kind=leftouter (\r\n resources\r\n | where type =~ \"microsoft.network/connections\"\r\n | mv-expand Resource = pack_array(properties.virtualNetworkGateway1.id, properties.virtualNetworkGateway2.id) to typeof(string)\r\n | project Resource, connectionId = id, ConnectionProperties=properties\r\n ) on Resource \r\n| where isempty(vpnClientConfiguration) and isempty(connectionId)\r\n| summarize count(type) by Tier", "size": 4, "title": "Count by Tier", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "20", "name": "query - Virtual Network Gateways by Tier" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ \"microsoft.network/virtualnetworkgateways\"\r\n| extend Details = pack_all()\r\n| extend SKU = tostring(properties.sku.name)\r\n| extend Tier = tostring(properties.sku.tier)\r\n| extend GatewayType = tostring(properties.gatewayType)\r\n| extend vpnClientConfiguration = properties.vpnClientConfiguration\r\n| extend Resource = id\r\n| join kind=leftouter (\r\n resources\r\n | where type =~ \"microsoft.network/connections\"\r\n | mv-expand Resource = pack_array(properties.virtualNetworkGateway1.id, properties.virtualNetworkGateway2.id) to typeof(string)\r\n | project Resource, connectionId = id, ConnectionProperties=properties\r\n ) on Resource \r\n| where isempty(vpnClientConfiguration) and isempty(connectionId)\r\n| project subscriptionId, Resource, resourceGroup, location, GatewayType, SKU, Tier, tags, Details", "size": 3, "title": "Orphaned Virtual Network Gateways", "noDataMessage": "No orphaned Virtual Network Gateways found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "SKU", "formatter": 1 }, { "columnMatch": "Tier", "formatter": 1 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "vnetId", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "subTarget": "Privateendpoints", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subnetId", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": false } }, { "columnMatch": "subnet", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "NumberOfRecordSets", "formatter": 1 }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "sku_name", "formatter": 1 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "GatewayType", "label": "Gateway Type" }, { "columnId": "SKU", "label": "Sku" }, { "columnId": "Tier", "label": "Tier" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Virtual Network Gateways" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "vngs" }, "name": "group - Networking - Virtual Network Gateways" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# DDoS Protections" }, "name": "text - Title - DDoS protection plans" }, { "type": 1, "content": { "json": "[DDoS protection](https://learn.microsoft.com/en-us/azure/ddos-protection/ddos-protection-overview) without protected resources. (=without Virtual Networks accosiated)", "style": "upsell" }, "name": "text - Title - Info - DDoS protection plans" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ddosprotectionplans\"\r\n| where isnull(properties.virtualNetworks)\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto", "compositeBarSettings": { "labelText": "", "columnSettings": [] } } }, "showBorder": true, "sortOrderField": 1, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - DDoS protection plans" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ddosprotectionplans\"\r\n| where isnull(properties.virtualNetworks)\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Name" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "20", "name": "query - DDoS protection plans by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == \"microsoft.network/ddosprotectionplans\"\r\n| where isnull(properties.virtualNetworks)\r\n| extend Details = pack_all()\r\n| project subscriptionId, Resource=id, resourceGroup, location, tags, Details", "size": 3, "title": "Orphaned DDoS protection plans", "noDataMessage": "No orphaned DDoS protection plans found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "SKU", "formatter": 1 }, { "columnMatch": "Tier", "formatter": 1 }, { "columnMatch": "vnetId", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "subTarget": "Privateendpoints", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subnetId", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": false } }, { "columnMatch": "subnet", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "NumberOfRecordSets", "formatter": 1 }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "sku_name", "formatter": 1 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - DDoS protection plans" } ] }, "conditionalVisibility": { "parameterName": "networkingTab", "comparison": "isEqualTo", "value": "DDoSplans" }, "name": "group - Networking - DDoS protection plans" } ] }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "networking" }, "name": "group - Networking" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 11, "content": { "version": "LinkItem/1.0", "style": "tabs", "links": [ { "id": "75dbecf0-d939-484a-a9b6-7ac357384d56", "cellValue": "othersTab", "linkTarget": "parameter", "linkLabel": "Resource Groups", "subTarget": "rgs", "style": "link" }, { "id": "f1783382-6614-4f1a-9be3-ea8be37e9bb8", "cellValue": "othersTab", "linkTarget": "parameter", "linkLabel": "API Connections", "subTarget": "apiconnections", "style": "link" }, { "id": "4397efb4-240b-4f96-b734-c946c59e941d", "cellValue": "othersTab", "linkTarget": "parameter", "linkLabel": "Certificates", "subTarget": "certificates", "style": "link" } ] }, "name": "links - Other Tabs" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Resource Groups" }, "name": "text - Title - Resource Groups" }, { "type": 1, "content": { "json": "[Resource Groups](https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/overview) without resources (including hidden types resources).", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "ResourceContainers\r\n | where type == \"microsoft.resources/subscriptions/resourcegroups\"\r\n | extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n | join kind=leftouter (\r\n Resources\r\n | extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n | summarize count() by rgAndSub\r\n ) on rgAndSub\r\n | where isnull(count_)\r\n | summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Resource Groups Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "ResourceContainers\r\n | where type == \"microsoft.resources/subscriptions/resourcegroups\"\r\n | extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n | join kind=leftouter (\r\n Resources\r\n | extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n | summarize count() by rgAndSub\r\n ) on rgAndSub\r\n | where isnull(count_)\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Resource Groups by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "ResourceContainers\r\n | where type == \"microsoft.resources/subscriptions/resourcegroups\"\r\n | extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n | join kind=leftouter (\r\n Resources\r\n | extend rgAndSub = strcat(resourceGroup, \"--\", subscriptionId)\r\n | summarize count() by rgAndSub\r\n ) on rgAndSub\r\n | where isnull(count_)\r\n | extend Details = pack_all()\r\n | project subscriptionId, Resource=id, location, tags ,Details", "size": 3, "title": "Orphaned Resource Groups", "noDataMessage": "No orphaned Resource Groups found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "Resource", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Resource Groups" } ] }, "conditionalVisibility": { "parameterName": "othersTab", "comparison": "isEqualTo", "value": "rgs" }, "name": "group - Others - Resource Groups" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned API Connections" }, "name": "text - Title - API Connections" }, { "type": 1, "content": { "json": "[API Connections](https://learn.microsoft.com/en-us/azure/active-directory/external-identities/api-connectors-overview/) that not related to any Logic App.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'Microsoft.Web/connections'\r\n| project resourceId = id , apiName = name, subscriptionId, resourceGroup, tags, location\r\n| join kind = leftouter (\r\n resources\r\n | where type == 'microsoft.logic/workflows'\r\n | extend resourceGroup, location, subscriptionId, properties\r\n | extend var_json = properties[\"parameters\"][\"$connections\"][\"value\"]\r\n\t| mvexpand var_connection = var_json\r\n | where notnull(var_connection)\r\n | extend connectionId = extract(\"connectionId\\\":\\\"(.*?)\\\"\", 1, tostring(var_connection))\r\n | project connectionId, name\r\n )\r\n on $left.resourceId == $right.connectionId\r\n| where connectionId == \"\"\r\n| summarize count()", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - API Connections Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'Microsoft.Web/connections'\r\n| project resourceId = id , apiName = name, subscriptionId, resourceGroup, tags, location\r\n| join kind = leftouter (\r\n resources\r\n | where type == 'microsoft.logic/workflows'\r\n | extend resourceGroup, location, subscriptionId, properties\r\n | extend var_json = properties[\"parameters\"][\"$connections\"][\"value\"]\r\n\t| mvexpand var_connection = var_json\r\n | where notnull(var_connection)\r\n | extend connectionId = extract(\"connectionId\\\":\\\"(.*?)\\\"\", 1, tostring(var_connection))\r\n | project connectionId, name\r\n )\r\n on $left.resourceId == $right.connectionId\r\n| where connectionId == \"\"\r\n| summarize count() by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - API Connections by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type =~ 'Microsoft.Web/connections'\r\n| project resourceId = id , apiName = name, subscriptionId, resourceGroup, tags, location\r\n| join kind = leftouter (\r\n resources\r\n | where type == 'microsoft.logic/workflows'\r\n | extend resourceGroup, location, subscriptionId, properties\r\n | extend var_json = properties[\"parameters\"][\"$connections\"][\"value\"]\r\n\t| mvexpand var_connection = var_json\r\n | where notnull(var_connection)\r\n | extend connectionId = extract(\"connectionId\\\":\\\"(.*?)\\\"\", 1, tostring(var_connection))\r\n | project connectionId, name\r\n )\r\n on $left.resourceId == $right.connectionId\r\n| where connectionId == \"\"\r\n| extend Details = pack_all()\r\n| project resourceId, resourceGroup, location, subscriptionId, tags, Details", "size": 3, "title": "Orphaned API Connections", "noDataMessage": "No orphaned API Connections found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "resourceId", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "resourceId" }, "labelSettings": [ { "columnId": "resourceId", "label": "Resource" }, { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "tags", "label": "Tags" }, { "columnId": "Details", "label": "Details" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - API Connections" } ] }, "conditionalVisibility": { "parameterName": "othersTab", "comparison": "isEqualTo", "value": "apiconnections" }, "name": "group - Others - API Connections" }, { "type": 12, "content": { "version": "NotebookGroup/1.0", "groupType": "editable", "items": [ { "type": 1, "content": { "json": "# Orphaned Certificates" }, "name": "text - Title - Certificates" }, { "type": 1, "content": { "json": "Expired certificates.", "style": "upsell" }, "name": "text - Title - Info" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == 'microsoft.web/certificates'\r\n| extend expiresOn = todatetime(properties.expirationDate)\r\n| where expiresOn <= now()\r\n| summarize count(type)", "size": 4, "title": "Total", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "tiles", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "count_type", "formatter": 12, "formatOptions": { "palette": "auto" } }, "showBorder": true, "sortCriteriaField": "count_type", "sortOrderField": 2, "size": "auto" }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "textSettings": { "style": "bignumber" } }, "customWidth": "15", "name": "query - Certificates Count" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == 'microsoft.web/certificates'\r\n| extend expiresOn = todatetime(properties.expirationDate)\r\n| where expiresOn <= now()\r\n| summarize count(type) by location", "size": 4, "title": "Count by Location", "noDataMessage": "No results.", "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "visualization": "piechart", "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "showIcon": true } }, { "columnMatch": "id", "formatter": 5 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } } ], "rowLimit": 1000, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "id" } }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "DiskType", "formatter": 1 }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto" }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } }, "chartSettings": { "showMetrics": false, "showLegend": true }, "mapSettings": { "locInfo": "LatLong", "sizeSettings": "Count", "sizeAggregation": "Sum", "legendMetric": "Count", "legendAggregation": "Sum", "itemColorSettings": { "type": "heatmap", "colorAggregation": "Sum", "nodeColorField": "Count", "heatmapPalette": "greenRed" } } }, "customWidth": "30", "name": "query - Certificates by Location" }, { "type": 3, "content": { "version": "KqlItem/1.0", "query": "resources\r\n| where type == 'microsoft.web/certificates'\r\n| extend expiresOn = todatetime(properties.expirationDate)\r\n| where expiresOn <= now()\r\n| extend Details = pack_all()\r\n| project Resource=id, resourceGroup, location, subscriptionId, tags, Details", "size": 3, "title": "Orphaned Certificates", "noDataMessage": "No orphaned Certificates found.", "showExportToExcel": true, "queryType": 1, "resourceType": "microsoft.resourcegraph/resources", "crossComponentResources": [ "{Subscription}" ], "gridSettings": { "formatters": [ { "columnMatch": "$gen_group", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } }, { "columnMatch": "Resource", "formatter": 5 }, { "columnMatch": "location", "formatter": 17 }, { "columnMatch": "subscriptionId", "formatter": 5 }, { "columnMatch": "Details", "formatter": 7, "formatOptions": { "linkTarget": "CellDetails", "linkLabel": "🔍 View Details", "linkIsContextBlade": true } }, { "columnMatch": "resourceId", "formatter": 5 }, { "columnMatch": "Subscription", "formatter": 13, "formatOptions": { "linkTarget": "Resource", "linkIsContextBlade": true, "showIcon": true } } ], "rowLimit": 1000, "filter": true, "hierarchySettings": { "treeType": 1, "groupBy": [ "subscriptionId" ], "expandTopLevel": true, "finalBy": "Resource" }, "labelSettings": [ { "columnId": "resourceGroup", "label": "Resource Group" }, { "columnId": "location", "label": "Location" }, { "columnId": "subscriptionId", "label": "Subscription" }, { "columnId": "tags", "label": "Tags" } ] }, "sortBy": [], "tileSettings": { "titleContent": { "columnMatch": "vmSize", "formatter": 1, "formatOptions": { "showIcon": true } }, "leftContent": { "columnMatch": "Count", "formatter": 12, "formatOptions": { "palette": "auto", "showIcon": true }, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } }, "showBorder": true }, "graphSettings": { "type": 0, "topContent": { "columnMatch": "vmSize", "formatter": 1 }, "centerContent": { "columnMatch": "Count", "formatter": 1, "numberFormat": { "unit": 17, "options": { "maximumSignificantDigits": 3, "maximumFractionDigits": 2 } } } } }, "name": "query - Certificates" } ] }, "conditionalVisibility": { "parameterName": "othersTab", "comparison": "isEqualTo", "value": "certificates" }, "name": "group - Others - Certificates" } ] }, "conditionalVisibility": { "parameterName": "mainTab", "comparison": "isEqualTo", "value": "others" }, "name": "group - Others" } ], "fallbackResourceIds": [ "Azure Monitor" ], "$schema": "https://github.com/Microsoft/Application-Insights-Workbooks/blob/master/schema/workbook.json" }