Network Management

Disable/ enable nodes and agents using SQL

If you have hundreds or thousands of nodes or agents that need to be disabled/ enabled all at once, this article will be helpful.

First published date

3/10/2021 6:07 PM

Last published date

6/10/2022 1:53 AM

Overview

SQL can be used for performing bulk tasks that would otherwise be impractical or less convenient in the Orion web console. The manage nodes page can only manage up to 250 nodes at a time, the manage agents can manage up to 1,000 agents at a time. 

Using SQL, these limitations are removed. 

Product section

Orion Platform

Cause


 

Resolution

Please keep in mind these queries will change ALL agents/ nodes management status.
 
To manage

This will manage all the agents again:
Update AgentManagement_AgentPlugins
set status = 1 ;

This will manage all the Nodes again:
UPDATE dbo.NodesData
SET Unmanaged = 0 ;

To unmanage

This will unmanage all the agents again:
Update AgentManagement_AgentPlugins
set status = 0 ;

This will unmanage all the Nodes again:
UPDATE dbo.NodesData
SET Unmanaged = 1 ;

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.