AddonAzureBackupJobs 表的查询

有关在 Azure 门户中使用这些查询的信息,请参阅 Log Analytics 教程。 有关 REST API,请参阅查询

按状态分发备份作业

查看所选时间范围内完成和失败的备份作业数。

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

按状态分发还原作业

查看所选时间范围内完成和失败的还原作业数。

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

所有成功作业数

查看所选时间范围内的所有成功作业。

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

所有失败的作业

查看所选时间范围内的所有失败的作业。

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