Queries for the AGCAccessLogs table

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

Client requests per hour

Count of client requests hourly.

AGCAccessLogs
| summarize AggregatedValue = count() by bin(TimeGenerated, 1h), _ResourceId
| render timechart

5xx HTTP responses per hour

Count of client requests that resulted in 5xx responses hourly.

AGCAccessLogs
| where HttpStatusCode > 499 and HttpStatusCode < 600
| summarize AggregatedValue = count() by bin(TimeGenerated, 1h), _ResourceId
| render timechart

4xx HTTP responses per hour

Count of client requests that resulted in 4xx responses hourly.

AGCAccessLogs
| where HttpStatusCode > 399 and HttpStatusCode < 500
| summarize AggregatedValue = count() by bin(TimeGenerated, 1h), _ResourceId
| render timechart