How to get User last login date to alm by using query
| ♥ 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.
Marked as spam
|
Posted by |
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'' In place of qcsiteadminUAT type your actual qcsiteadmin_dbname Marked as spam
 Posted by prathap7475 (Questions: 23, Answers: 3) Answered on August 31, 2016 11:53 am
|