Use to store user defined group definitions
| Column Name | Column Datatype | Column Null Option | Column Comment |
| group_uuid | byte(16) | not null | Primary Key |
| domain_uuid | byte(16) | not null | Primary Key of the domain object defined in ca_n_tier |
| eval_freq | integer | with null | Time in seconds between evaluation |
| last_eval_date_time | integer | with null | Last evaluation date/time |
| query_uuid | byte(16) | with null | Reference to a query
NULL in case of a static group otherwise it contains a uuid of a query |
| member_type | integer | with null | Defines the type of the members just in case it is an homogenouse group e.g. AssetLogical, UserLogical,....etc. |
| label | nvarchar(255) | with null | Label for group |
| evaluation_uuid | byte(16) | with null | If it's NULL then it is a static group, else pointing to Engine uuid |
| group_inheritance | smallint | with null | 0=Flat, 1=Single Parent, 2=Multiple Parent
root groups are always "flat" groups |
| evaluation_location | smallint | with null | 0 = Definition Level,
1=Local Level
Only used when being Dynamic |
| last_update_user | nvarchar(255) | with null | Database user or component/process that updated the record |
| last_update_date | integer | with null | Last Change Date/Time (DB timestamp) |
| version_number | integer | with null | Last version number |
| creation_date | integer | with null | Creation date/Time |
| creation_user | nvarchar(255) | with null | Database user or component/process that created the record |
| group_flag | smallint | with null | 0=Local Group,
1=Global Group
on enterprise level: * we have global groups only on domain level * local groups will not be replicated * global groups will be replicated |
| group_system | smallint | with null | 0=System Group, - like AllComputer Group, AllSoftware
1=UserDefined group 2= directory group |
| security_group | integer | with null | 0=Ordinary group, 1=Security group |
| description | nvarchar(255) | with null | User defined comment / description |
| auto_rep_version | date | with null | Replication version |
Product Name: Unicenter Desktop and Server Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| group_uuid | ca_group_member | group_uuid |
| group_uuid | ca_group_member | group_uuid |