Display S2S Connection Name instead of remoteIP

[Menaka955]

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!

[#2]

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.