Forum Discussion

Stefanie Cortese's avatar
Stefanie Cortese
Copper Contributor
Sep 06, 2018
Solved

Analytics Query on Application Gateway Logs

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? 

  • 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

2 Replies

Resources