Skip to Content
avatar image
Former Member

Know about user activity

Hello,

We have the need of knowing the following data about users:

1.- How many time is the user conected every day.

2.- Which days do users connect.

We have tried with the audit, sm19, but the information we need is not there.

I know with STAT/STAD transaction we can seethese data, but it will be a lot of daily work and we cannot aim that time.

Do you know any other way to do it? Something like some tables to extract the data and make a report?

Thanks and best regards,

Alfonso.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 24, 2010 at 12:16 PM

    Hi Alfonso,

    You can query table USR02 which contains informations about user, last logon date (TRDAT) and last logon time (LTIME), but the duration is not stored.

    Also, report RSUSR200 can record the users logon date and time.

    Br,

    Javier

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2010 at 01:01 PM

    This may be a specific requirement, you can develop you local program for this. give your requirement to your ABAPer, accordingly he will create a report for you.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24, 2010 at 02:25 PM

    We have tried with the audit, sm19, but the information we need is not there

    You haven't tried hard enough, Security audit log certainly records successful and failed login per user. It's a bit of a manual job but the information is certainly there.

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded