Champion Level 3There's no way to report that inside of Scale with the current reporting functions but it can still be done by exporting to Excel. We just need to make sure that we export all test cases (so that means that they must all be associated with test cycles).
Assuming that all your test cases are in test cycles, and that all your test cycles are associated to a test plan, you can run a report - I use 'Test execution results (list)' for this purpose. You can choose to filter by test plan or by test cycle if you select all test cycles individually. Make sure you click the 'All test executions' option button and then run the report. You will now have a report that shows all test cases and their execution status. Next we export the data (top right-hand corner button) to a dataset which you can then analyse in Excel using date ranges and counts of executions to get your stats.
That should work but let me know if you hit any problems.
Thanks for the work around. too bad that we cannot have reports based on just test case repository. all the reports are based on Executions only. we have filters at the test cases but would need to export them to excel and write macros to take things further.
My current scenario is we have test cases accumulated over a period of time. (25K+). wanted to maintain these for effectiveness. So the approach is to query on last executed date for each and accordingly filter them out for archival / obsolete.
one approach I see from your work around is pull in batches to test cycle and pull the execution report.
