Here you will find Technical Stuff about JDEdwards EnterpriseOne, Oracle, SQL Server, Solaris, AS/400, Linux, UDB/DB2, unix, WebSphere OAS, Weblogic.
Thursday, January 26, 2017
JDE Last time user logged in successful
SQL -
select t1.SHUSER User_Name, MAX(t1.SHUPMJ) LastLogin_Date
from SY910.F9312 t1, SY910.F98OWSEC t2 where t1.SHEVTYP = '01' and t1.SHEVSTAT = '01' and
t2.SCEUSER='01' and t1.SHUSER=t2.SCUSER
