• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 38 subscribers
  • Views 362 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Hardware Health Enable/Disable Query

WJMuhle

Simple query to mass disable or enable hardware health based upon a sensor name:

Disable:

UPDATE [dbo].[APM_HardwareItem]

SET IsDisabled ='1'

WHERE DisplayName LIKE '%Sensor Name%'

Enable:

UPDATE [dbo].[APM_HardwareItem]

SET IsDisabled ='0'

WHERE DisplayName LIKE '%Sensor Name%'

  • 0

    I am trying to disable DOM sensors and I am close but can't quite seem to get there. Using 2020.2 it seems the table moved.

    With this query I get some results

    SELECT ID, FullyQualifiedName FROM Orion.HardwareHealth.HardwareItem

    20954DOM Voltage Sensor for Ethernet32 on RED-P166-16A-01
    20955DOM TX Bias Sensor for Ethernet32 on RED-P166-16A-01
    20956DOM TX Power Sensor for Ethernet32 on RED-P166-16A-01
    20957DOM RX Power Sensor for Ethernet32 on RED-P166-16A-01
    20958DOM Voltage Sensor for Ethernet33 on RED-P166-16A-01
    20959DOM TX Bias Sensor for Ethernet33 on RED-P166-16A-01
    20960DOM TX Power Sensor for Ethernet33 on RED-P166-16A-01

    but then when I add this to the query I get no results

    WHERE Name LIKE 'DOM'

    It does not matter if I use Name, DisplayName or FullyQualifiedName

    Can you offer any suggestions?

    Thanks,

    Kevin

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.