AACHttpRequest 表的查询

限制的请求数

对应用配置服务的限制请求Lists。

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

最常见的服务器错误

Lists最常见的错误状态代码和相应的计数。

// 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

最活跃的客户端(按 IP 地址)

Lists与应用配置服务通信的最常见 IP 地址。

// 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