Access Log – PeopleSoft

I came across a requirement where I needed to find out when a user had last logged into PeopleSoft. The record PSACCESSLOG was useful, it stores all of the following:


PSACCESSLOG
OPRID: The users operator ID
LOGIPADDRESS: The users IP address
LOGINDTTM: A timestamp showing when the user logged in
LOGOUTDTTM: A timestamp showing when the user logged out
PT_SIGNON_TYPE: The signon type


Find Last Login Date for User:

SELECT * FROM PSACCESSLOG WHERE oprid = '<OPERATOR ID>' ORDER BY effdt DESC;

Find all logins since 1st March 2014:

SELECT * FROM PSACCESSLOG WHERE TO_DATE(CAST(logindttm AS DATE), 'dd/mm/yy') >= TO_DATE('01/03/2014', 'dd/mm/yy');

PSACCESSLOG - Login History in PeopleSoft