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.
Release : 20.4
Component: operator_console groups
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