Jun 09 2020
12:30 AM
- last edited on
Apr 08 2022
10:28 AM
by
TechCommunityAP
Jun 09 2020
12:30 AM
- last edited on
Apr 08 2022
10:28 AM
by
TechCommunityAP
I am trying to setting up monitoring for vpn status and getting below error.
Jun 09 2020 09:54 AM
It looks like that COLUMN doesn't exist - hence the error. You can use EXTEND and Column_ifexists to create a default value maybe? In this case, I use "1.1.1.1" as the default - amend to suit
AzureDiagnostics
//| where Category == "TunnelDiagnosticLog"
//| where _ResourceId == tolower("/subscriptions/xxxxx/resourceGroups/devresgrp/providers/Microsoft.Network/virtualNetworkGateways/xxx")
//| where TimeGenerated > ago(5d)
| limit 5
| extend remoteIP_s = iif(column_ifexists("remoteIP_s","") == true,"","1.1.1.1")
| project remoteIP_s
Feb 11 2021 07:36 PM