Share via


ChaosStudioExperimentEventLogs 數據表的查詢

失敗的實驗執行

列出失敗的實驗執行。

ChaosStudioExperimentEventLogs
| where Status == 'Failed' and SpanType == 'Experiment'
| sort by TimeGenerated desc

上一次實驗執行的實驗事件

列出上一次實驗執行的實驗事件。

ChaosStudioExperimentEventLogs
| lookup kind=inner (
    ChaosStudioExperimentEventLogs
    | top 1 by TimeGenerated desc
    | project CorrelationId
) on CorrelationId
| order by TimeGenerated asc