Try This.....

select DISTINCT USER_NAME from td.users

WHERE USER_NAME NOT IN (

select DISTINCT USER_NAME from td.sessions_history WHERE END_TIME > '12/31/2013 11:59:59 PM'

) ORDER BY USER_NAME ASC;

@praveen_hpqc

Welcome to EyeOnTesting.

In your response you mention that you do not have a SESSION_HISTORY table. However, the table name in the answer above is SESSIONS_HISTORY (with an ''S''). This table does exist in ALM 11.52 in the qcsiteadmin_db database schema. I hope this helps.

**see screenshot below:**

![alt text][1]

[1]: /storage/temp/480-capture.jpg

Hi SammyH,

In hp alm 11.52 edition don't have SESSION_HISTORY TABLE, could please tell me any other way to pull out last login date of all users.

Thank you