List nodes on Manage Windows Credentials in the SolarWinds Platform

10/19/2018 9:25 PM

6/25/2025 5:23 PM

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. 

Network Performance Monitor

Note: Attempting to run the queries below in a report in the SolarWinds Platform Web Console may fail in 2023.2 and newer due to a security change. Please see Custom SQL reports fail after the upgrade to 2023.2 (Error executing SQL: database 'SolarWindsOrion') for additional information.

1. Connect to the SolarWinds Main Polling Engine.
2. Run the Database Manager. Click All Programs > Solarwinds Platform > Database Manager.
3. Select the SolarWinds Platform database. Click Database Manager > Add Orion server > SolarWindsOrion.
4. List credential names. 
   1. Right-click SolarWindsOrion > Select New query.
   2. Paste this query and execute the following:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT TOP 1000 * FROM [dbo].[Credential]

5. Locate the credential name and make a note of the ID.

 

6. List all the nodes.
   1. Run a new query.
   2. Paste the following query and execute it:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT * FROM [dbo].[Nodes]
JOIN [dbo].[NodeSettings]
ON Nodes.NodeId=NodeSettings.NodeId
WHERE ObjectSubType = 'WMI'

This lists all nodes that currently use WMI as their polling method.

 

You can use the following query to identify node names (not just NodeID) based on the Credential name:

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

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 '%<CredentialNameHere>%'