Forum Discussion

naren1970's avatar
naren1970
Copper Contributor
Jul 02, 2020

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

Resources