SQL Queries - CAST Knowledge Base - Queries on metrics and diagnostics - How to check which Metrics computation option has been calculated

Purpose of Query

Thus query will help you to check which Metrics computation option has been calculated.

Applicable CAST Version

Applicable RDBMS

Query for CSS

SELECT CASE 
         WHEN infval = 0 THEN 'SPA Metrics computation: no metrics computation' 
         WHEN infval = 1 THEN 'SPA Metrics computation: all metrics' 
         WHEN infval = 2 THEN 
'SPA Metrics computation: all metrics except copy/paste and commented code' 
ELSE 'N/A' 
END 
FROM   anainf ai 
       JOIN anajob aj 
         ON aj.idjob = ai.idjob 
            AND aj.jobtyp = 3001 
WHERE  ai.inftyp = 1 
       AND ai.infsubtyp = 31;

Query result example

–SPA Metrics computation: all metrics

Query result interpretation

The SQL query will return:

“Metrics computation: All metrics” if all Metrics computation option has been calculated

“Metrics computation: all metrics except copy/paste and commented code” if all Metrics computation option has been calculated except copy/paste and commented code

“Metrics computation: No metric computation” if all Metrics computation option has been not calculated

Query for Oracle

Query result example

Query result interpretation

Query for SQL server

Query result example

Query result interpretation

Notes/comments

Related Pages