I am trying to add a Custom Query resource to the node details summary page that runs a SWQL query on the current node showing CDP information from the NCM database. I get "Error: A query to the SolarWinds Information Service failed." when it runs. It works in SWQL Studio when I select v2. This is the query -
SELECT Nodes.NodeCaption AS NodeName, CiscoCDP.ifIndex, Interfaces.InterfaceName, CiscoCDP.RemoteDevice, CiscoCDP.RemoteIPAddress, CiscoCDP.RemotePort, CiscoCDP.LastDiscovery
FROM
NCM.Nodes
INNER JOIN NCM.CiscoCDP ON (Nodes.NodeID = CiscoCDP.NodeID) INNER JOIN NCM.Interfaces ON (CiscoCDP.NodeID = Interfaces.NodeID)
WHERE
CiscoCDP.ifIndex = Interfaces.InterfaceIndex
AND
Nodes.NodeCaption like ${NodeName}
ORDER by CiscoCDP.ifIndex ASC
How do I get this to work in the Custom Query resource?
Thanks.
