Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

List nodes with their assigned SNMPv3 credentials

Hello all,

if you want to list all your nodes with their assigned SNMPv3 credentials please run the below SQL query to the Orion database

SELECT DISTINCT Credential.Name, NodesData.NodeID, nodesdata.caption, nodesdata.IP_address, credential.id
FROM nodesdata
INNER JOIN nodesettings on nodesdata.nodeid=nodesettings.nodeid
INNER JOIN credential on credential.ID=nodesettings.settingvalue
WHERE SettingName like '%snmp%' and settingvalue in (select ID from credential where credentialtype = 'SolarWinds.Orion.Core.Models.Credentials.SnmpCredentialsV3')

Please let me know if this help.

Find more posts tagged with

Accepted answers

All comments

visom0023

I'm getting Msg 245 Conversion failed when converting the nvarchar value 'False' to data type int.

visom0023

I corrected it by putting the 'NodesData.NodeID' and 'Credential.ID" in single quotes on the first line.

visom0023

Thanks!

Callsygn

I also get the following message - Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the nvarchar value 'http://'; to data type int.

Callsygn

Nevermind, I figured it out with the help of visom0023's comment.