Queries for the LAJobLogs table

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

Failed jobs

List failed jobs with details.

LAJobLogs
| where Status == 'Failed'
| project EndTime=TimeGenerated, JobId, CorrelationId, SourceTable, Destination
| sort by EndTime desc

Jobs in progress

List jobs in progress with details.

LAJobLogs
| summarize count(), StartTime=min(TimeGenerated) by JobId, CorrelationId, SourceTable, tostring(Destination)
| where count_ == 1
| project StartTime, JobId, CorrelationId, SourceTable, Destination=parse_json(Destination)
| sort by StartTime desc