can any one help on this?'where' operator: Failed to resolve column or scalar expression named 'Status_s' If the issue persists, please open a support ticket. Request id: 9e729838-5083-424a-ac4a-69a9b1123931

Question

Answer 1

Hi @Manda Tejasree

For your original ask, the Status_c column doesn't exists in the AzureDiagnotics table. The error message is a general message that you're attempting to query for a column that doesn't exists in the source table. I'm assuming you used this query from the predefined S2S tunnel query.

This TunnelDiagnosticLog troubleshooting page does have a different sample query that you can try:

AzureDiagnostics
| where Category == "TunnelDiagnosticLog"
| project TimeGenerated, OperationName, instance_s, Resource, ResourceGroup
| sort by TimeGenerated asc

For myself, I ran into the same issue with instance_s and to resolve, just remove the offending column.

Answer 2

It look like the Status_s column is missing, maybe make a fake entry using extend to test this? Also see https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/columnifexists

AzureDiagnostics
| extend Status_s=="Connected"