• 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!

Usage Logs for accounts with a specific role

Euroboy

Active Member
Hi All

Could someone tell me how i can get the usage logs for all accounts for a specific user role, or all Users?
Our main guy who would have done this isn't available and the auditors want this information.

Thanks in advance.
 

DSauve

Legendary Poster
Provided that Security History has been turned on, you should be able to go into User Security (P98OWSEC) using form "C" to find the history of logins and logoffs by user.
 

Richard Lee

Active Member
mine enable f9312 - security history for 2 yrs due to corp auditor request too.
make some sql queries to xref f9312 with F95921 [Role Relationships Table].

find my previous sql for ur ref.
rg,
Richard

/* JDE USER ROLE MAPPING , 2017-1-9 */
SELECT USROLES, ULUSER, ULAN8, LOGINS_YTD, MCDC
FROM SY900.F0092
INNER JOIN SY900.F98OWSEC ON SCUSER=ULUSER AND SCSECUSR='JDE' AND SCEUSER='01'
LEFT JOIN PRODDTA.F0101 ON ABAN8=ULAN8 LEFT JOIN PRODDTA.F0006 ON MCMCU=ABMCU
INNER JOIN ( SELECT RLTOROLE, LISTAGG(TO_CHAR(TRIM(RLFRROLE)), '; ') WITHIN GROUP (ORDER BY 1) USROLES FROM SY900.F95921 WHERE RLEXPIRDATE = 0 AND RLFUROLE1='1' GROUP BY RLTOROLE) ON RLTOROLE=ULUSER
LEFT JOIN (SELECT SHUSER, COUNT(DISTINCT SHUPMJ) LOGINS_YTD FROM SY900.F9312 WHERE SHEVTYP='01' AND SHEVSTAT='01' GROUP BY SHUSER) ON SHUSER=ULUSER
ORDER BY 1,2
 
Top