How to find and delete duplicate robots in UIM
search cancel

How to find and delete duplicate robots in UIM


Article ID: 225506


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) Unified Infrastructure Management for Mainframe CA Unified Infrastructure Management SaaS (Nimsoft / UIM)


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


Release : 20.3

Component : UIM - HUB

- hub 9.31


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


Remove Master Devices by cs_key


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.