Queries for the AGCAccessLogs table

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