Skip to Content
1

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

Aug 28, 2017 at 07:35 AM

97

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Prithviraj Rajpurohit Aug 28, 2017 at 08:38 AM
2

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 05, 2017 at 07:31 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded