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
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
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.