Reports tables
Hi,
I need to provide reports about files changes in the repository. Is there a way to have a report table of the changes (not Work-items. I need file names) ? I saw that there is a graph of 'project activity' but I need something more like a table with names. I heard about RRDI but don't know if it can help me with reports of files (not work-items). Thanks. |
2 answers
May I first point you to the Data Warehouse Snapshot Schemas , look at the 'SCM Snapshot' section and associated tables providing " This CLM 2011 reporting workshop provides extended information on RRDI which might be of use for you, especially in the CLM2011ReportingWorkshopIntroduction material that you can download. |
Geoffrey Clemm (30.1k●3●30●35)
| answered Apr 01 '12, 11:54 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
The data warehouse does not store SCM information at the level of detail of filenames (it stores summary information, such as number of changes). For detailed SCM information, you will want to look at the scm command line. In particular, you can often write a script to extract information via the scm command line and process the results into the form you want.
Cheers, Geoff
May I first point you to the Data Warehouse Snapshot Schemas , look at the 'SCM Snapshot' section and associated tables providing " This CLM 2011 reporting workshop provides extended information on RRDI which might be of use for you, especially in the CLM2011ReportingWorkshopIntroduction material that you can download. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.