I'm trying to get the outbound bytes for each destination public IP. I have this query:
AzureNetworkAnalytics_CL
| where SubType_s == 'FlowLog'
and FlowDirection_s == 'O'
and FlowStatus_s == 'A'
and FlowType_s == "ExternalPublic"
| project
VM_s,
TimeProcessed_t,
DestinationIP = split(split(DestPublicIPs_s, ' ')[0], '|')[0],
OutboundBytes = toint(split(split(DestPublicIPs_s, ' ')[0], '|')[5])
Is there a way to get the hostname or domain name of the IP address?
Thanks in advance!