Applies To:
HP QC 10.0 and maybe others, SQL Database
Issue:
The DBA has no idea who the site admin is, but has access to the qcsiteadmin_db database.
Solution:
The following query, when executed against the site admin database, will return all the user who have Site Admin access.
Select * From td.USERS u Join td.Users_Roles ur on u.USER_ID = ur.UR_USER_ID