Skip to Content
avatar image
Former Member

How to calculate Tcode execution count

Hello Friends ,

I request your help with a few points. I need to customize a GRC report which is currently fetched from NWBC. I need to replicate most of the functionality of the standard report. But the challenge is that I dont know the standard report which fetches raw data because it is triggered from NWBC.

1. Need to calculate how many times ( execution count ) a tcode was run by a user.

2. Is it possible to get the standard reports which fetch data from NWBC. The report is generated as shown in attached screenshot.

Please let me know if I can add any further details for clarity.

Thanks

Vivek

NWBC 3.PNG (37.0 kB)
NWBC 2.PNG (38.7 kB)
NWBC 1.PNG (10.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Sep 23, 2015 at 12:03 PM

    Dear Vivek,

    the program synchronises each execution of an action to the table GRACACTUSAGE for action usage and role usage to GRACROLEUSAGE.

    To get the calculated number of executions by a user you need to count the entries in the table. Last execution can also be read since the execution date for each single execution is stored with a timestamp.

    From SQL point of view you can use:

    SELECT user, max(execution_date), count(*) from GRACACTUSAGE GROUP BY user

    Hope this helps.

    Regards,

    Alessandro

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Alessandro,


      i was able to proceed with table GRACMGMTACTUSAGE. This table gave execution count and was consistent with the NWBC report count.


      Your inputs were correct. The challenge was that the User did not maintain the data consistently. But yes, we can get execution count the way you suggested.


      Thanks again for your help.


      Vivek


  • Sep 23, 2015 at 12:40 PM

    hi

    report Action usage by user, role and profile, will give the execution count per tcode

    Regards

    Plaban

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2015 at 07:26 AM

    Hi Vivek,

    You can get report NWBC report and Analytics work certer for this you had to configuration maintain parameter settings.

    Regards,

    Visu

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24, 2015 at 11:08 AM

    Hello Vivek,

    May be this is additional information useful to you.

    Tcode execution count will be calculated on sync job GRAC_ACTION_USAGE_SYNC.

    Once this job completed successfully then check table GRACALACTLOG in SE16 for fields

    LASTEXECUTEDON and EXECUTIONCOUNT.

    Regards

    Baithi

    Add comment
    10|10000 characters needed characters exceeded