Problem:

Is it possible to report on the amount of tests that passed or failed for a specific build or version of a Product in SilkCentral Test Manager?

Resolution:

QUESTION
----------------------------------
Is it possible to report on the amount of tests that passed, failed or were not executed for all builds of a particular Version of a Product in SilkCentral Test Manager?

ANSWER
----------------------------------
It is possible to generate metrics or a report based on the amount of tests that were executed for all builds of a particular Version of a Product in SilkCentral Test Manager. To do this we use the SilkCentral Test Manager database table TM_ExecDefinitionRuns. This table contains information such as the Build number of a product used for a particular execution run, version number, product name etc.

We then create a new report in the Reports section of SilkCentral Test Manager and click the Advanced Query button so that we can use our own SQL to obtain the information from the TM_ExecDefinitionRuns table. The SQL query to use is as follows:

SELECT BuildName AS "BuildName",
SUM(PassedCount) AS Passed,
SUM(FailedCount) AS Failed,
SUM(NotExecutedCount) AS NotExecuted,
SUM(PassedCount   FailedCount   NotExecutedCount) AS "Amount of Tests Run" 
FROM TM_ExecDefinitionRuns WHERE ${VERSION|"3.0"}=VersionName AND ${PRODUCT|"Demo Product"}=ProductName GROUP BY BuildName

Please note:
If you ran an execution multiple times the above query will include the results from all those executions in its result set.