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

 

Release
Yes/No
8.3.x (tick)
8.2.x (tick)
8.1.x (tick)
8.0.x (tick) 
Applicable RDBMS


RDBMS
Yes/No
CSS3  (tick)  
CSS2  (tick)  


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