SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of customized metrics

Purpose of Query

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)

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT *
FROM   DSS_METRIC_TYPES
WHERE  METRIC_ID > 1000000 ;

Query result example

2230;“Use of style sheets”;“This metric detects the pages where a Style sheet (*.css) is not directly or explicitly used.

Style sheet (*.css) should be used (instead of no css or hardcoded style definition like style= ).";3;1;”";0;0;0

Query result interpretation

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.

Query for Oracle

Enter the SQL query

Query result example

Query result interpretation

Query for SQL server

Enter the SQL query

Query result example

Query result interpretation

Notes/comments

Related Pages