Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Locate the node to which the user ID is assigned

Locate the node to which the user ID is assigned

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,043 Votes: 0 Revisions: 11

By viewing the tables in the SolarWinds Database, the user ID associated with the nodes can be found. To locate the node:

  1. Open either SQL Management Studio or the SolarWinds Database Manger and execute the following Query:
     
  2. SELECT TOP 1000 * FROM [dbo].[Credential]

    This query lists all credentials within the environment by the name. The Credential Name matches with the name in the Manage Windows Credential page on the Web Console. Locate the ID Number for the appropriate credential.
  3. Open a new query and run the following. REPLACE the Hash Tags #### with the ID number found from the Credential list.





  4.  
  5.  
  6.  
SELECT TOP 1000 Nodesettings.NodeID,Nodes.IP_Address,Nodes.DNS FROM [dbo].[NodeSettings] INNER JOIN Nodes on NodeSettings.NodeID=Nodes.NodeIDWHERE SettingName LIKE '%WMI%' AND SettingValue='####'

 This query provides the Node Names and IP Addresses for the devices assigned to the Credential.

Before doing any work on your database please make sure that you have a current backup, as this will make a permanent change to your database. 

Last modified

Tags

Classifications

Public