Azure Resource Graph is an extremely powerful extension to Azure Resource Management that provides efficient resource exploration at scale. It supports both Azure Lighthouse as well as cross subscrip...
Updated May 14, 2021
Version 1.0
Blog Post
What a great blog, this has been the most helpful post I've read over Azure Resource Graph. You are right, tons of info but I'm always challenged on getting the data I need.
Appreciate your insight and looking forward to reviewing your Github.
I was able to create this query using your help.
*Note - I have added extra Project fields just to help review the columns:
resources
| where type =~ "microsoft.storage/storageaccounts"
| extend networkaccess = properties.networkAcls.virtualNetworkRules
| mv-expand rules = properties.networkAcls.resourceAccessRules
| extend rules1 = rules.resourceId
| extend rules2 = split(rules1,'/')
| extend resourceId = rules2[-3]
| where networkaccess != "[]" and rules != ""
| project name, networkaccess, rules, rules1, rules2, resourceId
| limit 10