BIRT Usage by User Report
Trying to write a RTC BIRT report to get update stats on Work Items by user.
Managed to extract the Updates by using
Data source - WORKITEMS_SNAPSHOT
Table - WORKITEM_CHNGS
This table appears to contain all the updates to WorkItems, but the attribute CONTRIBUTOR_NAME refers to the owner of the Work Item and not the user performing the update. I cannot find anywhere how to get details of the user that is actually performing an update.
The only detailed schema reference for the Datawarehouse Snapshots I can find is
https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20
But this is for V2 of RTC and we are currently running 5.02
Anyone know where I can find this information or details of the snapshot schemas for V5.02?
Thanks
|
Be the first one to answer this question!
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.