Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 28, 2017 at 08:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2017 at 07:31 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded