It's all about the answers!

Ask a question

Custom report on users in RTC 2.0


Santhosh Thenmozhi Rajendran (711910) | asked Aug 20 '09, 4:33 p.m.
HI,

I am using RTC 2.0. I want to generate a report on the users of a project and their work environments, like for a project how many users are there and how many total hours they work.
I tried all the snapshots in the datawarehouse but couldn't find the required data.
Can you please mention the table which holds these details or can you direct me to some resource which has these details.

Thanks,
Sany

One answer



permanent link
James Moody (3.3k24) | answered Aug 21 '09, 10:54 a.m.
JAZZ DEVELOPER
On 8/20/2009 4:37 PM, trsanthosh wrote:
HI,

I am using RTC 2.0. I want to generate a report on the users of a
project and their work environments, like for a project how many
users are there and how many total hours they work.
I tried all the snapshots in the datawarehouse but couldn't find the
required data.
Can you please mention the table which holds these details or can you
direct me to some resource which has these details.

Thanks,
Sany


Sany,

I'm assuming you're using RTC 2.0.

The COMMON_SNAPSHOT has a view called LIVE_CONTRIBUTOR which provides
live information (from the repository, not the data warehouse) on all
contributors defined in the repository. It doesn't, however, have
information about total hours worked, etc. In 2.0.0.1 we've added this
resource capacity information (both live and historical) to the
APT_SNAPSHOT.

Hope this helps.

james
RTC Reports Team Lead

Your answer


Register or to post your answer.