Purpose of Query
This document provides a query to get the number of Lines of Code by Snapshot for an Application.
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
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> -- here 2 AND M.OBJECT_ID = <APPLICATION_ID> -- here 3 AND m.METRIC_ID = 10151
Query result example
"App1";"V2-COBOL-1APP-2016-MR2-11082016";1070390
Query result interpretation
Snapshot "V2-COBOL-1APP-2016-MR2-11082016" of Application "App1" contains 1070390 lines of code
Query for Oracle
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> -- here 98 AND M.OBJECT_ID = <APPLICATION_ID> -- here 468616 AND m.METRIC_ID = 10151
Query result example
APPLICATION SNAPSHOT Number of Code Lines
--------------------- --------------------------------------- ---------------------------------
App2 App2 01/12/2016 10:50:50 2751
1 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 1/ms]
[Executed: 03/02/17 09:36:49 GMT ] [Execution: 920/ms]
Query result interpretation
Snapshot "App2 01/12/2016 10:50:5" of Application "App2" contains 2751 lines of code.
Notes/comments
Related Pages