Page tree
Skip to end of metadata
Go to start of metadata


Purpose of Query

 The queries in this section are run on the Measure Base to check the LOC stored.

Applicable CAST Version


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


RDBMS
Yes/No
Oracle Server (error)
Microsoft SQL Server (error)
CSS2 (tick)


Query for CSS
SELECT DSSO.OBJECT_NAME   AS APPLICATION ,
       DSSS.SNAPSHOT_NAME AS SNAPSHOT    ,
       m.METRIC_NUM_VALUE AS "Number of Code Lines"
FROM   DSS_METRIC_RESULTS m
       JOIN DSS_OBJECTS DSSO
       ON     DSSO.OBJECT_ID=m.OBJECT_ID
       JOIN DSS_SNAPSHOTS DSSS
       ON     DSSS.SNAPSHOT_ID=M.SNAPSHOT_ID
--WHERE  M.SNAPSHOT_ID          = <snapshot_id> --uncomment and pass your snapshot id if you want to check for specific snapshot
AND    DSSO.OBJECT_type_ID    = -102 
AND    m.METRIC_ID            = 10151
Query result example

 You can see the result as application name, snapshot name and LOC count as below

Query result interpretation


Query for Oracle
Enter the SQL query
Query result example

Query result interpretation


Query for SQL server
Enter the SQL query
Query result example

Query result interpretation

Notes/comments


Related Pages

  • No labels