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 perc...

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,        L...