TestingCOE

SIT Test Lab will extract the Test Set, test case name, executed on, Executed by and it status. SELECT CY_CYCLE AS "Test Set",        TS_NAME AS "Test Script Name",        TC_ACTUAL_TESTER AS "Tester",        TC_STATUS AS "Execution Status",        LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10)  AS "Execution Date" FROM TEST, TESTCYCL, CYCLE WHERE CY_CYCLE_ID = TC_CYCLE_ID AND   TS_TEST_ID = TC_TEST_ID AND CY_CYCLE_ID IN (Cycleids) High level summary of the metrics SELECT CY_CYCLE,        TC_STATUS,        COUNT(TS_NAME) FROM TEST, TESTCYCL, CYCLE WHERE CY_CYCLE_ID = TC_CYCLE_ID AND   TS_TEST_ID = TC_TEST_ID AND CY_CYCLE_ID IN (cycleids) GROUP BY CY_CYCLE, TC_STATUS ORDER BY CY_CYCLE, TC_STATUS SIT Execution Rate/Run Rate SELECT CY_CYCLE,        TC_ACTUAL_TESTER,        TC_STATUS,        LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10),        COUNT(TS_NAME) FROM TEST, TESTCYCL, CYCLE WHERE CY_CYCLE_ID = TC_CYCLE_ID

Duplicate_TestScripts_TestLab select rcyc_id as cycle_id, cycle_name, cy_cycle_id as test_set_id, cy_cycle as test_set_name, test_id, ts_name from testcycl t join cycle on cy_cycle_id = tc_cycle_id join ( select rcyc_id, rcyc_name as cycle_name, tc_test_id as test_id from release_cycles join testcycl on tc_assign_rcyc = rcyc_id -- where rcyc_name = 'MY CYCLE NAME' group by rcyc_id, rcyc_name, tc_assign_rcyc, tc_test_id having count(tc_test_id) > 1 ) multi on test_id = t.tc_test_id and tc_assign_rcyc = rcyc_id join test on ts_test_id = t.tc_test_id order by 2, 6, 5, 4 Number of Test Steps Count for not passed status. SELECT CY_CYCLE AS "Test Set",        TS_NAME AS "Test Script Name",        TS_STEPS as "Test Steps", /*Test.Steps*/        TC_ACTUAL_TESTER AS "Tester",        TC_STATUS AS "Execution Status", LEFT(CONVERT(VARCHAR,TC_EXEC_DATE,20),10)  AS "Execution Date" FROM TEST, TESTCYCL,