This document provides a query to get the Health Factor grades (efficiency, security, robustness, transferability, changeability) for a given Snapshot of an Application.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 |
SELECT O.OBJECT_NAME AS APPLICATION , S.SNAPSHOT_NAME , T.metric_name AS HEALTH_FACTOR , ROUND(R.metric_num_value,3)AS GRADE FROM dss_metric_results R, dss_metric_types T , dss_snapshots S , dss_objects O WHERE R.snapshot_id =S.snapshot_id AND R.metric_id = T.metric_id AND R.snapshot_id = <SNAPSHOT_ID> -- here 2 AND T.metric_id IN(60011,60012,60013,60014,60016) AND R.object_id = O.object_id AND R.object_id = <APPLICATION_ID> --here 3 AND R.metric_value_index = 0
"App1";"V2-COBOL-1APP-2016-MR2-11082016";"Efficiency";1.251
"App1";"V2-COBOL-1APP-2016-MR2-11082016";"Transferability";2.643
"App1";"V2-COBOL-1APP-2016-MR2-11082016";"Security";2.237
"App1";"V2-COBOL-1APP-2016-MR2-11082016";"Changeability";2.595
"App1";"V2-COBOL-1APP-2016-MR2-11082016";"Robustness";2.149
Snapshot "V2-COBOL-1 APP-2016-MR2-11082016" of Application "App1" has the following grades for the five Health Factors
- Efficiency : 1.251
- Tranferability : 2.643
- Security : 2.237
- Changeability : 2.595
- Robustness : 2.149
SELECT O.OBJECT_NAME AS APPLICATION , S.SNAPSHOT_NAME , T.metric_name AS HEALTH_FACTOR , ROUND(R.metric_num_value,3)AS GRADE FROM dss_metric_results R, dss_metric_types T , dss_snapshots S , dss_objects O WHERE R.snapshot_id =S.snapshot_id AND R.metric_id = T.metric_id AND R.snapshot_id = <SNAPSHOT_ID> -- here 98 AND T.metric_id IN(60011,60012,60013,60014,60016) AND R.object_id = O.object_id AND R.object_id = <APPLICATION_ID> -- here 468616 AND R.metric_value_index = 0
APPLICATION SNAPSHOT_NAME HEALTH_FACTOR GRADE
------------------- --------------------------------------- ------------------------------ -----------
App2 App2 01/12/2016 10:50:50 Transferability 2,893
App2 App2 01/12/2016 10:50:50 Changeability 2,341
App2 App2 01/12/2016 10:50:50 Robustness 2,487
App2 App2 01/12/2016 10:50:50 Efficiency 2,308
App2 App2 01/12/2016 10:50:50 Security 2,2
5 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 1/ms]
[Executed: 01/02/17 08:57:30 GMT ] [Execution: 7723/ms]
Snapshot "App2 01/12/2016 10:50:50" of Application "App2" has the following grades for the five Health Factors
- Transferability : 2.893
- Changeability : 2.341
- Robustness : 2.487
- Efficiency : 2.308
- Security : 2.2