The usm_cor_data table holds a long-lived cache of elements from the core. It is populated based on the capabilities defined in usm_cor_metric_capability. The data is organized as a folder tree that equals the structure in COR. The lowest level of the tree points out what metrics that can be used to measure that type of COR objects. The actual objects is not stored in the cache, but is pulled from COR when needed.
Fields-- cor_data_id - a sequential id for the data element. slm_server_id - the id of the COR gateway server. parent_path - a slash separated path of cor_data_id representing the tree level - the level in the tree (0 is a root node). label - the label for the data element. icon - name of icon to display. metric_id - the metric capable of measuring such objects. If NULL, it is a folder, and therefore has something below it. The metric name of the metric should be sent in the ObjectGet call to the COR
| Column Name | Column Datatype | Column Null Option | Column Comment |
| cor_data_id | integer | not null | A sequential id for the data element. |
| metric_id | integer | with null | The identity of the metric. the metric capable of measuring such objects. If NULL, it is a folder, and therefore has something below it. The metric name of the metric should be sent in the ObjectGet call to the COR |
| server_id | integer | with null | The id of the COR gateway server. |
| parent_path | varchar(50) | with null | Aslash separated path of cor_data_id representing the tree |
| level | integer | with null | The level in the tree (0 is a root node). |
| label | nvarchar(255) | with null | label - the label for the data element. |
| icon | varchar(20) | with null | Name of icon to display. |
Product Name: Unicenter Service Management
Table Type: Table