A metric instance is mapped to one or more event instances that does the actual measurements. For metric instances with multiple components, this will result in one metric instance mapped to multiple event instances.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| metric_instance_id | integer | not null | Unique identifier |
| comment | nvarchar(64) | with null | This is a descriptive comment on metic_instance, Example: If any special configuration is needed. |
| description | nvarchar(128) | with null | A description about this metric instance |
| destination | varchar(20) | with null | Destination of the metric instance. May be SLABUS:host:port, smdb etc. |
| enable | integer | with null | |
| end_time | date | with null | End time, is the date/time when the metric become inactive. |
| full_detail | integer | with null | |
| group_id | integer | with null | The code which determines what field to group by.
0=No Group by
1=Group by user
2=group by DC Host
4=group by Target Host
8=group by Component
These values are Boolean, in order to allow a grouping code of multiple fields simultaneously. |
| metric_category_id | integer | with null | Unique identity identifying the metric category |
| metric_version | varchar(20) | with null | Metric request version |
| operator | integer | with null | |
| real_time_metric | integer | with null | |
| report_interval | integer | with null | The reporting interval is used to determine how frequently aggregation occurs. This value in conjunction whit the report_interval_unit determine the length of the period between aggregations |
| requestor | varchar(20) | with null | The module requesting the creation of this metric instance, BILLING, METERING, SLA etc |
| request_type | integer | with null | Metric instance type: 0=Normal, 4=RealTime |
| sample_interval | integer | with null | The sample interval that is used to determine how frequently you would like the data collector to send events for this metric. This value is always in seconds. |
| start_time | date | with null | Start time, is the date/time when metric become active. |
| status | integer | with null | Status ACTIVE / INACTIVE |
| threshold | float | with null | The threshold value |
| unittype_id | integer | with null | Unique identity for this unit type |
| user_dependent | integer | with null | |
| report_interval_unit | integer | with null | This is a code which determines the unit used for the reporting interval. 0=minutes (default) 1=hours 2=days 3=weeks 4=months 5=years 6=Day of month (ie: the 15th day of the month) |
| schema_id | integer | with null | Schema associated with this metric request. |
| server_id | integer | with null | Unique identifier for one slm server |
| created | integer | with null | |
| created_by | varchar(128) | with null | |
| last_modified | integer | with null | |
| last_modified_by | varchar(128) | with null | |
| source_analyze_job_id | integer | with null | |
| source_metric_instance_id | integer | with null | |
| host_id | integer | with null | |
| slo_instance_id | integer | with null | The slo instance related to this metric instance |
| sla_config_id | varchar(50) | with null | The sla configuration related to this metric instance |
| sla_instance_id | integer | with null | The sla instance related to this metric instance |
| contract_id | integer | with null | The contract related to this metric instance |
Product Name: Unicenter Service Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| metric_instance_id | usm_report_group_metric_instance | metric_instance_id |
| metric_instance_id | usm_dca_comp_status | metric_instance_id |
| metric_instance_id | usm_dca_app_status | metric_instance_id |
| metric_instance_id | usm_bus_queue | metric_instance_id |
| metric_instance_id | usm_link_event_inst_metric_inst | metric_instance_id |
| metric_instance_id | usm_sm_comp | metric_instance_id |
| metric_instance_id | usm_sla_metric_instance | metric_instance_id |
| metric_instance_id | usm_link_service_event_metric_in | metric_instance_id |
| metric_instance_id | usm_serviceconfig | metric_instance_id |
| metric_instance_id | usm_metric_resultxxxxx | metric_instance_id |
| metric_instance_id | usm_metric_instance_appuser | metric_instance_id |