Last Date Logon to JDE

Hi JDEList

Is there is a way to show the last date a JDE user logged on to JDE. We need to be able to produce a listing of JDE users which have not logged in for over 90 days

Any feedback will be greatly appreciated

This has been covered a few times, but have you tried turning on Security History in the Enterprise Server's JDE.INI file, and checking the records in F9312?

Note that these may not exist in your version of E1 (whatever that may be).

[ QUOTE ]
This has been covered a few times, but have you tried turning on Security History in the Enterprise Server's JDE.INI file, and checking the records in F9312?

Note that these may not exist in your version of E1 (whatever that may be).

[/ QUOTE ]

Hi there

Thanks for your prompt response.

We are currently on E1 8.11 SP 1

Nageeb

Then you should be able to turn on Security History (History=1 under [SECURITY] in the Enterprise Server's JDE.INI file), and look at the records in F9312 (System -811 data source).

Thanks Ken

And when you have data in F9312, try runnig this MSQL statement (written for 8.12) to get your users last login, in descending order:
SELECT SHUSER LSUSER, Max(SHUPMJ*1000000+SHUPMT) LSMATHVAL
FROM JDE812.SY812.F9312
WHERE (SHEVTYP = '01') AND (SHEVSTAT = '01')
GROUP BY SHUSER