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