Queries for the NatGatewayFlowlogsV1 table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Total allowed packets and bytes sent per NatGateway IP and Destination IP

Total packets and bytes sent per NatGateway IP and Destination IP, that was allowed by the NAT Gateway.

NatGatewayFlowlogsV1
| where TimeGenerated > ago(1d)
| summarize PacketsSentTotal = sum(PacketsSent), BytesSentTotal = sum(BytesSent) by DestinationIP, NatGatewayIP

Total allowed packets and bytes sent per NatGateway IP and Source IP

Total packets and bytes sent per NatGateway IP and Source IP, that was allowed by the NAT Gateway.

NatGatewayFlowlogsV1
| where TimeGenerated > ago(1d)
| summarize PacketsSentTotal = sum(PacketsSent), BytesSentTotal = sum(BytesSent) by SourceIP, NatGatewayIP