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.
I have checked and found that device still exist in cm_device table but not populating the ck_key.
Follow these steps below:
For every discovery_agent host: 1. Stop the discovery_agent. 2. Stop discovery_server. 3. Delete discovered computers from db by running the following queries:
delete from CM_COMPUTER_SYSTEM;
delete from CM_NIMBUS_ROBOT;
delete from DS_ROBOT_XREF;
(5a. Clear niscache if necessary)
You may want to look at niscache doc too
How do I find the source of a USM entry?
Just you to know that you are now able to remove devices through USM in UIM 8.5.1.
This is new feature in UIM 8.5.1.
Please have a minute to take a look at the below doc.
Hostname resolution in UIM alarm (alert) works within name services thread in NAS probe.
Open NAS probe GUI > Name Services > Address Table.
Check how the ip address is supposed to be resolved.
You can remove existing entries in the GUI via highlighting entries, right click, then delete.