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.
GBADARO's avatar
GBADARO
Copper Contributor
Jul 27, 2020

Lewis-H 

Tried the same, but neither Error Message nor Recommended action are returned by this query. 

  • GBADARO's avatar
    GBADARO
    Copper Contributor
    Jul 29, 2020
    Hi Everyone,
    just to make sure, this thread should be re-opened until a working solution is achieved, right?
    • CliveWatson's avatar
      CliveWatson
      Former Employee
      Jul 30, 2020

      GBADARO 

       

      That's correct, question is still open until you are happy or our collective knowledge is exhausted.  I see this data with the query I provided.  You can see it working in the demo data set here:

      https://ms.portal.azure.com#@72f988bf-86f1-41af-91ab-2d7cd011db47/blade/Microsoft_Azure_Monitoring_Logs/DemoLogsBlade/resourceId/%2FDemo/source/LogsBlade.AnalyticsShareLinkToQuery/q/H4sIAAAAAAAAA72RTU4DMQyF95V6B5NVK80N0CxKC1IRAmla1qM0Y4bAJA6JU1rE4Uk6%252FRMqW7K0X56%252FZ3fIcLtGywFKmHxFjzMtW0uBtQowHHzD5yt6hKlkbMlvoSxB7HQ3Ur1HV6Ejz%252BJ6ODjY5D%252B4YbQN3NPqyaGXrMku4mq5dVjnOYq6aKx%252BwY0OHEbiok4UIMT4DOEoeZQGe44O02wgDxeayVSk37B%252F8hdPBkmqPoU4tBcsOYZ9707qDhvxt8cp05W2MBIP1IpCVKhojWlVjrTlOhfHOUWTwmqrOFs8W%252F0Rcd7UbQE9wpzRHKuhOIcpoMJA0SvclTNW2v%252BUGjwJPc%252FShZbaYK9XZEw6ATYT1afNBM7TGyaA%252F5n4A%252B5BT3VbAgAA/timespan/P7D

       

      As to why you don't have it, perhaps its the back up type or other issue.  I'm not familiar with backup, so perhaps others will comment? 

Resources