I have a need to delete a server that appears in the Nimsoft database. What is the safest way of achieving this?
The server in question had it's robot_id changed at the system (I don't know why a colleague did this) so it then appears in CM_DEVICES twice. It is also appearing as two computer systems in CM_COMPUTER_SYSTEMS. I'd like to remove the incorrect one.
However, I know the dev_id and cs_id appear in other tables and wondered which tables I need to ensure these references are removed from. Or will it be safe to leave these?
It would also be a bonus is old QoS data and alarms in the NIS were removed too.