Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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

Tags

Classifications

Public