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

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

This query on the central base will provide the list of deactivated 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 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