It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,880
×12,005

question asked: Mar 20 '14, 6:24 a.m.
question was seen: 5,007 times
last updated: Mar 20 '14, 12:16 p.m.

Related questions

BIRT/Insight: How to extract all projects and all of its users.

0
Rhishikesh Patil (13●1●18●27) | asked Mar 20 '14, 6:24 a.m.
Hello,

We are using RTC 4.0.1 and want to generate report with BIRT or Insight. We want to display project name and all of its users and count of users per project. I tried with BIRT on LIVE_CONTRIBUTOR table in COMMON but it list only users present at team area level. It wont display users under project area team which is created by default.

I tried with query studio but can't find correct table in ODS and join to get this data. Please advice on this.

Thanks in advance
Regards,
Rhishikesh Patil

One answer

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Mar 20 '14, 12:15 p.m.
edited Mar 20 '14, 12:16 p.m.
Hello Rhishikesh,

the data items that you need to use for your reports are the following:
  • Operational Data Store > Project Area > Project > Name (labeled Project)
  • Operational Data Store > Project Area > Project Related Resources > Name (labeled User)
For better visualization select the columns for the Project and click the Group icon in the toolbar
For a count, select the User column and push the Summarize button in the toolbar

Best Regards,

Francesco Chiossi

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.