How to query using SWQL for Cisco nexus nodes that have not had CLI credentials configured for vPC monitoring?
Did you mean this setting:
If so, then I can do you a query that shows the devices that ARE configured:
SELECT s.NodeID, n.Caption, n.Description, s.SettingName, s.SettingValue, s.NodeSettingID FROM Orion.NodeSettings AS s JOIN Orion.Nodes AS n ON s.NodeID = n.NodeID WHERE n.Description LIKE '%Nexus%' AND SettingName = 'CLI.Credential'
That got me going. This seems to work for my needs:
SELECT n.NodeID, n.Caption, n.Description,n.NodeDescription,n.IOSVersion,n.IOSImage,n.Sysname FROM Orion.Nodes AS n LEFT OUTER JOIN (SELECT s.NodeID, s.SettingName, s.SettingValue, s.NodeSettingID FROM Orion.NodeSettings as s where s.SettingName = 'CLI.Credential') as ss on n.NodeID = ss.NodeID Where ss.SettingName IS Null and n.vendor like 'Cisco%' and (n.IOSImage = 'nxos' or n.NodeDescription like '%nexus%' or n.NodeDescription like '%nxos%' or n.NodeDescription like '%nx-os%' or n.Description like '%nexus%' or n.Description like '%nxos%' or n.Description like '%nx-os%' or n.IOSVersion like '%nx-os%') ORDER BY n.sysname
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.