Need SQL Query in ALM for Daily Status Report
I need to have a query with the following tests.
Planned Preapration date for test cases from Test plan,Actual Creation date from Test plan ,Planned execution from test lab and Actual Execution from test lab with the test cases count.
Lets say if day by day graph.
For this particular day this many cases planned and created and same applies to execution also for System/WORK Request/Release wise.
Thanks in advance...