QC/ALM Query to find user list from past month?

  • Questions
  • QC/ALM Query to find user list from past month?
Tags:
Question ID: 104658
1
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 (Questions: 359, Answers: 26)
Asked on October 22, 2012 10:56 am
21 views
Answers (2)
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 (Questions: 0, Answers: 707)
Answered on October 22, 2012 10:59 am
Excellent. I now have my report!
( at November 2, 2012 2:18 pm)
0
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 (Questions: 30, Answers: 35)
Answered on July 27, 2018 3:40 am