Moving robots from an old to a new UIM environment

book

Article ID: 192314

calendar_today

Updated On:

Products

NIMSOFT PROBES DX Infrastructure Management

Issue/Introduction

How do we delete the niscache on a given set of hundreds of robots automatically?

Cause

- outdated robot data, potential missing metrics, configuration/communication issues, duplicate data, robot administration
- When moving robots from an old environment to a new environment/UIM domain, it is important to clear out the old cache data and reset the robot device id.

Environment

Release : 8.x or higher

Component : UIMROB

Resolution

Please refer to the Article:

How to Clean Niscache Folder on All Active Robots
https://knowledge.broadcom.com/external/article/9570/

To run the UPDATE statement included in the article above, on a specific set/list of robots you can do something like this in
MS SQL Server Studio:

=========================================================================================

CREATE TABLE Robot_list (

robot varchar(255)

);

BULK INSERT

Robot_list

FROM 'C:\Robots.txt'

-- select * from Robot_list
-- Robot_list contains one line for every robot short hostname, e.g., labtest000599
-- delete from Robot_list where robot is NULL

UPDATE S_QOS_DATA SET CI_METRIC_ID = NULL WHERE ROBOT IN (SELECT * FROM Robot_list)

-- select * from s_qos_data where ci_metric_id is null and ROBOT IN (SELECT * FROM Robot_list)
-- DROP TABLE Robot_List

=========================================================================================


Test it out in a Test/DEV environment first and check the results.

Don't forget to Cold Start the data_engine (Deactivate-Activate) so the metric ids begin updating.

You can check by running the query->

select * from s_qos_data where ROBOT IN (SELECT * FROM Robot_list)

Additional Information


Moving UIM robots or probes from one hub (or robot) to another
https://knowledge.broadcom.com/external/article?articleId=33538

Moving hubs or robots to a different UIM domain
https://knowledge.broadcom.com/external/article?articleId=34311