How to find and delete duplicate robots in UIM

book

Article ID: 225506

calendar_today

Updated On:

Products

DX Infrastructure Management CA Unified Infrastructure Management for z Systems CA Unified Infrastructure Management On-Premise (Nimsoft / UIM) CA Unified Infrastructure Management SaaS (Nimsoft / UIM) NIMSOFT PROBES

Issue/Introduction

We have over 1100 duplicate robots in our UIM environment and we need to eliminate them.

Cause

Potential causes include the following:
 
- Duplicate robots may be caused by robot cloning
- hub 9.31 had a defect introduced which caused duplicate robots. For more information please refer to the KB Article:
 
Duplicate, missing, inactive and/or broken robots in IM after upgrading hub to 9.31

Environment

Release : 20.3

Component : UIM - HUB

- hub 9.31

Resolution

Remove Master Devices by cs_key

Reference:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/installing/discover-systems-to-monitor/advanced-configuration/remove-master-devices-through-discovery-server.html

To display a list of CS keys for devices, use the following query against the UIM database, using whatever application is appropriate for the database type (SQL Server, MySQL, or Oracle):

SELECT origin,name,ip,dns_name,nimbus_type,cs_id,cs_key,dedicated,mac,os_name FROM cm_computer_system WHERE name LIKE ('%robot_or_device_name_to_be_deleted%') ORDER BY name

Other helpful queries for developing a list of duplicate robots:

select name from cm_computer_system group by name HAVING COUNT(*) > 1

select * from cm_computer_system where name like '%<robot or device name>%' order by name

Additional Information

In the lab we tested deletion by a specific subset set of cskeys and it seems like it will take up to 128 cskeys but I would stick to 64 at a time. Also, if you accidentally enter a duplicate cskey value, it picks it up and it also tells you the count of which ones were queued for deletion.