Failed to resolve table or column expression named 'AddonAzureBackupJobs'

[naren1970]

Hi All,

I am new to Kusto Query Language. Please bear with me if my question is too basic.

When i execute the below query to get details of all successful backup jobs, i get an error:  'where' operator: Failed to resolve table or column expression named 'AddonAzureBackupJobs'

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

Query Source: https://docs.microsoft.com/en-us/azure/backup/backup-azure-monitoring-use-azuremonitor

How can i populate the table AddonAzureBackupJobs before running the above query. If i understand correct, 'AddonAzureBackupJobs' is not a default table

[#2 · Accepted solution]

Hello @naren1970 

Please take a look at: https://docs.microsoft.com/en-us/azure/backup/backup-azure-diagnostic-events and enable this Table in the Diagnostic settings 

[#3]

@CliveWatson  Thank you!