Analytics Query on Application Gateway Logs

[Stefanie Cortese]

I have all my Application Gateway logs going to a Log Analytics work space. I want to query this data to show any URIs with a specific key word. Can someone point me in the right direction of how to query this? 

[#2 · Accepted solution]

You have a few logs of types that are logged in Log Analytics by Application Gateways. Let's assume you are talking about access logs.

Example query for that would be

AzureDiagnostics 
| where Category == "ApplicationGatewayAccessLog" 
| where requestUri_s contains "myadmin" 

you can replace 'myadmin" with something else. Here is the documentation on contains and the other string operators:

https://docs.loganalytics.io/docs/Learn/Tutorials/String-operations

[#3]

Thank you!