It's all about the answers!

Ask a question

BIRT Usage by User Report


Rick Crosby (111) | asked Jun 24 '15, 11:58 a.m.
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!


Register or to post 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.