Skip to Content
avatar image
Former Member

ST03N - report for multiple users

Hi, I have a task to do, we need to generate a list of transactions run by 700 users within last 3 months. I can easy find transaction run within last 3 months by each users in ST03N but It is not possible to check that fro 700 users at once, is there a method to check that for all users or I need to go one by one 700 times? thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 29, 2013 at 08:18 AM

    Write a Z program, look at the SWNC_GET* function modules.

    Cheers Michael

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      To get all users with transactions per month, you can run SWNC_GET_WORKLOAD_STATISTIC directly from SE37. Use these params:

      SYSTEMID                    <SID>INSTANCE                    TOTALPERIODTYPE                  MPERIODSTRT                  01.07.2013

      PERIODSTRT is just the first day of the month, the format might be slightly different on your system.

      Table USERTCODE holds the information you are looking for.

      Cheers Michael

  • Jul 29, 2013 at 10:16 AM

    Simple answer, you can't using ST03N.

    The easiest way to do this is using data from the Security Audit Log SM20 and export it to a handy excel sheet.

    If you search you will find lots of threads about this.

    Regards, Juan

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 29, 2013 at 12:01 PM

    If you have access to a Solution Manager you can leverage SDA and it will pull all that information up for 3/4/5/12/etc months for transactions called.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 29, 2013 at 12:15 PM

    Hi,

    I think you can get that data from EXPERT MODE in ST03N

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded