Get a listing of all current static groups and members

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have a large number of groups in UIM and would like to document what we have in static groups in the event we need to audit changes in the future.

Environment

Release : 20.4

Component: operator_console groups

Resolution

 

The following will give a listing of all static groups, and the members of the groups:

--get a list of devices that are in static groups
select cg.grp_id,
ccs.cs_id, 
cg.name,
ccs.name as group_name,
ccs.ip, 
cg.grp_type,
cg.pgrp_id as parent_group
from cm_group cg
join cm_group_member cgm on cgm.grp_id = cg.grp_id 
join cm_computer_system ccs on ccs.cs_id = cgm.cs_id 
where cg.grp_type = 0 order by cg.grp_id, ccs.cs_id asc