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