Queries for the ADFActivityRun table

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

Activity Runs Availability

Gives the availability of the Activity Runs.

// To create an alert for this query, click '+ New alert rule'
ADFActivityRun
| 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

Activity runs latest Status

Returns latest Status of Activity runs.

ADFActivityRun
| summarize argmax(TimeGenerated, * ) by ActivityRunId, Status, _ResourceId