Custom report on users in RTC 2.0

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