Queries for the ChaosStudioExperimentEventLogs table

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