How to determine the SiteAdmin user used to install ALM?
Question ID: 108480

We are preparing for our update and as we currently have LDAP authentication as our main authentication protocol and to manage user accounts, we are trying to find out the SiteAdmin account used to install. That account was used by an employee that is no longer with the company to install the version we have currently. We were told we would need this user information during the install so how do we find it??


Marked as spam
Posted by (Questions: 379, Answers: 35)
Asked on July 10, 2018 3:10 pm
Answers (1)
Private answer

Hi HomerJ,
There are a few easy ways to determine the admin account. First you can open the qcsiteadmin_db and within the User_Roles table find all UR_User_ID that belong to Ur_Role_ID = '10' then cross reference those Ur_User_ID against the Users table. The Role_ID 10 is for admin accounts and when you see the accounts that have this role assigned within the Users table you will be able to identify the user that is a siteadmin only as it will have none of the associated LDAP information.

You can also see the following post: for running a query within this same DB to reveal the admin users.

Hope this helps,

Marked as spam
Posted by (Questions: 0, Answers: 770)
Answered on July 10, 2018 3:25 pm

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top