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.