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

Created by John McMahon on Feb 11, 2022
Purpose of Query

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

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS(tick)
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