Is there a way to filter all the network Layer 2 & 3 devices that use Telnet Connections? Even get a report generated on that..
Well, I should have checked first. I was going to change one of my devices to say it uses telnet when I noticed that telnet is not an option anymore for me at least. Probably because our servers are in FIPS mode that prevents the other protocols. But, this info should be in the NCM.NodeProperties table. If it says something like "GlobalExecProtocol" in a column, that means its using the globally configured protocol under Device Specific Settings / NCM Settings / Global Device Defaults. If those protocols are configured as Telnet, then devices with the global protocol mentioned in that table would be using telnet. If the globals are SSH, then you'd see exceptions for the devices that are using telnet. So you're query would probably have to follow this logic. You can have a different protocol for different actions, one for "Execute Commands and Scripts" (ie: Exec), one for "Config Request" and another for "Transfer Configs". So to make sure you're not using telnet, you have to check all 3 columns…
If your protocols are all set to "SSH" of some sort and not telnet, this query should give you a list of devices not using the global protocol.
SELECT NP.Nodes.Caption
FROM NCM.NodeProperties NP
WHERE NOT ((NP.ExecProtocol = '${GlobalExecProtocol}') OR (NP.CommandProtocol = '${GlobalConfigRequestProtocol}') OR (NP.TransferProtocol = '${GlobalConfigTransferProtocol}'))
HTH!
That are using telnet connections for NCM to connect to them? Or are you just looking for devices that might have telnet enabled on them? If the latter, what kind of devices?
We are trying to move everything to ssh, maybe if there would be a quicker way to identify all devices that still use telnet instead of logging in to all devices to check. I'm not really familiar with filtering or generating reports on SolarWinds
Thank you !!🍻
