Queries for the ADFPipelineRun table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

PipelineRuns Availability

Gives the availability of the Pipeline Runs.

// To create an alert for this query, click '+ New alert rule'
ADFPipelineRun
| where Status != 'InProgress' and Status != 'Queued'
| where FailureType != 'UserError'
| summarize availability = 100.00 - (100.00*countif(Status != 'Succeeded') / count())  by bin(TimeGenerated, 1h)), _ResourceId
| order by TimeGenerated asc
| render timechart

Pipeline runs latest Status

Returns latest Status of pipeline runs.

ADFPipelineRun
| summarize argmax(TimeGenerated, * ) by RunId, Status, _ResourceId