usm_analysis

This table represents the analysis repository.

It contains a summary of the analysis created as xml.

Column Name Column Datatype Column Null Option Column Comment
analysis_id integer not null  
report_group_id integer with null Unique identity for the report group
category nvarchar(255) with null The category of the analysis
access_group nvarchar(100) with null The access group to which the analysis belongs
commandlineargs varchar(255) with null Identifies the command line arguments needed to rerun the command in addition to the class and metric scopes.

Syntax: A:B:C

A - command line args B - class scope C - metric scope

class and metric scope is not used anymore.

analyze_period varchar(50) with null Identifies the period for the report.

For example, Monday, Tuesday, ...

analyze_title nvarchar(255) with null The title of the analysis
release_status integer1 with null Indicates whether the analysis in a release cycle is released or not.
url varchar(20) with null The file name for the file containing the report for this analysis. ".html" is stripped from the filename.
analyze_job_id integer with null Unique identity for the analyze job
analyze_status integer1 with null Overall status of the analysis:

Which statuses are supported is TBD.

created integer with null Epoch time of creation
modified integer with null Epoch time of modification
period_start integer with null The start time of the analysis in epoch
period_stop integer with null Then end_time of the analysis in epoch
period_type varchar(20) with null Defines the interval of the analyzis relative to the time of the analyze job.

For example today.

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.