upm_portlet

This table, along with upm_portlet_content, is used by Unicenter Patch Management to control and configure the "control panel objects" that appear on the main page of UPM. They are not true portlets. The contents of this table should not be modified directly by the user except on direct instructions from CA.

Column Name Column Datatype Column Null Option Column Comment
user_uuid byte(16) not null The uuid of the "portlet" as assigned when the user selects the an object to include on the main page.
type integer1 not null "The type of ""portlet"". 1 = favorites 2 = channels 3 = charts #1 4 = charts #2 5 = charts #3 6 = charts #4 7 = charts #5 8 = charts #6 9 = charts #7 10 = charts #8 11 = charts #9 12 = system status 13 = new patches 14 = patches pending test 15 = patches pending approval 16 = patches approved 17 = patch deployment"
int_data1 integer with null This column contains optional configuration parameter in integer form. The value is dependent on the type of "portlet" to which it applies.
int_data2 integer with null This column contains optional configuration parameter in integer form. The value is dependent on the type of "portlet" to which it applies.
int_data3 integer with null This column contains optional configuration parameter in integer form. The value is dependent on the type of "portlet" to which it applies.
str_data1 nvarchar(512) with null This column contains optional configuration parameter in string form. The format of the string is dependent on the type of "portlet" to which it applies.
str_data2 nvarchar(512) with null This column contains optional configuration parameter in string form. The format of the string is dependent on the type of "portlet" to which it applies.
str_data3 nvarchar(512) with null This column contains optional configuration parameter in string form. The format of the string is dependent on the type of "portlet" to which it applies.

Product Name: Unicenter Patch Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
user_uuid
type
upm_portlet_content user_uuid
type


Copyright © 2006 CA. All rights reserved.