Share via

Queries for the ACRConnectedClientList table

  • Article

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

Unique Redis client IP addresses

Unique Redis client IP addresses that have connected to the cache.

ACRConnectedClientList
| summarize count() by ClientIp

Redis client connections per hour

Redis client connections per hour within the specified IP address range.

let IpRange = "10.1.1.0/24";
ACRConnectedClientList
// For particular datetime filtering, add '| where TimeGenerated between (StartTime .. EndTime)'
| where ipv4_is_in_range(ClientIp, IpRange)
| summarize ConnectionCount = sum(ClientCount) by TimeRange = bin(TimeGenerated, 1h)