application gateway KQL queries to check access logs

Venu Gopal Krishna VV 100 Reputation points
2023-08-29T14:13:22.0966667+00:00

Hi All,

i need help to check appgateway access logs for particular host like "www.abc.com" through KQL queries. can someone please help me with query.

appreciate for help.

Azure Application Gateway
Azure Application Gateway
An Azure service that provides a platform-managed, scalable, and highly available application delivery controller as a service.
1,063 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Thomas Meads 1,586 Reputation points
    2023-08-29T17:47:52.08+00:00

    First please make sure that you have the diagnostic settings setup correctly following this guide: https://learn.microsoft.com/en-us/azure/application-gateway/application-gateway-diagnostics#enable-logging-through-the-azure-portal.

    The KQL query for this would be:

    AzureDiagnostics
    | where requestUri contains "www.abc.com"
    

    App gateway access log schema: https://learn.microsoft.com/en-us/azure/application-gateway/application-gateway-diagnostics?source=recommendations#access-log

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.