usm_metric_attr_spec

The metric attribute specification specifies which attributes can be set for a given metric type during instantiation. It also specifies the default value of the attribute if available.

If an attribute has multiple values allowed, and the user enters multiple values during instantiation/deployment/resource assignment, multiple event instances will be created for the metric instance. This mechanism should be used to represent the Assure 2.2. component concept.

Column Name Column Datatype Column Null Option Column Comment
metric_attr_spec_id integer not null Unique identifier for the metric attribute specification for the given attribute
attribute_name varchar(100) not null Name of the attribute
type varchar(20) with null Defines the type of attribute, hidden, select etc.
label_bundle_key varchar(50) with null The bundle key of the label. This bundle key should be used if the label field is NULL.
label nvarchar(100) with null The label of the attribute
default_value nvarchar(255) with null The default value for the attribute spec. If a plugin is used, the default value should be specified as NULL, and default_reference_key should be used.
default_reference_key varchar(50) with null Reference key to the default value if reference plugins are used.
is_required char(1) with null Y - the attribute is required N - optional attribute
metric_id integer with null Identifies the metric for which this attribute specification is valid.
allow_multiple_values char(1) with null Y - the user may enter multiple values for this attribute.

N - only one value allowed.

A metric specification for a given metric should only contain one attribute where multiple values are allowed. This will be used to represent multiple components in r11

metric_attr_reference_plugin_id integer with null References the plugin used to retrieve the allowed attribute values.
tab_order integer with null  
cor_property varchar(20) with null Identifies GUI properties of metrics that have some instantiation data received from COR.

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
metric_attr_spec_id usm_collection_profile_attrs metric_attr_spec_id
metric_attr_spec_id usm_metric_attr_value metric_attr_spec_id
metric_attr_spec_id usm_metric_attr_spec_value metric_attr_spec_id


Copyright © 2006 CA. All rights reserved.