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

Purpose of Query

This query on the central base provides the list of critical metrics.

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT a.metric_id,
       b.metric_name
FROM   DSS_METRIC_TYPE_TREES a,
       DSS_METRIC_TYPES b
WHERE  a.metric_id      = b.metric_id
AND    a.metric_critical=1

Query result example

7520;“Avoid unchecked return code (SY-SUBRC) after OPEN SQL or READ statement”
7372;“Enable Struts Validator plugin”
7144;“Action Artifacts should not directly use database objects”
7890;“Web Dynpro - Never use INCLUDE statement”
5094;“Avoid using MOVE CORRESPONDING … TO …”

Query result interpretation

The query returns the metric id and the metric name of all critical metrics/violations.

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