Agw queries
Jump to navigation
Jump to search
Sum all client_ips
AzureDiagnostics | where ResourceType == "APPLICATIONGATEWAYS" and OperationName == "ApplicationGatewayAccess" and host_s == "<app service or bff domain>" and ruleName_s == "my_rule" and clientIP_s !in ('10.1.1.1') and requestUri_s == "/foo/bar" | summarize ClientIPSummary = make_list(clientIP_s) | extend ClientIPCount = array_length(ClientIPSummary)