Wednesday, August 30, 2017

Security -> Processing Option Type '5'

Field Mapping with F00950



Change –  FSCHNG
Prompt for Values -  FSVWYN
Prompt for Version – FSATN2
Prompt for Data Selection – FSIOK AND FSIUPT
Modify Data Selection - FSATN1
Full Access Data Selection - FSICPY

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
GROUP BY t1.SHUSER