Queries for the StorageCacheWarningEvents table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Active warning events
Retrieves a list of warning events that have not cleared.
StorageCacheWarningEvents
| where State == "Active"
| project TimeGenerated, CorrelationId, Description, _ResourceId, State
| join kind=leftanti (StorageCacheWarningEvents
| where State == "Cleared"
| project TimeGenerated, CorrelationId, Description, _ResourceId, State)
on CorrelationId
| project TimeGenerated, CorrelationId, Description, _ResourceId, State
| take 100