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

Purpose of Query

This query lists Technical Depbt by application and modules

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT dmr.snapshot_id,
       CASE dob.object_type_id
           WHEN -102 THEN 'Application'
           ELSE 'Module'
       END,
       dob.object_name,
       CASE dmr.metric_id
           WHEN 68001 THEN 'Technical Debt'
           WHEN 68901 THEN 'Technical Debt Added'
           ELSE 'Technical Debt Removed'
       END,
       metric_num_value
FROM dss_metric_results dmr
JOIN dss_objects dob ON dob.object_id = dmr.object_id
WHERE dob.object_type_id in (-102,
                             20000)
  AND dmr.metric_id in (68000,
                        68001,
                        68901,
                        68902)
  AND dmr.metric_value_index = 1
ORDER BY 1,
         2,
         3,
         4,
         5

Query result example

3;“Application”;“My application”;“Technical Debt”;1000
3;“Application”;“My application”;“Technical Debt Added”;25
3;“Application”;“My application”;“Technical Debt Removed”;20
3;“Module”;"___My application union content___";“Technical Debt”;1000
3;“Module”;"___My application union content___";“Technical Debt Added”;25
3;“Module”;"___My application union content___";“Technical Debt Removed”;20

Query result interpretation

The query returns snapshot id, application/module name and current, added and removed Technical Debt value

Notes/comments

Related Pages