How to remove entry of secondary hub discovery from USM which is already uninstalled.

Article Id: 39313

Status: Published

Updated On: 14-02-2018 07:54

Legacy Id: TEC1800006

Products:

CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) NIMSOFT PROBES

Issue/Introduction:

Problem:

Entry of Secondary hub's discovery needs to be removed from USM. Secondary hub has been uninstalled now.

Environment:

UIM: 8.x

UMP: 8.x

Database: MS-SQL Database

Cause:

Entries of the desired discovery_agent are present in Nimsoft SLM database. Hence, it was available on USM. Those entries need to be removed from Nimsoft SLM Database.

Resolution:

- Run below queries on Nimsoft SLM database:

select * from CM_DISCOVERY_AGENT.
This will list out all the hubs running discovery_agent. Now identify the hub which needs to be removed.
- Make a note of that corresponding hub's 'da_id' value.
- First delete all the discovered devices from CM_DISCOVERY_NETWORK whose da_id value is same of the identified hub. Run below query:
delete from CM_DISCOVERY_NETWORK where da_id = 'value captured in previous query'
- Now delete the entry from the CM_DISCOVERY_AGENT table with the same da_id
- deactivate/activate wasp probe
- Now , access UMP portal, the required entry has been removed.

Environment:

Release:
Component: CAUIM