Calculating average response times for SilkPerformer runs from SCTM database?

0 Likes

Average values can be calculated indirectly with MeasureSum/CountMeasured using the following SQL query: 

SELECT
  m.*, MeasureSum/CountMeasured AverageValue, u.*
FROM
  TM_PerfReportMeasure m
JOIN
  TM_PerfReportUserType u ON m.UserTypeID_fk = u.UserTypeID_pk
JOIN
  TM_PerformerResults r ON r.PerfReportID_fk = u.ReportID_fk
WHERE
   r.TestDefExecID_pk_fk = 0   

Comment List
Anonymous
Related Discussions
Recommended