Disable ADM en masse across nodes in SAM

9/18/2019 5:33 PM

8/15/2023 4:19 PM

The normal way to update nodes en masse is to group them by polling method on the manage nodes page and edit a bunch of nodes all with the same polling method.

In this way you can update polling frequencies and custom properties, but in testing 2019.2 and earlier products when checking and when un-checking the ADM box on the edit nodes pages -> ADM settings are not changed.

This article describes a work-around for this issue and tells you how to disable ADM both globally and en masse across sets of nodes using a custom SQL query.

The SolarWinds Platform database table that shows if ADM is enabled or disabled across nodes is table: ADM_NodeSettings.

-- 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.

Server Application Monitor

To see ADM node settings and find out if ADM is enabled or disabled:

1. Remote to your main polling engine or database server.
2. If you are on the main polling engine, open database manager. If you are on the database server, connect to the SolarWinds Platform database using SQL management studio.
3. Find the table ADM_NodeSettings and look at the table by running this query:

SELECT TOP 1000 * FROM [dbo].[ADM_NodeSettings]

To turn off ADM only on a specific node, use this query:

update adm_nodesettings
set enabled = 'false'
where nodeid = 'X'

Where X is the node ID that you'd like to update.

The table that shows the node IDs tying it to the node name and server hostname is NodesData.

To turn off ADM on ALL nodes:

1. Run this query:

update adm_nodesettings
set enabled = 'false'

Note: This query will turn off ADM for all nodes.