Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Is there a SilkCentral Test Manager report to display the latest SilkPerformer results from a given SilkPerformer test definition?

Is there a SilkCentral Test Manager report to display the latest SilkPerformer results from a given SilkPerformer test definition?

Problem:

Is there a SilkCentral Test Manager report to display the latest SilkPerformer results from a given SilkPerformer test definition?

Resolution:

SilkCentral Test Manager 2008 not only executes SilkPerformer scripts but also parses the result files and stores them in the database.

This basic report will present the latest SilkPerformer results from a given SilkPerformer test definition.

Create a new report on SCTM and use the following SQL:

SELECT perfReport.*, perfMeasures.*

FROM RTM_V_LatestTestDefExecResults as execRuns

INNER JOIN TM_PerformerResults AS perfRes ON (perfRes.TestDefExecID_pk_fk = execRuns.TestDefExecID)
INNER JOIN TM_PerfReport AS perfReport ON (perfReport.ReportID_pk = perfRes.PerfReportID_fk)
INNER JOIN TM_PerfReportMeasure AS perfMeasures ON (perfMeasures.UserTypeID_fk = perfReport.ReportID_pk)

WHERE execRuns.TestDefName = ${testDefName | "PetStore Find Fish" | Test Definition Name}


Then upload the attached BIRT template (LatestResultforPerfTestDefinition.rptdesign) to your report.

Now all you have to do is create a SilkPerformer test definition, run it once and then use the test definition name as the parameter for your report.

Reference:
http://bkn.borland.com/forums/thread.jspa?forumID=45&threadID=16621

Related documents:


Old KB# 25081

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:52
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.