usd_cmp_grp

This table holds USD specific computer groups, used to group computers for USD features like grouping violators of a software template or to group computers in a move operation.

Column Name Column Datatype Column Null Option Column Comment
objectid byte(16) not null Primary key, it is a uuid.
version integer not null Version number is used to maintain cache and an optimistic transaction policy
creation_user nvarchar(255) with null Used to store the identifier of the entity creator. The string must be a URI of a valid ca_discovered_user entity.
qtask byte(16) not null Used to refer to a query task, not used now.
aux byte(16) not null Refers to an auxiliary object
aux2 byte(16) not null Refers to a secondary auxiliary object
type integer not null This is the group type.
attributes byte(4) not null This is the group attribute.
name nvarchar(129) not null This is the name of this USD specific computer group
comment nvarchar(255) not null This is the name of this USD specific computer group
credate integer not null Creation date of this USD specific computer group.
cretime integer not null Creation time of the this USD specific computer group.
chdate integer not null Change date of the this USD specific computer group.
chtime integer not null Change time of the this USD specific computer group.
propflag integer not null This is the group property flag.
qcalendar nvarchar(129) not null Used to be used for queries.
qevalrate integer not null Used to be used for queries.
qnextevaldate integer not null Used to be used for queries.
qnextevaltime integer not null Used to be used for queries.
qevaldate integer not null Used to be used for queries.
qevaltime integer not null Used to be used for queries.
qtemplfold byte(16) not null Used to be used for queries.
qtype integer not null Used to be used for queries.
state integer not null This is the group state.
seal integer not null This is the group seal state.
var integer not null This is a generic group variable
auxtext0 nvarchar(128) with null This is an auxiliary text object, not used in this table.
auxtext1 nvarchar(128) with null This is an auxiliary text object, not used in this table.
auxtext2 nvarchar(128) with null This is an auxiliary text object, not used in this table.
auxtext3 nvarchar(128) with null This is an auxiliary text object, not used in this table.
queryid byte(16) with null Used to be used for queries.

Product Name: Unicenter Desktop and Server Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
objectid usd_activity compfold
objectid usd_link_grp_cmp grp
objectid usd_link_cmpgrp grpparent
objectid usd_link_cmpgrp grpchild


Copyright © 2006 CA. All rights reserved.