Hardware Monitoring needs to be removed from the DB

If I would have to remove Hardware Monitoring from the nodes through SQL on NPM DB , which all tables should I look for ?

APM_HardwareCategoryStatus

APM_HardwareItem

APM_HardwareInfo

Find more posts tagged with

npm

Accepted answers

All comments

vinay.by

How can I remove hardware monitoring from the db ?

cobrien1

I don't know off the top of my head but I'll check with our wonderful QA guys Monday and let you know Vinay.

JiriPsota

What exactly you would like to do? Disable Hardware Health Monitoring?

Run the query:

UPDATE APM_HardwareInfo SET IsDisabled=1

vinay.by

thanks JiriPsota , I would want to remove Hardware Health Monitoring for few selected nodes in my environment. I will have to do them on the DB as they wont appear under list resource. I am sure one of the ways to do it is -> delete and add the node , but then I don't want to go with that approach. I was rather thinking if I could remove all Hardware Health related stuff on the DB for the selected nodes as they are leftovers which we would not require anymore.

shalinz

Here is the query I use to remove Hardware Health monitoring from a node.

UPDATE APM_HardwareInfo SET IsDisabled = 1 WHERE NodeID = 'InsertNodeIdHere'

JiriPsota

To remove all related data from DB just delete rows for selected NodeIds from tables APM_HardwareInfo, APM_HardwareCategoryStatus, APM_HardwareItem

DELETE FROM APM_HardwareInfo WHERE NodeId IN ()

DELETE FROM APM_HardwareCategoryStatus WHERE NodeId IN ()

DELETE FROM APM_HardwareItem WHERE NodeId IN ()

Historical data will be removed with next Database Maintenance run.

vinay.by

Thank you JiriPsota , but then are these the only 3 tables where we have to look for ?