Azure Resource Graph Explorer :: list all resourceGroup with subscriptionName

Question

I've created a kusto query that will allow me to have an overview of all resourceGroups:

resourcecontainers
where type == 'microsoft.resources/subscriptions/resourcegroups'
project subscriptionId, resourceGroup,  tags.mytag1, tags.mytag2, tags.mytag3

Is there a way I can project the subscriptionName instead of the subscriptionId?

the goal is to make it more human readable.

score 2 · Accepted Answer · edited May 17 '23 at 09:08

2

Sure, that is possible by joining on the resourcecontainers of type microsoft.resources/subscriptions:

resourcecontainers
| where type == 'microsoft.resources/subscriptions' 
| project subscriptionId, subscriptionName = name 
| join (resourcecontainers 
    | where type == 'microsoft.resources/subscriptions/resourcegroups') 
    on subscriptionId 
| project subscriptionName, resourceGroup, tags.mytag1, tags.mytag2, tags.mytag3

edited May 17 '23 at 09:08

Francesco Mantovani

10,216
13
73
113

answered May 16 '23 at 18:18

Peter Bons

26,826
4
50
74

Ah, you teach me something today @Peter. Thanks a million. – Francesco Mantovani May 16 '23 at 21:35
Hi @Peter, I checked the code today but your query just returns me 14 results which is the number of subscriptions and it returns me 1 resourceGroups per subscription. But with my previous query I was able to retrieve >500 resourceGroups which is the actual number of resourceGroups we have – Francesco Mantovani May 17 '23 at 09:04
I updated your code. Now it works – Francesco Mantovani May 17 '23 at 09:09

Azure Resource Graph Explorer :: list all resourceGroup with subscriptionName

1 Answers1