Hide this message
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.
By viewing the tables in the SolarWinds Database, the user ID associated with the nodes can be found. To locate the node:
SELECT TOP 1000 Nodesettings.NodeID,Nodes.IP_Address,Nodes.DNS FROM [dbo].[NodeSettings] INNER JOIN Nodes on NodeSettings.NodeID=Nodes.NodeIDWHERE SettingName LIKE '%WMI%' AND SettingValue='####'
This query provides the Node Names and IP Addresses for the devices assigned to the Credential.
Before doing any work on your database please make sure that you have a current backup, as this will make a permanent change to your database.