Network Management

Track Windows credentials that are assigned to a node

This article describes how to track Windows credentials that are assigned to a node.

First published date

10/30/2018 6:02 PM

Last published date

7/3/2025 9:43 PM

Overview

This article contains a step-by-step procedure on how to identify the Entities (nodes) to where Windows credentials are assigned to.

Product section

Orion Platform

Resolution

  1. Remote access to your SolarWinds server.
  2. Go to Start > Search > Database Manager.
  3. Highlight your database > right click and click New Query.
  4. Click Add default server > click the plus button to expand your SolarWinds database.
  5. Highlight your database again > right click and click New Query.
  6. On the expanded list of tables of your database, look for Credential > click Query Table > then click Execute Query.
    You will see the list of credentials set on the Solarwinds application. Look for the login you are looking for and take note of the credential name.
  7. Go back to the top and paste this query on the QUERY 1 tab. 
    -- 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>%'
  8. Replace <CredentialNameHere> with the name of the credential found from the Credential list.
  9. It will bring the list of nodes that these credentials are set to.
  10. Once the Node IP or Node name is determined, go back to your SolarWinds Web Console > search that node > click Edit Node > and replace now the credentials set on the Polling Method.