User login history SAP Business One

[Former Member]

Dear All,

Does anybody know about a query which would result SAP B1 user logins - in historical

order?

Thank you!

Best regards,

Balazs Barta

SAP B1 consultant

Hungary

[Former Member · Accepted solution]

Hi Balazs,

There is no such query available since the authorization table is hidden from all users including superuser. The OUSR table can only hold the current user login info. No history records.

What you can do is try to do something in your SQL server directly to get such information to log all user login history.

Thanks,

Gordon

[chrismilnetw]

If you are a Superuser you can use Query Generator on table USR5

SELECT *

FROM USR5 T0

WHERE T0.[UserCode] = 'userid'

ORDER BY T0.[Date] desc