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

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.

Marked as spam
Posted by (Questions: 11, Answers: 7)
Asked on August 28, 2016 6:42 pm
Answers (1)
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 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

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Scroll to Top