Forum Discussion
naren1970
Jul 02, 2020Copper Contributor
Failed to resolve table or column expression named 'AddonAzureBackupJobs'
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
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
- CliveWatson
Microsoft
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
- naren1970Copper Contributor
CliveWatson Thank you!