List of logging of users
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.
Petr Verner 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
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