DX UIM 23.4.*
DX UIM does not natively parse and store the "secondary_hub" text string from local robot.cfg files into the database. The database only tracks the active connection, meaning a robot's configured-but-inactive failover destination is not visible via standard inventory tables.
Is there a built-in SQL table or report for this?
No. Natively, DX UIM does not parse and upload the offline secondary_hub parameter text from local robot.cfg files into database tables. The database only knows where the robot is currently talking to.
To extract this data, UIM administrators typically write a Lua script in the nas probe or via the nsa (Nimsoft Script Agent) probe. The script loops through your inventory using callbacks to fetch the raw configuration of each robot's controller probe:
Use the gethubs callback on the primary hub to find all hubs.
Use the getrobots callback on those hubs to list all robot addresses.
Use a nimNamedRequest to issue a _get_info or get_config callback to the controller probe of each robot to query the secondary_hub section.
Because auditing many (hundresds?thousands?) of individual .cfg files via script can be time-consuming, the reccomendation is to push a Configuration-Only Package rather than trying to audit them first. If you want to guarantee all robots point to a specific secondary hub:
In Infrastructure Manager, go to your Archive.
Drag and drop a controller probe into the archive to generate a custom configuration package (e.g., robot_update_failover).
Right-click the new package, click Edit, and open the robot.cfx file. (right click edit)
Modify it so it strictly contains only your desired failover keys:
<controller> overwritesecondary_domain = YourDomain secondary_hub = YourSecondaryHubName secondary_hubrobotname = YourSecondaryHubRobotName secondary_hubip = xxx.xxx.xxx.xxx secondary_hubport = 48002 </controller>
Deploy this package to your target robots in bulk. They will adopt the secondary hub configurations instantly without you needing to manually hunt down which ones were missing it.