Forum Discussion

Lucas Chies's avatar
Lucas Chies
Copper Contributor
Jul 20, 2020
Solved

Query for Azure Backup

Hello All,   I'm using the below script to get the backup information, but in this script I can't found were or how can I get the error message, error code and the recommendations message. Can any...
Azure Log Analytics
azure monitor
  • Lewis-H's avatar
    Lewis-H
    Jul 24, 2020
    AddonAzureBackupJobs
    | where JobOperation=="Backup"
    | summarize arg_max(TimeGenerated,*) by JobUniqueId
    | where JobStatus=="Completed"
    | join kind=inner
    (
    CoreAzureBackup
    | where OperationName == "BackupItem"
    | where BackupItemType=="VM" and BackupManagementType=="IaaSVM"
    | distinct BackupItemUniqueId, BackupItemFriendlyName
    )
    on BackupItemUniqueId

    I hope this code helps you out.
Lewis-H's avatar
Lewis-H
Iron Contributor
Jul 24, 2020
AddonAzureBackupJobs
| where JobOperation=="Backup"
| summarize arg_max(TimeGenerated,*) by JobUniqueId
| where JobStatus=="Completed"
| join kind=inner
(
CoreAzureBackup
| where OperationName == "BackupItem"
| where BackupItemType=="VM" and BackupManagementType=="IaaSVM"
| distinct BackupItemUniqueId, BackupItemFriendlyName
)
on BackupItemUniqueId

I hope this code helps you out.

Resources