How to get User last login date to alm by using query

  • Questions
  • How to get User last login date to alm by using query
Question ID: 107078
0
0

Hi All,

I tried to get last login date of all users in HP ALM 11.52 by using SESSION_HISTORY table but user sessions are more query exceeds excel records limit now question is how can i get user last login date ONLY records like User name ,Full name, Last login date please assist me.

Thank you in advance.
Praveen

Marked as spam
Posted by (Questions: 11, Answers: 7)
Asked on August 28, 2016 6:42 pm
107 views
Answers (1)
0
Private answer

Hey @praveen_hpqc try and modify this query based on your requirement and let me know the result

select a.USER_NAME ''User_Name'', a.PROJECT_NAME ''Project_Name'', MAX(a.START_TIME) ''Last Login Date and Time'', COUNT(a.USER_NAME) ''Total Login Count''
from qcsiteadminUAT.td.SESSIONS_HISTORY a where START_TIME >='2016-01-01'
group by a.USER_NAME, a.PROJECT_NAME order by a.PROJECT_NAME

In place of qcsiteadminUAT type your actual qcsiteadmin_dbname

Marked as spam
Posted by (Questions: 23, Answers: 3)
Answered on August 31, 2016 11:53 am