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

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

That SWQL is much more elegant and beyond my skills to create but at least I can follow it - but happy to have pushed you in the right direction

That's why I love the IT community! :)