application gateway KQL queries to check access logs

Venu Gopal Krishna VV 80 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.
781 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Thomas Meads 651 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