Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > Find what WMI Credential is assigned to a certain node

Find what WMI Credential is assigned to a certain node

Table of contents

Updated December 9, 2017

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. 

Environment

  • NPM 10.7+
  • SAM 6.0+

Steps

  1. Log in to the SolarWinds Server.
  2. Open Report Writer.
  3. Click New.
  4. Select Advanced SQL.
  5. Click OK.
  6. In the second tab, paste the following query to pull back all Windows Credentials Information From nodes:


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'


 

The Report will now display all WMI Nodes and the Assigned Credential.

 

 

 

Disclaimer:
Please note, any custom scripts or other content posted herein are provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software that you have purchased from SolarWinds, and the information set forth herein may come from third party customers. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. Any custom scripts obtained herein are provided to you “AS IS” without indemnification, support, or warranty of any kind, express or implied. You elect to utilize the custom scripts at your own risk, and you will be solely responsible for the incorporation of the same, if any.

 

 

Last modified
02:24, 9 Jan 2017

Tags

Classifications

Public