Username and Full Name report for a Project
Question ID:
104943
| ♥ 0 |
I am needing some assistance in extracting the username and the full names from a specific project. We are going to be reviewing the users in the project and want to be able to show on a report with the full name. I am not seeing any options in the project for exporting the user info. Any help would be appreciated.
Marked as spam
|
Posted by Answers (2)
|
Private answer
If you have access to the database, you can use the below query to pull this info from the site admin database (qcsiteadmin_db). Just adjust the project name on the bottom line to match the project name you are needing the data for.
SELECT USERS.USER_NAME, USERS.FULL_NAME, PROJECTS.DOMAIN_NAME, PROJECTS.PROJECT_NAME
FROM td.USERS, td.USERS_PROJECTS, td.PROJECTS
WHERE USERS_PROJECTS.PROJECT_ID = PROJECTS.PROJECT_ID AND
USERS_PROJECTS.USER_ID = USERS.USER_ID AND
PROJECTS.PROJECT_NAME = 'ALM_Demo_Project'
Marked as spam
 Posted by jafar (Questions: 3, Answers: 168) Answered on April 4, 2013 6:49 pm
|
|
|
Private answer
Another useful posting....http://eyeontesting.com/questions/2349/how-to-get-list-of-users-across-projects-including.html Marked as spam
 Posted by sammyh (Questions: 0, Answers: 613) Answered on April 30, 2013 9:39 pm
|