Network Management

Find what WMI Credential is assigned to a certain node in NPM and SAM

There are instances where the Service Account you are using undergoes a password change and you need to find out which node's need to be updated in order to maintain Monitoring of these nodes.

First published date

11/29/2018 10:37 PM

Last published date

9/22/2022 5:35 AM

Overview

There are instances where the Service Account you are using undergoes a password change and you need to find out which node(s) need to be updated in order to maintain Monitoring of these nodes. From Manage Windows Credential Page in the Orion Web Console [Settings > Manage Windows Credentials] it is possible to see the number of nodes but not the names of the nodes which are assigned to it.

Product section

Orion Platform

Cause

Resolution

Open up Database Manager on the main Orion server

Add Default Server
Right-click on Orion Database
Click New query

Enter and then execute the following query to view all WMI Nodes and their Assigned Credential:

-- 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 Nodes.IP_Address, Nodes.Caption, Credential.Name
FROM Credential
INNER JOIN NodeSettings ON Credential.ID=NodeSettings.SettingValue
INNER JOIN Nodes ON NodeSettings.NodeID=Nodes.NodeID
WHERE NodeSettings.SettingName='WMICredential'

Enter and then execute the following query to search for all WMI Nodes using a specific Credential: (replace #### with 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 Nodes.IP_Address, Nodes.Caption, Credential.Name 
FROM Credential 
INNER JOIN NodeSettings ON Credential.ID=NodeSettings.SettingValue 
INNER JOIN Nodes ON NodeSettings.NodeID=Nodes.NodeID 
WHERE NodeSettings.SettingName='WMICredential' and Credential.Name = '####'

Disclaimer: Please note any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.