Skip to content

Instantly share code, notes, and snippets.

@levi-turner

levi-turner/azure_waf_search.sql

Last active April 24, 2020 02:47
Show Gist options
  • Save levi-turner/b42a78cea720b9f7cb9bd3176778dd5d to your computer and use it in GitHub Desktop.
Save levi-turner/b42a78cea720b9f7cb9bd3176778dd5d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
azure_waf_search.sql
// Search for a given listener
search *
| where listenerName_s == 'YourCoolListener' and serverStatus_s != '200' | top 500 by TimeGenerated
AzureDiagnostics
| where ResourceProvider == "MICROSOFT.NETWORK" and Category == "ApplicationGatewayFirewallLog"
| where action_s <> "Allowed"
| where hostname_s == "host.company.com:Port"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment