Queries for the AMSKeyDeliveryRequests table

Key delivery successful request count by key type

Summarizes the count of successful key delivery requests by different key types.

AMSKeyDeliveryRequests
| where ResultType == "Succeeded"
| summarize Count = count() by KeyType

Key delivery failed requests

Lists the details of failed key delivery requests.

AMSKeyDeliveryRequests
| where ResultType != "Succeeded"
| project KeyId, PolicyName, ResultSignature, StatusMessage, _ResourceId
| limit 100

Key delivery requests latency at 95 and 99 percentiles

Estimates the key delivery requests latency at 95th and 99th percentiles.

AMSKeyDeliveryRequests
| summarize percentiles(DurationMs, 95, 99)