Username and Full Name report for a Project

  • Questions
  • Username and Full Name report for a Project
Question ID: 104943
1
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 (Questions: 122, Answers: 3)
Asked on April 4, 2013 6:47 pm
21 views
Answers (2)
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 (Questions: 3, Answers: 168)
Answered on April 4, 2013 6:49 pm
0
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 (Questions: 0, Answers: 613)
Answered on April 30, 2013 9:39 pm