Skip to main content
System StatusContact Support Agility Community


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