SELECT v.NodeID, n.NodeCaption, v.SourceIPAddress, v.TargetIPAddress, v.StatusDescription
FROM NCM.Nodes n
INNER JOIN Orion.VPN.L2LTunnel v on n.NodeID = v.NodeID
I'm trying to run the simple query above to gather details on site to site vpn tunnels. I keep getting the error below:
"Cannot implicitely convert from data type Guid to data type Int32"