Queries for the ChaosStudioExperimentEventLogs table
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Failed experiment runs
List failed experiment runs.
ChaosStudioExperimentEventLogs
| where Status == 'Failed' and SpanType == 'Experiment'
| sort by TimeGenerated desc
Experiment events on last experiment run
List experiment events on the last experiment run.
ChaosStudioExperimentEventLogs
| lookup kind=inner (
ChaosStudioExperimentEventLogs
| top 1 by TimeGenerated desc
| project CorrelationId
) on CorrelationId
| order by TimeGenerated asc