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