Community in read only mode June 18 & 19
This community will be set in READ ONLY mode for a while on Tuesday June 18 into Wednesday June 19 while we import content and users from our Micro Focus Forums community site. MORE INFORMATION
ALMINFO Trusted Contributor.
Trusted Contributor.

Need SQL Query in ALM for Daily Status Report

Hi ,

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





The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.