search cancel

UIM - remove an origin from a device

book

Article ID: 242728

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Robot sw0xxxx34 configured origin called 'ns', but shows 'ns' and 'Tooling and Automation team' in Operator Console (see pictures below).

How can we remove origin 'Tooling and Automation team' from this device? I already checked database tables SSRV2Device, CM_COMPUTER_SYSTEM, S_QOS_DATA, CM_NIMBUS_ROBOT, but can't find a relation between the device and origin 'Tooling and Automation team'.

 

Cause

The computer system origin information will be stored in two tables CM_COMPUTER_SYSTEM and CM_COMPUTER_SYSTEM_ATTR. 

First time when a robot is installed then the primary hub origin will get inserted in to both of the above tables. In the future when ever we override the origin with new origin name in the controller, then the origin value in the CM_COMPUTER_SYSTEM will get updated with the new origin name and a new record get inserted in CM_COMPUTER_SYSTEM_ATTR table. With this in OC device details page, both the origins will get displayed with comma separated values. Incase if we want to delete the unwanted origin (which was created by default at the first time) then we need to delete that value from CM_COMPUTER_SYSTEM_ATTR table with the help of the following queries. With that OC will not display the unwanted origin name in device details pane.

Environment

Release : 20.4

Component : UIM - ROBOT

Resolution

 

Execute the following query to see all origin names for a computer system

Select * from CM_COMPUTER_SYSTEM_ATTR where cs_id = <cs id> and cs_attr_key = 'origin'

 

https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=P/TfDGZtEc5rRBRXjYGPrw==

Then execute the following query to delete the unwanted origin by replace <cs id> and <origin name to delete> values.

Delete from CM_COMPUTER_SYSTEM_ATTR where cs_id = <cs id>  and cs_attr_key = 'origin' and cs_attr_value = '<origin name to delete>'

Note: Using the above query, we cannot delete the origin name which was created through controller override because that exists in CM_COMPUTER_SYSTEM table

Attachments