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?
Release : 20.3
Component : UIM OPERATOR CONSOLE - GROUPS
First it is necessary to find the device cs_id.
select * from CM_COMPUTER_SYSTEM where name = 'xxxxx'
select * from CM_COMPUTER_SYSTEM where ip = 'xxxxx'
select * from CM_GROUP_MEMBER where cs_id = xxxx
from that put the grp_id into:
select * from CM_GROUP where grp_id = xxxx
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