Difference between revisions of "Agw queries"
Jump to navigation
Jump to search
(Created page with "# Sum all client_ips ``` AzureDiagnostics | where ResourceType == "APPLICATIONGATEWAYS" and OperationName == "ApplicationGatewayAccess" and host_s == "<app service or bff doma...") |
(No difference)
|
Latest revision as of 20:27, 1 April 2024
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)