Queries for the StorageCacheOperationEvents table

Failed operation

Retrieves a list of operation that returned a failed response code.

StorageCacheOperationEvents
| where ResponseCode < 200 or ResponseCode >= 300
| sort by TimeGenerated desc
| take 100

Failed priming job

Retrieves a list of failed priming jobs.

StorageCacheOperationEvents
| where OperationName contains "Priming"
| where ResultType == "Failed"
| project  TimeGenerated, OperationName, PrimingJobName, ResultDescription, _ResourceId, CorrelationId, Location
| sort by TimeGenerated desc
| take 100

Completed long-running asynchronous operations

Retrieves a list of long-running operations that have completed.

StorageCacheOperationEvents
| where ResponseCode == 201 or ResponseCode == 202
| where ResultType == "Succeeded" 
| sort by TimeGenerated desc
| take 100