SOLVED

Failed to resolve table or column expression named 'AddonAzureBackupJobs'

%3CLINGO-SUB%20id%3D%22lingo-sub-1502862%22%20slang%3D%22en-US%22%3EFailed%20to%20resolve%20table%20or%20column%20expression%20named%20'AddonAzureBackupJobs'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1502862%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20am%20new%20to%20Kusto%20Query%20Language.%20Please%20bear%20with%20me%20if%20my%20question%20is%20too%20basic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20i%20execute%20the%20below%20query%20to%20get%20details%20of%20all%20successful%20backup%20jobs%2C%20i%20get%20an%20error%3A%26nbsp%3B%26nbsp%3B%3CSPAN%3E'where'%20operator%3A%20Failed%20to%20resolve%20table%20or%20column%20expression%20named%20'AddonAzureBackupJobs'%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAddonAzureBackupJobs%3CBR%20%2F%3E%7C%20where%20JobOperation%3D%3D%22Backup%22%3CBR%20%2F%3E%7C%20summarize%20arg_max(TimeGenerated%2C*)%20by%20JobUniqueId%3CBR%20%2F%3E%7C%20where%20JobStatus%3D%3D%22Completed%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fbackup%2Fbackup-azure-monitoring-use-azuremonitor%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EQuery%20Source%3A%20https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fbackup%2Fbackup-azure-monitoring-use-azuremonitor%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20i%20populate%20the%20table%26nbsp%3BAddonAzureBackupJobs%20before%20running%20the%20above%20query.%20If%20i%20understand%20correct%2C%26nbsp%3B%3CSPAN%3E'AddonAzureBackupJobs'%20is%20not%20a%20default%20table%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1502862%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFailed%20to%20resolve%20table%20or%20column%20expression%20named%20'AddonAzureBackupJobs'%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 Replies
Best Response confirmed by naren1970 (New Contributor)
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