sql query to get list of project admins in alm

  • Questions
  • sql query to get list of project admins in alm
Question ID: 107139
0
0

Need to pull the project admin details from the project and please help.

Marked as spam
Posted by (Questions: 23, Answers: 3)
Asked on October 6, 2016 10:04 am
591 views
Answers (1)
0
Private answer

If you want to get a list of Project Admins, you can do that from Site Administration as follows:
From Site Administration (must have Site Admin permissions) goto Site Projects tab

Select the project in question and click the + sign to expand the view of the tables

Run the following query from the USERS table:

Replace the default query SELECT * FROM USERS with

SELECT US_USERNAME, US_GROUP, GR_GROUP_NAME

FROM USERS, GROUPS

WHERE US_GROUP LIKE '1%' AND GR_GROUP_NAME = 'TDADMIN'

The list of items returned will include the User Name of all the users in the TDAdmin group which is the name of the Project Administrators group and what the 1 in the first character of the US_GROUP field signifies.

Hope this helps!

Marked as spam
Posted by (Questions: 1, Answers: 216)
Answered on May 12, 2017 8:17 pm
EyeOnTesting