This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Check WMI nodes where service monitoring account is associated

Below SQL query we can in solarwinds DB to get the list of node

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'

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'