This query on the central base provides the list of metrics which have been customized in the central base.
Some additional tables which may be pertinent to metric customization:
For the list of metrics that has been modified / customized / tuned (weights, critical state, thresholds, parameters, etc.) by the customer; following tables contains the modifications on the parameters, thresholds,weight, Critical contribution:
- DSS_METRIC_HISTO_TREE, contains for each couple (SNAPSHOT_ID , METRIC_ID) , The METRIC_PARENT_ID, AGGREGATE_WEIGHT and METRIC_CRITICAL
So, if customer has modified the aggregation weight and/or the critical contribution, he/she can check the modifications in this table.
- DSS_METRIC_HISTO_PARAMS: This table contains per (SNAPSHOT_ID, METRIC_ID): PARAM_INDEX, PARAM_NUM_VALUE and PARAM_CHAR_VALUE
If customer has modified the parameters of some metrics, he/she can check the modifications in this table.
- DSS_METRIC_HISTO_THRESHOLDS : the table contains the values of thresholds per (SNAPSHOT_ID, METRIC_ID)
- DSS_METRIC_HISTO_DELTA : contains the modification of parameters, thresholds, weight for a couple (SNAPSHOT_ID, METRIC_ID)
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
SELECT * FROM DSS_METRIC_TYPES WHERE METRIC_ID > 1000000 ;
Style sheet (*.css) should be used (instead of no css or hardcoded style definition like style= ).";3;1;"";0;0;0
The query returns the metic_id, metric_name and description and other information pertinent to the metric.
The above example is not a custom metric, but just an example of the results that may be produced by this query.
Enter the SQL query
Enter the SQL query