AnsweredAssumed Answered

Manual deletion of device\host from UMP\USM?

Question asked by imrankhcl Champion on Aug 2, 2017
Latest reply on Aug 3, 2017 by Yu_Ishitani

Hi Guys,


I have manual deleted couple of devices from SQL DB through below commands.


delete from cm_computer_system where name ='hostname';

delete from s_qos_data where robot ='hostname';

delete from nas_alarms where robot ='hostname';


Now i am receiving the hostname in the new alert on soi where the hostname is different but ip address is same which was assigned to the old device.


I can check and find that at one place the CS_ID for both the devices are showing same and still the device i deleted exist somewhere in the database but not in the USM or in the three tables mentioned above.


Kindly suggest how to find and remove this device now.