Support Users Login Details

[DipenShah]

Hello,

Anyone know how to get Support users Data for Login And Logout details in SAP B1?

Thanks and Regards,

Dipen Shah

[MD1]

try this

select
t0."USER_CODE" as "SAP ID",
t1."Name" as "Department",
t0."lastLogin" as "Login Date",
t0."LstLogoutD" as "Logout Date",
t0."LastPwdSet" as "Password Change Date",
t0."LstPwdChB" as "Password Change By"

from ousr t0
INNER JOIN oudp T1 ON T0."Department" = t1."Code"
where t0."LstLogoutD" is not null

order by t0."USER_CODE",t1."Name"

Thanks

Danish

[hdolenec]

You need OSUL table or standard support user log report (Administration => Licence => Support User Log).

[jitin_chawla]

Hi,

Are you looking for the data details in the Access Log window?

These are in OUSR and USR5 table.

Else share a screenshot of which support user are you checking.

regards,

Jitin