upm_baseline_sw

This table is used by Unicenter Patch Management

Column Name Column Datatype Column Null Option Column Comment
baseline_uuid byte(16) not null  
query_uuid byte(16) with null The uuid of the query as returned by the Unicenter DSM API when the query was defined by UPM. The query is used to target all of groups referred to by this policy (baseline) and to filter them by the criteria defined for each of the patches incorporated in the policy.
name nvarchar(64) with null The name of the policy (baseline).
sw_def_uuid byte(16) not null The uuid of the associated software release, service pack, or patch as identified in the ca_software_def table.
status integer1 not null " The current status of the policy (baseline) 1 = Under Construction 2 = Under Evaluation 3 = Has a violation 4 = All members are compliant 5 = Disabled 6 = Error 7 = Pending Workflow Creation 8 = Pending Workflow Update 9 = Updated By Workflow 10 = Creation Rejected 11 = Update Rejected "
creation_user nvarchar(64) with null  
creation_date integer with null  
last_update_user nvarchar(64) with null  
last_update_date integer with null  
group_uuid byte(16) with null The uuid group in Unicenter DSM that was created by the query identified in query_uuid.
template_uuid byte(16) with null The uuid of the software policy in Unicenter DSM that is associated with this policy (baseline).

Product Name: Unicenter Patch Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.