TestRunQueries
This feature is available in Enterprise and Ultimate editions.
Test Runs
select DateKey, TestSuiteName, count(TestRunKey) as TestRunCount, sum(Passed) as Passed, sum(Failed) as Failed, sum(NotRun) as NotRun from Fact.TestRun TR join Dim.TestSuite TS on TR.TestSuiteKey = TS.TestSuiteKey join Dim.Project P on P.ProjectTestSuiteKey = TS.TestSuiteKey join Dim.AssetState S on TS.TestSuiteAssetState = S.AssetStateName where ProjectName='Release 1.0' and AssetStateName = 'Active' group by DateKey, TestSuiteName order by DateKey