How to find ‘When the peoplesoft user accessed peoplesoft last time’?-

Jenny

Active Member
Hi,

How to find ‘When the peoplesoft user accessed peoplesoft last time’?- Please help

Win 2000, MS SQL SERVER 2000, EOne8.10

Thanks
 
Jenny, here's what I use for find out users whose logon failed. You can modify it to find out when the last time they signed on. The only thing is that that logging must be turned on in order to capture the records in the file.

SELECT SY810_F9312.SHUSER, SY810_F9312.SHEVTYP, SY810_F9312.SHEVSTAT, SY810_F9312.SHMKEY, SY810_F9312.SHUPMJ, SY810_F9312.SHUPMT
FROM SY810_F9312
WHERE SHEVTYP='01' AND SHEVSTAT='02';
 
Go to User Security and select Security History on the Form exit bar. Security logging must be turned on for entries to be recorded.

Dave Rammer
Sheboygan County

EO810 8.93N1 Oracle 9.2.0.5 HP-UX 11i
Citrix XP SP3/FR3
 
?

Doesn't the P00960 provide info on machines? If you have found another use for it, please dish the details!
 
Thak you very much. If i want to log in this process,
In JDE.ini which field we need to change.
 
Robert

P00960 also has what user id signed onto what machine last. If a machine is used by more that one person then it wouldn't be helpful. Most of our users are fat client.

Patty
 
On your enterprise server, in the [SECURITY] section of the JDE.INI, change to History=1
 
Back
Top