Forum Discussion
sochan1900
Apr 10, 2019Copper Contributor
Kusto Query all backup jobs and list the friendly name
I use below query which will query the failed and completed jobs and list there BackupItemFriendlyName_s, JobStatus_s and some other fields. However it doesnt display BackupItemFriendlyName_s for a...
GouravIN
Apr 14, 2019Brass Contributor
Could you please check with this one
let Events = AzureDiagnostics | where Category == "AzureBackupReport"; Events | where OperationName == "Job" | project BackupItemUniqueId_s , JobStatus_s, Resource | join kind=inner (Events | where OperationName == "BackupItem" | distinct BackupItemUniqueId_s, BackupItemFriendlyName_s | project BackupItemUniqueId_s, BackupItemFriendlyName_s ) on BackupItemUniqueId_s | project BackupItemFriendlyName_s , JobStatus_s