It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×10,826

question asked: Aug 20 '09, 4:33 p.m.
question was seen: 5,411 times
last updated: Aug 20 '09, 4:33 p.m.

Related questions

FAQ - How this Forum works

Custom report on users in RTC 2.0

0
Santhosh Thenmozhi Rajendran (71●19●10) | 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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
James Moody (3.3k●2●4) | 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.


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.