Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

List of logging of users

Hi Experts,

I need a list containing when and who has logged in SAP.Is it possibble to show or does it need any workround or other solution (sql..) to show out?

I mean 08.01.2008 10:00 -manager

08.02.2008 12-05-manager etc.

Thank you in advance.

replied

Information about users are in OUSR table. The LastLogin field stores only last login information (not history). For receiving history without programming you should create one table in db, for example LoginHistory with fields Date (datetime) and User (varchar) and through job created on sql server check the OUSR table, if there are some changes in lastlogin column and if yes, insert new record into table LoginHistory. The job should be like

insert LoginHistory

(

select o.lastlogin, o.U_name, from ousr o where o.lastlogin not in (select Date from LoginHistory where User = o.U_name)

)

hope it helps

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question