ALM Analysis Report for Number of Tests Executed per Month

  • Questions
  • ALM Analysis Report for Number of Tests Executed per Month
Question ID: 107414
0
0

We are in need of a data report in excel to display the number of tests that have been executed each month from January to December for 2016.

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on January 27, 2017 8:01 pm
7 views
Answers (1)
0
Private answer

The query below will get you the number of tests with a status of Passed, Failed, Not Completed, Blocked, or N/A with the most recent execution date, that were executed each month from January to December for 2016. You may need to tweak it some to fit your needs.

SELECT YEAR(TC_EXEC_DATE) [Year], MONTH(TC_EXEC_DATE) [Month],
DATENAME(MONTH, TC_EXEC_DATE) As 'Month Name', COUNT(TC_STATUS) As 'Test Count'
FROM TESTCYCL
WHERE TC_EXEC_DATE LIKE '%2016%'
AND TC_STATUS IN ('Passed', 'Failed', 'Not Completed', 'Blocked', 'N/A')
GROUP BY YEAR(TC_EXEC_DATE), MONTH(TC_EXEC_DATE),
DATENAME(MONTH, TC_EXEC_DATE)
ORDER BY 1,2

Marked as spam
Posted by (Questions: 2, Answers: 278)
Answered on January 27, 2017 8:02 pm