Manual deletion of device\host from UMP\USM?

[Legacy User]

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.

 

Regards,

IK

[Legacy User]

Hi Guys,

 

I have checked and found that device still exist in cm_device table but not populating the ck_key.

 

Regards,

IK

[moez bhimji]

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;

 

4. On every discovery_agent system, remove local database from discovery_agents by deleting

Nimsoft/probes/service/discovery_agent/discovery.db3

5. 
   On the discovery_server host remove the database for each hub by deleting the hub directories in

Nimsoft/probes/service/discovery_server/<HUBS*>

(5a.  Clear niscache if necessary)

 

6. Restart nis_server to clean up the groups.
   
   At this time your discovery is empty. All your views should be empty. You may get transient ‘failed to connect’ messages, but that is expected. Although you can adjust your discovery scopes at any time, now is a good time to adjust them if needed before restarting discovery. Once you are ready to restart discovery, follow these steps to do so:
7. 
   Start discovery_server probe.
   2. Start all discovery_agents.
   3. Wait for network discovery to complete.
   
   Review the results in UMP => NimsoftRemoteAdmin

 

You may want to look at niscache doc too

 

How do I find the source of a USM entry? 

[yasal01]

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.

 

https://docops.ca.com/ca-unified-infrastructure-management/8-5-1/en/installing-ca-uim/discover-systems-to-monitor/advanced-configuration/delete-devices-in-usm

[Yu Ishitani]

Hi.

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.