Submit a ticketCall us

WebinarUpcoming Webinar: How Help Desk and Remote Support Pays for Itself

Learn how help desk software can simplify ticketing management, allow you to track hardware and software assets, and accelerate the speed of IT support and service delivery. Gain insights on how remote support tools allow your IT team to maximize their efficiency and ticket resolution by expediting desktop troubleshooting, ultimately helping keep end-users happy and productive.

Register here.

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 Melanie Boyd on Jun 12, 2018

Views: 4,003 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