TestingCOE

Daily Status Report update. 1.         Who are all stakeholders 2.         Which stakeholder needs what data 3.         Collect the information from the all stakeholder interested on 4.         Create a template and share with the stakeholders to get the signoff. 5.         If there is a need to improve or change in the reporting style, need a confirmation from the Business/TCS Managers. Daily status report : Information Interested on : Ideal Scenario: All test cases/scripts are passed and all defects to be closed before the EOD of test execution cycle. 1.         How much work is completed/how much is pending 2.         Whether we can complete the task in time 3.         What is the percentage of the pass test scripts when compared to the base line plan 4.         Execution plan vs Actual Plan ie Baseline plan VS Forecast plan(have we complete the execution as per the plan, else how much is pending + how much needs to be completed tomorrow= is our target to c

Test-lab: 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 (cycleid) Test-Summary: 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 (cycleid) GROUP BY CY_CYCLE, TC_STATUS ORDER BY CY_CYCLE, TC_STATUS 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 AND   TS_TEST_ID = TC_TEST_ID AND CY_CYCLE_ID IN (cycleid) GROUP BY CY_CYCLE, TC_ACTUAL_TESTER, TC_STATUS, TC_EXEC_