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

Purpose of Query

This query on the central base will provide the list of deactivated metrics.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server❓
Microsoft SQL Server❓
CSS✅

Query for CSS

SELECT METRIC_ID,
       METRIC_NAME
FROM   DSS_METRIC_TYPES
WHERE  METRIC_TYPE = 0

Query result example

1562;“Package Stored Procedure naming convention - prefix control”
6552;“View naming convention - prefix control (DB2 Server)”
4050;“Avoid Tables access directly from client-side SQL queries (SQL Server)”

Query result interpretation

The query lists the metric id and metric name of deactivated queries.

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