Queries for the AACHttpRequest table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

Throttled Requests

Lists of throttled requests to the App Config Service.

// This query helps retrieve logs for throttled requests during past one hour.
AACHttpRequest
| where StatusCode == 429 and TimeGenerated > ago(1h)
| sort by TimeGenerated desc

Most common server errors

Lists the most common error Status Code and a corresponding count.

// This query helps retrieve logs for failed requests during past one hour by status code. 
AACHttpRequest
| where StatusCode >= 500 and TimeGenerated > ago(1h)
| summarize ErrorCount=count() by StatusCode
| project StatusCode, ErrorCount
| sort by ErrorCount desc

Most Active Clients by IP Address

Lists the most common IP Addresses to communicate with the App Config Service.

// This query helps count requests by top 10 most active client IP addresses.  
AACHttpRequest
| summarize Count=count() by ClientIPAddress
| project ClientIPAddress, Count
| sort by Count desc
| limit 10