WorkingScripts

This question came up during the recent application security audit – how does PeopleSoft track user sign in attempts and locations.
Aside from the obvious PSOPRDEFN table there is PSACCESSLOG – this table has OPRID, LOGIPADDRESS, LOGINDTTM, LOGOUTDTTM columns that give you information about user sign on activity. LOGIPADDRESS will contain the RemoteAddr property  of  [...]