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

Purpose of Query

This query lists Cost complexity distribution by application and modules

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x
8.1.x
8.0.x

Applicable RDBMS

RDBMS	Yes/No
CSS3
CSS2

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 67005 THEN 'Low Cost Complexity Artifacts'
           WHEN 67004 THEN 'Average Cost Complexity Artifacts'
           WHEN 67003 THEN 'High Cost Complexity Artifacts'
           ELSE 'Very High Cost Complexity Artifacts'
       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 (67002,
                        67003,
                        67004,
                        67005)
  AND dmr.metric_value_index = 1
ORDER BY 1,
         2,
         3,
         4,
         5

Query result example

3;"Application";"My application";"Average Cost Complexity Artifacts";18066
3;"Application";"My application";"High Cost Complexity Artifacts";2268
3;"Application";"My application";"Low Cost Complexity Artifacts";283303
3;"Application";"My application";"Very High Cost Complexity Artifacts";529
3;"Module";"HTML5/Javascript";"Average Cost Complexity Artifacts";1796
3;"Module";"HTML5/Javascript";"High Cost Complexity Artifacts";222
3;"Module";"HTML5/Javascript";"Low Cost Complexity Artifacts";9040
3;"Module";"HTML5/Javascript";"Very High Cost Complexity Artifacts";52
3;"Module";"JEE";"Average Cost Complexity Artifacts";11328
3;"Module";"JEE";"High Cost Complexity Artifacts";1164
3;"Module";"JEE";"Low Cost Complexity Artifacts";271108
3;"Module";"JEE";"Very High Cost Complexity Artifacts";371
3;"Module";"SQL";"Average Cost Complexity Artifacts";4942
3;"Module";"SQL";"High Cost Complexity Artifacts";882
3;"Module";"SQL";"Low Cost Complexity Artifacts";3150
3;"Module";"SQL";"Very High Cost Complexity Artifacts";106
3;"Module";"Shell Scripts";"Average Cost Complexity Artifacts";0
3;"Module";"Shell Scripts";"High Cost Complexity Artifacts";0
3;"Module";"Shell Scripts";"Low Cost Complexity Artifacts";5
3;"Module";"Shell Scripts";"Very High Cost Complexity Artifacts";0
3;"Module";"___My application union content___";"Average Cost Complexity Artifacts";18066
3;"Module";"___My application union content___";"High Cost Complexity Artifacts";2268
3;"Module";"___My application union content___";"Low Cost Complexity Artifacts";283303
3;"Module";"___My application union content___";"Very High Cost Complexity Artifacts";529

Query result interpretation

The query returns snapshot id, application/module name, cost complexity severity and cost complexity value

Notes/comments

Related Pages