Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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: 751 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