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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS(tick)
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