SQL Queries - CAST Central Base - SQL Queries on Metrics

Purpose of Query

This page consists of all the SQL queries which have to be executed on Central Database related to metrics. For instance these queries provide information such as getting the list of critical metrics , deactivated metrics , technical criteria to which a metric belongs to, etc.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Details

  1. Please select the page you are interested in from the below list -
  2. If you do not find the information you are looking for or solution for your problem, please contact CAST Technical Support

Notes/comments

Related Pages

SQL Queries - CAST Central Base - Queries on Metrics - How to calculate Technical Debt manually

SQL Queries - CAST Central Base - Queries on Metrics - How to calculate the number of bookmarks per object per metric_id

SQL Queries - CAST Central Base - Queries on Metrics - How to check if some metrics have Total Checks equal to 0

SQL Queries - CAST Central Base - Queries on Metrics - How to check which rules have changed criticality between snapshots

SQL Queries - CAST Central Base - Queries on Metrics - How to detect when the violation has been added into the Action Plan

SQL Queries - CAST Central Base - Queries on Metrics - How to find out whether a given metric has been calculated in a given snapshot

SQL Queries - CAST Central Base - Queries on Metrics - How to get a list of complex objects

SQL Queries - CAST Central Base - Queries on Metrics - How to get the added metric list between two Cast versions

SQL Queries - CAST Central Base - Queries on Metrics - How to get the cyclomatic complexity by type of objects for a specific snapshot

SQL Queries - CAST Central Base - Queries on Metrics - How to get the deleted metric list between two Cast versions

SQL Queries - CAST Central Base - Queries on Metrics - How to get the details of critical violations displayed in the STATISTICS section in the left panel

SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of all metrics by technology for all business and technical criteria

SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of all metrics with param name and values

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

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

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

SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of items making up technical and business criteria

SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of quality rules attached to more than two technical criteria

SQL Queries - CAST Central Base - Queries on Metrics - How to get the list of sub component metrics of any Parent Metric

SQL Queries - CAST Central Base - Queries on Metrics - How to get the source code position for objects with violations

SQL Queries - CAST Central Base - Queries on Metrics - How to get the technical criteria of the metric given the metric Id

SQL Queries - CAST Central Base - Queries on Metrics - How to get the violation list of objects for a given quality rule per application module and snapshot

SQL Queries - CAST Central Base - SQL Queries on Metrics - How to check the values of a quality measure for a module

SQL Queries - CAST Central Base - SQL Queries on Metrics - How to get Cost complexity distribution by application and modules

SQL Queries - CAST Central Base - SQL Queries on Metrics - How to get Technical Debt by application and module

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

SQL Queries - CAST Central Base - SQL Queries on Metrics - Number of violation occurrences by quality rule

SQL Queries - CAST Central Base - SQL Queries on Metrics - Violations scores