SOLVED

Analytics Query on Application Gateway Logs

Copper Contributor

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 Replies
best response confirmed by Stanislav Zhelyazkov (MVP)
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

Thank you!

1 best response

Accepted Solutions
best response confirmed by Stanislav Zhelyazkov (MVP)
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

View solution in original post