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

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 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