Reporting on Source Control Artifacts from RTC
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?
Accepted answer
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.
Comments
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.