How can I find a list of the active/ inactive user accounts within ALM/QC?

  • Questions
  • How can I find a list of the active/ inactive user accounts within ALM/QC?
Question ID: 105340
0
0

Hello,
I would like to know how I can create list of the inactive/ active user accounts within ALM/QC? I can see the users within the SITE ADMIN Site Users tab, but we have lots of users and when I look at the users list within the projects within the Site Admin I don’t see all the users. How can I create this list?

Thanks in advance,
HomerJ

Marked as spam
Posted by (Questions: 353, Answers: 29)
Asked on March 26, 2014 4:59 pm
55 views
Answers (1)
2
Private answer

Hi HomerJ,
Within the site admin the user listing that you see for the projects is the user base for that project only (and is a smaller subset of the entire user base sen under the Site Users tab).

In order to generate this query, your user accessing Site Admin will need to the correct permissions to query the DB, but you would rung this within a project table (it doesn't matter which one) within any project:

SELECT * FROM .td.USERS WHERE US_IS_ACTIVE = 'Y'

The above query would return a list of the active accounts within your ALM/QC system (replace the Y with an N to return a list of the inactive user accounts within the ALM/QC instance). Just makes sure and replace the qcsiteadmin_db within the <> with your correct qcsiteadmin_db name and omit the <>.

You can also run the same query on the DB itself, or have your DB admin run the query to generate the list.

Hope this helps.
Dan

Marked as spam
Posted by (Questions: 0, Answers: 748)
Answered on March 26, 2014 5:05 pm
Thanks. Your explanation makes sense and was exactly what I was looking for.
( at March 26, 2014 5:06 pm)