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:
Note #1: I didn't restart the JDE services.
Note #2: The user access the ERP by the Web
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