It's all about the answers!

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

×42,862

question asked: Feb 16 '11, 9:57 a.m.
question was seen: 6,142 times
last updated: Jan 08 '13, 5:23 p.m.

Related questions

RTC Database Query - Users by role by project area

0
David Doughty (181●22●19) | asked Feb 16 '11, 9:57 a.m.
is anyone familiar with the database table structure for RTC?

We're looking to extract users by role by project area. Primarily to generate a contact list of admins and/or stateholders.

If someone has investigated the RTC/jazz structure then that would be a bit of a head start.

thanks
dD

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Sean G Wilbur (872●2●24●21) | answered Feb 16 '11, 5:24 p.m.
JAZZ DEVELOPER
Check out the LIVE_SNAPSHOT com.ibm.team.process.ProjectArea table for PA memberships and admins, LIVE_SNAPSHOT again table com.ibm.team.process.TeamArea for TA memberships.

Not sure how to find the user roles, so if someone could chime in with that piece of the puzzle I would be able to finally run a report to mash this together.

-Sean
0
permanent link
Luba Tchernaia (1) | answered Dec 19 '12, 3:38 p.m.
Hi Sean, please clarify names of tables. I connected to RTC Oracle tables and don't see such tables in CCM schema.

Thank you
0
permanent link
Ralph Schoon (63.4k●3●36●46) | answered Dec 19 '12, 5:00 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
 Sean talks about the data warehouse. You should not access the cc, database directly anyway. You can use the API to access the information you are looking for. See https://rsjazz.wordpress.com/2012/12/09/analyzing-a-aroject-areas-members-and-roles-using-the-plain-java-client-libraries/ for an example.
0
permanent link
Paul Addy (6●1●1) | answered Jan 08 '13, 12:48 p.m.
 Hi Ralph,

Do you have a working example for such an extraction or at least a working example of using the API? We now have 150+ project areas in our RTC server, extracting the list of Scrum Masters and Stakeholders would be practical and save us lots of time.

Is their some kind of support to interact with the API? We are unable to execute the examples...

Thanks,
Comments
Ralph Schoon commented Jan 08 '13, 5:23 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

As alswered above: http://rsjazz.wordpress.com/2012/12/09/analyzing-a-aroject-areas-members-and-roles-using-the-plain-java-client-libraries/ and http://rsjazz.wordpress.com/2013/01/08/maintaing-user-photos-with-the-plain-java-client-libraries/ and other posts have a reference on how to set up the Plain Java Client Libraries outlined in https://jazz.net/library/article/807

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.