• JDELIST is celebrating its 20 year anniversary today!
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Login History on Web Access

haetten

Member
Hi!

I've enabled the login/logoff history by adding the line History=1 on the [SECURITY] section of the JDE.INI. However, the login/logoff history (SHEVTYP='01') is not being recorded on the F9312 table.

I've created the query below to check:

Code:
SELECT  
ULUSER Username, 
ABDC Fullname, 
(CASE WHEN SCEUSER = '01' THEN 'NÃO' ELSE 'SIM' END) Disabled, 
TO_CHAR(TO_DATE(MAX(SHUPMJ)+ 1900000, 'YYYYDDD'), 'DD/MM/YYYY') Last_login 

FROM SY900.F0092  

LEFT JOIN PRODDTA.F0101 ON ULAN8 = ABAN8 
LEFT JOIN SY900.F98OWSEC ON ULUSER = SCUSER 
LEFT JOIN SY900.F9312 ON ULUSER = SHUSER AND SHEVTYP = '01' AND SHEVSTAT = '01' 


GROUP BY ULUSER,ABDC,SCEUSER 
ORDER BY ULUSER
;
Note #1: I didn't restart the JDE services.
Note #2: The user access the ERP by the Web
 

DSauve

Legendary Poster
I would restart JDE services and see if your F9312 records start appearing after that.
 
Top