usm_report_group

A report group is a collection of metric instances with a set of associated service goals. Also, a set of analyses are schedules on the metric instances within the report group.

A report group is associated with a contract. The contract is used to retrieve the service hours. Also, the contract may be used to retrieve a overall status for the report group. This may not be included in r11.

Column Name Column Datatype Column Null Option Column Comment
report_group_id integer not null Unique identity for the report group
parent_path varchar(255) with null Parent path of the report group. The parent path is a lost of report group id's separated by "/".

Root level report groups have a path of "/"

report_group_template_id integer with null Unique identity for the report group template from which this report group is derived.
contract_id integer with null The associated contract
name nvarchar(64) with null The name of the report group
description nvarchar(128) with null The description of the report group
level integer with null The level. Root level report groups have a level of "0".
calendar_oid varchar(20) with null Associated calendar for service events.

Events exported by that calendar into usm_service_events are used by analyses for this report group.

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
report_group_id usm_service_hours report_group_id
report_group_id usm_report_group_metric_instance report_group_id
report_group_id usm_report_group_goal report_group_id
report_group_id usm_analysis report_group_id
report_group_id usm_link_analyze_job_group report_group_id
report_group_id usm_report_group parent_path


Copyright © 2006 CA. All rights reserved.