Queries for the AddonAzureBackupJobs table

  • Article
  • 11/01/2024

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

Distribution of Backup Jobs by Status

View the number of completed and failed Backup Jobs in the selected time range.

AddonAzureBackupJobs
//Get all Backup Jobs
| where JobOperation  == "Backup"
//Remove duplicate records if any
| summarize arg_max(TimeGenerated, *) by JobUniqueId
//Summarize by Job Status
| summarize count(JobUniqueId) by JobStatus

Distribution of Restore Jobs by Status

View the number of completed and failed Restore Jobs in the selected time range.

AddonAzureBackupJobs
//Get all Restore Jobs
| where JobOperation  in~ ("Restore","Recovery") 
//Remove duplicate records if any
| summarize arg_max(TimeGenerated, *) by JobUniqueId
//Summarize by Job Status
| summarize count(JobUniqueId) by JobStatus

All Successful Jobs

View all successful jobs in the selected time range.

AddonAzureBackupJobs
| summarize arg_max(TimeGenerated,*) by JobUniqueId
| where JobStatus == "Completed"

All Failed Jobs

View all failed jobs in the selected time range.

// To create an alert for this query, click '+ New alert rule'
AddonAzureBackupJobs
| summarize arg_max(TimeGenerated,*) by JobUniqueId
| where JobStatus == "Failed"