ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

UIM Dynamic Group via SQL Query sample

book

Article ID: 214241

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Here  is a sample query to create a group including all the robots under a hub. 

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - GROUPS

Resolution

select distinct cs.cs_id from cm_computer_system cs inner join cm_device cd on cs.cs_id = cd.cs_id inner join cm_nimbus_robot cr on cd.dev_id = cr.dev_id where cr.hub = 'hub_name'