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.