Applications Systems
Disable hardware health monitoring manually
When a target device stops providing hardware health information (for example, after moving from a physical to a virtual environment), there is no option in SAM to disable polling hardware health for this node.
First published date
Last published date
Overview
Product section
Resolution
Although you cannot disable hardware monitoring for a node in the Orion Web Console, you can do it directly in the database by setting the IsDisabled column to 1 in the APM_HardwareInfo table.
You must have Node Management rights to perform this workaround.
To disable hardware monitoring for a node, use the following SQL script:
-- 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 APM_HardwareInfo SET IsDisabled = 1 WHERE NodeID = InsertNodeIdHere
After you execute the script, the polling job for the node is removed within 30 seconds. When the Orion Web Console refreshes (by default, every five minutes), hardware-related resources and statistics disappear from the Node Details page.
To delete hardware-related health data from the Orion database for a specific note, use the following SQL script:
-- 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.
DECLARE @NodeID int
SET @NodeID = _InsertNodeIdHere_
DELETE FROM APM_HardwareInfo WHERE NodeID = @NodeID
DELETE FROM APM_HardwareCategoryStatus WHERE NodeID = @NodeID
DELETE FROM APM_HardwareItem WHERE NodeID = @NodeID
To delete orphaned historical data for sensors, run this command:
-- 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.
EXEC apm_dbm_APM_HardwareItemStatistics_DeleteOrphans
For reference, see: