Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > List nodes on Manage Windows Credentials

List nodes on Manage Windows Credentials

Table of contents
Created by Herwin Orenday, last modified by Melanie Boyd on Jun 12, 2018

Views: 5,165 Votes: 2 Revisions: 7

Overview

This article provides information about checking the nodes assigned to a Windows credential and showing all nodes that currently use WMI as the polling method. 

Environment

NPM, all versions

Steps

1. Run the Database Manager. Click All Programs > Solarwinds Orion > Advanced Features > Database Manager.

2. Select the SolarWinds Orion database. Click Database Manager > Add default server > SolarWindsOrion.

3. List credential names. 

a. Right-click SolarWindsOrion > Select New query.

b. Paste this query and execute the following:

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

c. Locate the credential name and make a note of the ID.

 

4. List all the nodes.

a. Run a new query.

b. Paste the following query and execute it:

Select * from [dbo].[Nodes]
join [dbo].[NodeSettings]
On Nodes.NodeId=NodeSettings.NodeId
where ObjectSubType = 'WMI'

This lists all nodes that currently use WMI as its polling method.

 

You can use the following query to identify node names (not just NodeID) based on the Credential name:

 

SELECT N.NodeID, Caption, C.Name, SettingName, SettingValue, NodeSettingID
FROM NodeSettings S
Join Nodes N on N.NodeID = S.NodeID 
Join Credential C on Cast(C.ID as nvarchar(50)) = S.SettingValue
Where C.Name like '%solar%

 

 

Last modified

Tags

Classifications

Public