Last login for projects by user name

Tags:

Question ID: 106435

Looking for a method to check last login date for projects as we have quite a few and I want to see which are active and which are not really. Would like to see project and which user last logged and when if possible.

Marked as spam

Posted by coltsfan12 (Questions: 56, Answers: 1)

Asked on October 7, 2015 6:14 pm

446 views

Answers (2)

▲

▼

✔

Private answer

Hello,

The below query will pull domain name, project name, user name and show the last login time stamp.

Run it against your site admin schema directly (for example qcsiteadmin_db).

select PROJECTS.DOMAIN_NAME, PROJECTS.PROJECT_NAME, USER_NAME, MAX(SESSIONS_HISTORY.START_TIME)
from qcsiteadmin_db.td.PROJECTS
left outer join qcsiteadmin_db.td.SESSIONS_HISTORY SESSIONS_HISTORY
on (PROJECTS.PROJECT_NAME=SESSIONS_HISTORY.PROJECT_NAME) AND (PROJECTS.DOMAIN_NAME=SESSIONS_HISTORY.DOMAIN_NAME)
GROUP by PROJECTS.DOMAIN_NAME, PROJECTS.PROJECT_NAME, USER_NAME

Marked as spam

Posted by mrwhite (Questions: 1, Answers: 116)

Answered on October 7, 2015 6:17 pm

▲

▼

Great query, was exactly what was needed.

(mrwhite at October 7, 2015 6:29 pm)

▲

▼

✔

Private answer

Hi MrWhite,

I am using HP ALM 11.52 edition and i haven't seen SESSION_HISTORY table in this edition than how can i retrieve users last login details please assist me.

Thank you.

Marked as spam

Posted by praveen-hpqc (Questions: 11, Answers: 7)

Answered on August 26, 2016 1:59 pm

▲

▼

Table is in SQL is either td.SESSIONS_HISTORY (if doing qc authnetication) or dbo.SESSIONS_HISTORY (if doing windows authentication) and is located under the site admin schema database. By default that would have name of qcsiteadmin_db. Possible it is renamed in your instance. Table exists in ALM 11.52.

(praveen-hpqc at August 26, 2016 2:04 pm)

« Back

Please log in to participate..

Forgot your password?

Last login for projects by user name

Login

Forgot your password?