It's all about the answers!

Ask a question

Reporting on Source Control Artifacts from RTC


Nathan Hoburn (175) | asked Oct 18 '17, 11:32 a.m.

 Is there a way to generate a report based on artifacts stored in RTC source control? Is the source control data stored in the Jazz data warehouse database? If so, what Data Collection Component job(s) transfers that data to the database? 


We use JRS (with the data warehouse data source) and I have full access to the database for custom SQL reporting as I am not seeing any source control attributes in the Report Builder tool.

If JRS is not a viable option for this, would Rational Publishing Engine have the capabilities? 


Version:
Jazz 6.0.1

Accepted answer


permanent link
Kenji Sarai (96029) | answered Oct 19 '17, 3:18 a.m.

Hi Nathan,

Reports with SCM matrics information (historical trend report) are available since JRS 6.0.3.
https://jazz.net/downloads/jazz-reporting-service/releases/6.0.3?p=news
(see File stream (source control) trends)

The SCM data itself has been loaded into data warehouse prior to 6.0.3 by following DCC job
- Change and Configuration Management - Source Control
- Change and Configuration Management - Source Control Metrics
- Change and Configuration Management - Source Control Dimensions
(There is no SCM in ODS data)

So it is possible to create the same kind of reports in 6.0.1 by manually editing SQL query in Advanced tab.

Nathan Hoburn selected this answer as the correct answer

Comments
Geoffrey Clemm commented Oct 19 '17, 3:53 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 Note that only limited kinds of SCM data are currently loaded into the data warehouse so you would need to verify that the kind of data you are looking for is currently being loaded.   Additional kinds of data will be added to the LQE index (which is where versioned information is stored) in future releases.

Your answer


Register or to post your answer.