Created On:  27 April 2012

Problem:

How do you report on currently active projects in CaliberRM?

Resolution:

Please download the VReport.zip attached to this article.  For ease of use please extract the file and folder structure to the root of C:\.

To run the report edit the ProjectCreationReport.bat file check that all the paths are correct:

"C:\\Program Files\\Java\\jre6\\bin\\java.exe" -Xmx1G -classpath "C:\VReport\jars\jvi7.0.1-jdk1.4.jar;C:\Program Files\Borland\CaliberRM SDK 2008\lib\CaliberRMSDK100.jar;.\\classes;C:\\VReport" Search SQMDB C:\\VReport\\ProjectCreationReport.csv localhost admin admin

As you can see above, check that you have a version of the Java Runtime Environment installed and ensure the path is correct.  Ensure that the database name is correct and the last three arguments are your CaliberRM server name/ipaddress and username + password for CaliberRM.

The batch file will create a csv file with all the projects plus baselines in CaliberRM giving you their creation date and last modified date.
Incident #2567799