Export inventory in UIM Operator Console (OC)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

How can we export the list of servers discovered in UIM OC? We would like to export the entire inventory to a file. Is this option available? 

Environment

Release : 20.3 / 20.4

Component : UIM - OPERATOR CONSOLE

Resolution

In OC 20.4 

- Go to inventory

- Select all or select the devices that you need to export > click the three dots option > export

In OC 20.3.x  there is no such option available.

However, what you see in inventory is essentially the CM_COMPUTER_SYSTEM table in the UIM Database.

 

Every entry there is 1 master device (includes correlated devices into one) which are the devices that should be visible in inventory.

So the extract of the entire inventory is the result of:

Select * from CM_COMPUTER_SYSTEM

In the same way, you may query for other details including Robots, hubs etc as below:

--All robots:
select * from CM_NIMBUS_ROBOT

-- all non-hub-robots:
select * from CM_NIMBUS_ROBOT where is_hub = '0'

-- all hubs:
select * from CM_NIMBUS_ROBOT where is_hub = '1'

-- all Probes deployed on all robots, order by robot_id:
select * from CM_NIMBUS_PROBE order by robot_id

You can use the following to find any robot which has EXAMPLE for an origin:

select * from CM_NIMBUS_ROBOT where origin like '%EXAMPLE%'