weeyin83 · June 28, 2025 12:18
diff --git a/tag-kqlsummary.kql b/tag-kqlsummary.kql
 resources
 | where type =~ 'microsoft.hybridcompute/machines' or type =~ 'Microsoft.Compute/virtualMachines'
 | extend TagsObject = parse_json(tags)  // Parse the JSON string into a dynamic object
 | project name, City = tostring(TagsObject.City), Environment = tostring(TagsObject.Environment)  // Extract the City tag as a string
 | summarize CityCount = count() by City // Group by City and count occurrences
	resources
	\| where type =~ 'microsoft.hybridcompute/machines' or type =~ 'Microsoft.Compute/virtualMachines'
	\| extend TagsObject = parse_json(tags) // Parse the JSON string into a dynamic object
	\| project name, City = tostring(TagsObject.City), Environment = tostring(TagsObject.Environment) // Extract the City tag as a string
	\| summarize CityCount = count() by City // Group by City and count occurrences