Finding server's group in UIM database

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Using UIM 20.3.3, I'm trying to find a server's assigned group (via OC) in the database.

What table do I need to access?

Environment

Release : 20.3

Component : UIM OPERATOR CONSOLE - GROUPS

Resolution

First it is necessary to find the device cs_id. 
select * from CM_COMPUTER_SYSTEM where name = 'xxxxx' 
or 
select * from CM_COMPUTER_SYSTEM where ip = 'xxxxx' 
then 
select * from CM_GROUP_MEMBER where cs_id = xxxx 
from that put the grp_id into:
select * from CM_GROUP where grp_id = xxxx 

Additional Information

The group related tables are:

CM_GROUP < grp_id, grp_type, pgrp_id, name, criteria < all groups show up here
CM_GROUP_ACCOUNT < group_id, account_id < used only if group is tied to an account
CM_GROUP_AUTOMATIC < auto_id, field, parent < used for groups auto created by uim
CM_GROUP_AUTOMATIC_RESULT < auto_id, grp_id, grp_value, grp_type < auto created sub groups
CM_GROUP_DYNAMIC < auto_id, grp_id, < not sure if it is used any more
CM_GROUP_DYNAMIC_RESULT < grp_id, < not sure if it is used any more
CM_GROUP_MASTER_MEMBER < master_id, grp_id
CM_GROUP_MEMBER < grp_id, cs_id 
CM_GROUP_PRECONFIGURED < id, grp_id, name < used for application discovery auto created groups
CM_GROUP_PRECONFIGURED_DEF < id, grp_ path < used for application discovery auto created groups
CM_GROUP_PRECONFIGURED_PROFILE < def_id, profile_name < used for application discovery auto created groups