SNMP V3 Credentials Profile

Question

i am in the "Manage SNMP Credentials" in settings. I have credential name that has 4 devices assigned. i can not look through all of my devices looking for this profile. How does one see what devices are actually using the profile

thanks

nalvi · Answer

Defualt report only display community string. it does not show which nodes  or ip used by snmpv3 profile.

mestasew · Answer

Thanks, that was helpful query.

The 1st query script can be modified to include node name by adding Caption.Nodes, instead of finding the node name from its ID.

mjalden1 · Answer

You can create a report because the ones listed only do community string

you can follow the steps below to find ID number of the string being used and run the command listed below.

Use this to find ID# of the SNMP string

* Establish a remote connection to the SolarWinds server.
* Go to Start and search for Database Manager.
* Right-click your database and click New Query.
* Click Add default server and expand your SolarWinds database.
* Right-click your database and click New Query.
* On the expanded list of tables for your database, locate Credentials

once found lets say the SNMP string for Solarwinds USA is ID #7

use this script in database manager to find which nodes are using it

SELECT TOP 1000 Nodesettings.NodeID,Nodes.IP_Address,Nodes.DNS FROM [dbo].[NodeSettings] INNER JOIN Nodes on NodeSettings.NodeID=Nodes.NodeID

WHERE SettingName LIKE '%SNMP%' AND SettingValue='7'

This wil then spit out NodeID and IP_address

Lets say the NodeID is 1009

You can look up the NodeID from the this command

SELECT TOP 1000 * FROM [dbo].[NodesData]

Where NodeID = '1009'

This will now show the name of the node and more