QC/ALM Query to find user list from past month?
Question ID:
104658
| ♥ 0 |
Can I run a query against my qcsiteadmin_db database to find out a list of users who’ve logged into QC for the past 30 days?
Marked as spam
|
Posted by Answers (2)
|
Private answer
Give this a try: Select user_name, max(end_time) as last_login from qcsiteadmin_db.td.sessions_history where end_time > system - 30 Marked as spam
 Posted by rickjames (Questions: 0, Answers: 771) Answered on October 22, 2012 10:59 am
|
|||
|
Private answer
If anyone is looking for a query to run in Oracle db, you should try the below query. > Select Domain_name, Project_Name, user_name, max(end_time) as last_login from qcsiteadmin_db.sessions_history where end_time > SYSDATE - 30 and user_name not like '_system%' group by domain_name, Project_Name,user_name, end_time Marked as spam
 Posted by miraclefren2 (Questions: 30, Answers: 35) Answered on July 27, 2018 3:40 am
|