Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

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: 3,200 Votes: 2 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

Tags

Classifications

Public