Forum Discussion
Menaka955
Aug 30, 2021Copper Contributor
Display S2S Connection Name instead of remoteIP
Hello All,
We are using the below query for the Disconnected status, we also required the connection name of the
remoteIP_s. Is there any table with the connection name to join with the query.
AzureDiagnostics
| where TimeGenerated > ago(24h)
| where Category == "TunnelDiagnosticLog" and (status_s == "Disconnected")
| project TimeGenerated, Resource , status_s, remoteIP_s, stateChangeReason_s
Thank you!
- Anders Bengtsson
Microsoft
Hi,
Please see https://docs.microsoft.com/en-us/azure/vpn-gateway/troubleshoot-vpn-with-azure-diagnostics for information about the different tables with VPN events.
If you can not find what you are looking for there, workbooks might be a solution for you. With workbooks you can query multiple data sources and visualize the result together. You could then query your VPN devices to find a name based on the IP adress.