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
 
I would restart JDE services and see if your F9312 records start appearing after that.
 
Back
Top