Is there any Table in SAP to find out Date and time when a USER ID logs in and logs off?

[ganesh_srini]

Hi

Can someone help us understand if there are any tables/T-code where we can see the date and time when a user logs in and logs out?

I cannot use SM19 to pull the details as the logs are not activated and USR02 gives the details of last login only.

STAD and ST03 gives me details only regarding Response times.

Thanks

Ganesh

[prithvirajr]

Hi Ganesh,

AFAIK the best way to achieve this is, activation of audit logs i.e. SM20 and SM19, no other way to view the history.

Regards,

Prithviraj

[harsha_artani]

Hi Ganesh,

without sm19 audit log enable it is difficult to get the data, however you can get the last login time from usr02.

But, If your DB admin can retrieve a save of the database from that day then table USR02 will hold a little more information for you. It will contain last login times for that day. If your system backup policy happened to have saved the contents of folder "/usr/sap/<SID>/<instance>/data" then you potentially have access to all the data you require.

But that really hectic job.