Is there a way to get a list of users by project?

  • Questions
  • Is there a way to get a list of users by project?
Question ID: 104369
3
0

Is there a way to get a list of users by project?

Marked as spam
Posted by (Questions: 23, Answers: 1)
Asked on May 24, 2011 11:04 am
5 views
Answers (1)
3
Private answer

There is not a report in QC, but you can have your DBA run a SQL against the master qc database/schema (qcsiteadmin_db) to get the information.

SELECT
USER_NAME,
PROJECT_NAME
FROM
td.USERS_PROJECTS
INNER JOIN td.USERS ON USERS_PROJECTS.USER_ID=USERS.USER_ID
INNER JOIN td.PROJECTS ON USERS_PROJECTS.PROJECT_ID=PROJECTS.PROJECT_ID

![alt text][1]

[1]: /upfiles/USERS_by_Project.jpg

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on May 24, 2011 1:14 pm
Thank You, that is exactly what I needed
( at May 24, 2011 1:16 pm)