Submit a ticketCall us
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 Milton Harris on Apr 02, 2018

Views: 3,638 Votes: 2 Revisions: 5

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 ObjectSubType = 'WMI'

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

 

 

Last modified

Tags

Classifications

Public