Network Management
Disable Topology, Routing, Multicast, HardwareHealth polling jobs
This shows How to Disable Topology, Routing, Multicast, HardwareHealth and Polling Jobs.
First published date
Last published date
Overview
Product section
Resolution
***IMPORTANT***
BEFORE PERFORMING ANY OF THE STEPS FROM THIS ARTICLE PLEASE MAKE SURE THE DATABASE BACKUP HAS BEEN PERFORMED.
How to disable Topology and routing polling using the Device Studio
- Open the SolarWinds Platform Web Console.
- Navigate to Settings > All Settings > Manage Pollers.
- Locate the poller you wish to disable (Multicast Routing, Routing, Topology: Layer 2, Topology: Layer 3) and check the checkbox next to it.
- Click ASSIGN.
- Select the nodes you do not wish to be polled by this poller.
- Click DISABLE POLLER.
How to disable Topology Polling using SQL queries
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the Pollers Table and select Query table.
- Execute the following query to display all the Objects assigned with topology pollers:
-- 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. SELECT * FROM Pollers WHERE PollerType LIKE 'N.Topology%'
- To disable these pollers execute the following query:
-- 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. -- Update rows in table 'Pollers' UPDATE Pollers SET [Enabled] = 0 WHERE PollerType LIKE 'N.Topology%' AND [Enabled] <> 0
How to disable all Routing Polling using SQL queries
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the Pollers Table and select Query table.
- Execute the following query to display all the Objects assigned with routing pollers:
-- 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. SELECT * FROM Pollers WHERE PollerType LIKE '%Routing%'
- To disable these pollers execute the following query:
-- 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. -- Update rows in table 'Pollers' UPDATE Pollers SET [Enabled] = 0 WHERE PollerType LIKE '%Routing%' AND [Enabled] <> 0
How to disable Routing Polling using SQL queries
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the Pollers Table and select Query table.
- Execute the following query to display all the Objects assigned with routing pollers:
-- 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. SELECT * FROM Pollers WHERE PollerType LIKE 'N.Routing%'
- To disable these pollers execute the following query:
-- 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. -- Update rows in table 'Pollers' UPDATE Pollers SET [Enabled] = 0 WHERE PollerType LIKE 'N.Routing%' AND [Enabled] <> 0
How to disable Multicast Polling using SQL queries
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the Pollers Table and select Query table.
- Execute the following query to display all the Objects assigned with multicast routing pollers:
-- 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. SELECT * FROM Pollers WHERE PollerType LIKE 'N.MulticastRouting%'
- To disable these pollers execute the following query:
-- 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. -- Update rows in table 'Pollers' UPDATE Pollers SET [Enabled] = 0 WHERE PollerType LIKE 'N.MulticastRouting%' AND [Enabled] <> 0
To edit Routing\Multicast polling frequency instead of deleting these polling jobs
Instead, push out polling interval from minutes to hours instead of removing the polling job. Simply run the following in Database Manager and carefully edit CurrentValue using the "Enable Table Editing" option:
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the Settings Table and select Query table.
- Execute the following query to display settings for routing and multicast routing:
-- 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. SELECT * FROM Settings where SettingID LIKE '%NPM_Settings%interval%'
- Click Enable Table Editing and set the values for the CurrentValue Column
Disabling Multicast Polling
Summary of resources on NPM Multicast issues:
Disabling all Hardware Health Polling using SQL queries
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the APM_HardwareInfo Table and select Query table.
- Execute the following query to display all Hardware Health Polling:
-- 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. SELECT * FROM APM_HardwareInfo WHERE [IsDisabled] = 0
- To disable these pollers execute the following query:
-- 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. -- Update rows in table 'APM_HardwareInfo' Update APM_HardwareInfo SET [IsDisabled] = 1 WHERE [IsDisabled] <> 1
Alternative approach:
Editing Polling Frequencies
Routing and Multicast Polling Intervals and retention can be edited via Database Manager only.
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the Settings Table and select Query table.
- Execute the following query to display settings for routing and multicast polling frequency:
-- 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. SELECT * FROM Settings WHERE SettingID LIKE '%Rout%'
- Click Enable Table Editing and set the values for the CurrentValue Column
Editing Topology Frequencies
This can be mass edited by using the SolarWinds Platform Web Console Polling Settings Page. The default is 30 Minutes, which can be changed to 300 or 600 Minutes.
- Open the SolarWinds Platform Web Console and log in with an admin account.
- Navigate to Settings > All Settings > Polling Settings.
- Edit the value for DEFAULT NODE TOPOLOGY POLL INTERVAL.
- Click Submit.
Or by using Database Manager:
- Open the Database Manager (Default location: C:\Program Files (x86)\SolarWinds\Orion\DatabaseManager.exe).
- Select Add Orion Server, and expand the SQL server and SolarWinds Platform database in bold.
- Right-click the Settings Table and select Query table.
- Execute the following query to display settings for routing and multicast polling frequency:
-- 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. SELECT * FROM NodeSettings WHERE SettingName LIKE '%Core.Topology%'
- Click Enable Table Editing and set the values for the SettingName Column.