Network Management

Track SNMPv3 credentials that are assigned to a node in NPM

This article describes how to track SNMPv3 credentials that are assigned to a node.

First published date

10/17/2018 8:02 AM

Last published date

9/4/2025 8:16 PM

Overview

If there's a need to track certain SNMPv3 credentials that needs to be updated on the system, the article will aid on how to track SNMPv3 credentials that are assigned to a node through the database

Product section

Network Performance Monitor

Resolution

 

  1. Establish a remote connection to the SolarWinds server.
  2. Go to the Start Menu and search for Database Manager.
  3. Click Add Orion Server and expand your SolarWinds SQL Server.
  4. Click the drop down and expand your Orion database.
  5. On the expanded list of tables, locate the table named Credential.
  6. Right-click and select Query Table > Execute Query. The lists of credentials used on the SolarWinds application are displayed.
  7. Take note of the ID number for the credentials that you are looking for.
  8. Paste the following query: (Replace the hashtags (####) with the ID number found from the credential table list) 
    -- Scripts are not supported under any SolarWinds support program or service. 
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
-- disclaims all warranties including, without limitation, any implied warranties 
-- of merchantability or of fitness for a particular purpose. The risk arising 
-- out of the use or performance of the scripts and documentation stays with you. 
-- In no event shall SolarWinds or anyone else involved in the creation, 
-- production, or delivery of the scripts be liable for any damages whatsoever 
-- (including, without limitation, damages for loss of business profits, business 
-- interruption, loss of business information, or other pecuniary loss) arising 
-- out of the use of or inability to use the scripts or documentation.

SELECT NodeSettings.NodeID,Nodes.IP_Address,Nodes.DNS 
FROM [dbo].[NodeSettings] 
INNER JOIN Nodes on NodeSettings.NodeID=Nodes.NodeID
WHERE SettingName LIKE '%SNMP%' AND SettingValue = '####'
  9. After determining the node IP or name, go back to the SolarWinds Platform Web Console, click on Manage Nodes
  10. Search the node, click on the check box, and then click on Edit Properties
  11. Replace the credentials set on the polling method.