0

I am currently trying to write queries using Azure Resource graph explorer. I would like to display the compliance and non compliance of resources by management groups. On the tenant, the architecture is similar to the one below.

Hierarchy Azure tenant

I currently use this query to obtain compliance and non-compliance of resources regarding a specific initiative:

Query to display compliant and non-compliant resources

Now I would like to display the results for a given management group (level after the tenant, please see the previous figure). Therefore I thought of doing a join with the highlighted table but it seems there are no columns on which I can join.

Do you have any idea, how I could do this? Thank you in advance!

LiliCloud
  • 1
  • 1
  • do you have a more concrete specific example of what you're trying to do? in ARG there's some strange behaviors of management groups (ARG queries only show you MG's that you have "management" access to, but there's an ARM endpoint that returns the MG's that you can "see", etc. so there's some odd things here. What exact queries are you using in graph explorer/workbooks, what results do you get, what do you want to get, etc. – John Gardner Aug 09 '23 at 18:33
  • First, thank you for your answer John! More details are now available above – LiliCloud Aug 10 '23 at 07:22
  • please provide the query in a text format It would be more helpful rather that a picture link. – Suresh Chikkam Aug 17 '23 at 06:12

0 Answers0