Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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

List nodes on Manage Windows Credentials

Table of contents
Created by Herwin Orenday, last modified by MindTouch on Jun 23, 2016

Views: 101 Votes: 1 Revisions: 4

Overview

This article provides brief information on checking the nodes assigned to a Windows credential and showing all nodes that currently use WMI as it is polling methods. 

Environment

All NPM version

Steps

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

2. Select Solarwinds 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 take 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 NodeSettings.SettingValue = '5'

This will List all Nodes that currently use WMI as its polling method

 

 

Last modified
22:37, 22 Jun 2016

Tags

Classifications

Public