2 of 2 people found this helpful
Assuming that you are on the newer NCM where the NCM db is married to the NPM db. I would approach this in the manner below.
Note: I manipulate my devices via custom properties, the query below is written for you to accomplish your work in the same way. Since we have different custom properties ensure to replace (Custom Property) with your desired property.
Step 1. Run the following Query (This is to confirm that these are your troubled nodes)
SELECT NodeCaption,AgentIP,LoginStatus,(Custom Property)
WHERE LoginStatus NOT LIKE 'Login OK'
Step 2. Once you have confirmed that the query above gives you the nodes you're looking to work with run the query below.
UPDATE NCM_Nodes SET (Custom Property) = 'FAILED DEVICES' WHERE LoginStatus NOT LIKE 'Login OK'
Step 3. Navigate to the Configuration Manager on your Solarwinds website
Step 4. Select the 'Group By' drop down menu and select your (Custom Property)
Step 5. Select ALL then select 'Edit Properties' and make the changes you need to all of your nodes.
Step 6. Once your changes are made and you're ready to clear your custom property run the following query
UPDATE NCM_Nodes SET (Custom Property) = NULL WHERE (CustomProperties) LIKE 'FAILED DEVICES'
This is the way I've found to be more efficient, specially when working with a large amount of nodes.