Azure Resource Graph Explorer - Expanding Properties Indexer Values

Occasional Contributor

Hi,

 

Is there a recommended way to expand an indexer [array] within the Properties values into a customer column. 

 

For example:

Resources
        | where type == "microsoft.network/networkinterfaces"
        | extend vmId=tostring(properties.virtualMachine.id), nicId=tostring(id), ipAddress=properties.ipConfiguration[0].properties.privateIPAddress
        | project name, nicId, vmId, privateIp=properties.ipConfigurations[0].properties.privateIPAddress
 
It's desirable to expand properties.ipConfigurations[0], properties.ipConfigurations[1] ... properties.ipConfigurations[n] expressed within a column, instead of hardcoding per column in the output?
 
 
Thanks
Joe
 
0 Replies