The usm_metric_resultXXXXX tables are dynamically created by dcanalyzer when it aggregates events into a meaningful value for this metric. The XXXXX value will be the metric category id for the metrics being aggregated. This table is added to serve as a prototype for all the dynamic usm_metric_result tables This was done to enhance the access performance when multiple iCan components needed to access the result tables simultaneously.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| sm_start_time | date | with null | The start time for the aggregation report interval period. |
| sm_end_time | date | with null | The end time for the aggregation report interval period. |
| sm_result | float | with null | The aggregated result value for this report interval. |
| sm_result_status | integer | with null | This show the result of the aggregation. 1=success, 0=failure. A partial failure may occur, and the percentage of inaccurate data will be stored in sm_exclude. |
| sm_exclude | integer | with null | The percentage of inaccurate or unknown data which occurred during this report interval. |
| grouped_by | varchar(20) | with null | When a result is aggregated, and multiple results are generated because of a group by clause, the grouped by value is stored it this field. |
| group_by_type | integer | with null | This is a code, which is use by the aggregation logic to determine which field is to be use when doing the group by clause. |
| metric_instance_id | integer | with null | The metric instance id that is associated with this result. |
| maximum | float | with null | If the data is reduced, this contain the maximum value of the reduced data. |
| minimum | float | with null | If the data is reduced, this contains the minimum value of the reduced data. |
| no_of_samples | integer | with null | No of samples reduced into one. Null if no reduction |
| reduction_level | integer | with null | Reduction level, 0 and Null means raw data. |
Product Name: Unicenter Service Management
Table Type: Table