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'.
Release : 20.4
Component : UIM - ROBOT
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.
Execute the following query to see all origin names for a computer system
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