Queries for the AddonAzureBackupJobs table
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"
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for