I have a Widget/Resource in the front page of every Node's Summary view that displays the node's CDP neighbors.
It's worked pretty well over time, and is built from Thwack's great team member contributions. Re: Want to see your cisco CDP?
The Query I'm using follows:
SELECT I.InterfaceName AS [Local Interface], CDP.IPAddress AS [IP Address], DeviceId AS Device, DevicePort AS [Remote Interface], (SELECT N2.DetailsURL from Orion.Nodes N2 JOIN Orion.NodeIPAddresses NIP ON (N2.NodeID = NIP.NodeID) WHERE NIP.IPAddress = CDP.IPAddress) AS [_LinkFor_Device]
FROM Orion.NodeCdpEntry CDP
JOIN Orion.Nodes N ON (N.NodeID = CDP.NodeID)
LEFT OUTER JOIN Orion.NPM.Interfaces I ON ((CDP.NodeID = I.NodeID) AND (CDP.IfIndex = I.Index))
WHERE (CDP.NodeID = ${NodeID}) AND (N.IPAddress <> CDP.IPAddress)
I discovered an old 3750-X Distribution Pair that shows unusual IP Address output for its CDP Neighbors:
I expect IP addresses in that column. What can be done to properly discover and display them there?
This works properly when NPM shows a Layer-3 node that is a Cisco 4510, or a 3850--but NOT if if the node is a 6807. It only occasionally works when the node displayed is a Nexus 7K.
It doesn't seem to matter what the CDP neighbors may be; only the node for which NPM is trying to display CDP neighbor information.
