How to get all the users last login date in Agile 9.3.6
Hello
Please check user_usage_history table. It has the login_time and logout_time
This might help
– Raj
The following may help.
SELECT
A.LOGINID,
A.EMAIL,
A.LAST_NAME,
A.FIRST_NAME,
A.ENABLED,
A.DATE_CREATED,
MAX(B.LOGIN_TIME)
FROM
AGILE.AGILEUSER A
LEFT JOIN AGILE.USER_USAGE_HISTORY B ON (A.LOGINID = B.USERNAME)
WHERE
A.ENABLED = 1
GROUP BY
A.LOGINID, A.EMAIL, A.LAST_NAME, A.FIRST_NAME, A.ENABLED, A.DATE_CREATED
Regards,
Drew
