What tables to query to get group and device related information

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have 42 devices under a static group – “Critical Sites – New” and other devices in dynamic group – “Non-Critical - New”. Our integration team, want to figure out the table or a custom query that can give group name associated with devices.

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - GROUPS

Resolution

select 
cms.cs_id,
cms.name,
cms.dedicated
from CM_COMPUTER_SYSTEM cms
JOIN CM_GROUP_MEMBER cgm on cgm.cs_id=cms.cs_id
JOIN CM_GROUP cg on cgm.grp_id = cg.grp_id 
where cg.grp_id in (select grp_id from cm_group where name like '%Windows%')

select 
cms.cs_id,
cms.name,
cms.dedicated,
*
from CM_COMPUTER_SYSTEM cms
JOIN CM_GROUP_MEMBER cgm on cgm.cs_id=cms.cs_id
JOIN CM_GROUP cg on cgm.grp_id = cg.grp_id 
where cg.grp_id in (select grp_id from cm_group where name like '%Windows%')