Skip to Content
author's profile photo Former Member
Former Member

Recording and reporting on transaction usage

Good day

I have a requirement to activate recording of transaction usage. I have searched on these forums and lists and not found anything really definitive.

What I need is to be able to report on all transaction usage and ideally retain data for a one year rolling period. I am looking in ST03N and cant work out from there what the procedure should be.

Thanks and regards

Ray

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Sep 03, 2013 at 09:44 AM

    The best way to do that is to enable Security Audit Log SM20, security audit logs are stored outside the DB so you can keep data for a long time. Then you can simple pour the data into an excel sheet, filter it and determined the Usage.

    ST03N and STAD by default only keep data for a few days.

    Regards, Juan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 03, 2013 at 10:03 AM

    Hi Raymond,

    You can activate the security audit for using SM19 which keeps tracking your transaction usage along with some other traces as well.

    Later use SM20 to pull out the transaction usage alone by using respective filter.

    You can delete the old logs using SM18 also.

    regards

    kartik

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 03, 2013 at 09:46 AM

    Hello,

    You can get it from ST03N.

    Thanks

    Sunny

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 03, 2013 at 12:19 PM

    You can also look to Solution Manager and Solution Documentation Assistant, that will also pull up how often a t-code is called and provide a though report on everything it finds.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 04, 2013 at 11:09 AM

    It seems that there are two options discussed above. The st03n option would involve altering the granularity of data stored if I understand correctly. An dif I understand correctly as well, the sm19/20 option could be pretty resource intensive considering that we are looking at a rolling total for 12 months. But I am sure that I have seen somewhere that there is some purpose built GRC 5.3 and 10 funcionality which performs this for child systems. Is anyone aware of this?

    Regards

    Ray

    Add a comment
    10|10000 characters needed characters exceeded

    • the sm19/20 option could be pretty resource intensive considering that we are looking at a rolling total for 12 months

      This is the "old school" way, its not really resource intensive as the files are stored at OS level and in plaint text so they are not huge..

      But I am sure that I have seen somewhere that there is some purpose built GRC 5.3 and 10 funcionality which performs this for child systems. Is anyone aware of this?

      There is a Transaction Usage Report on Enterprise Role Management(ERM) in GRC but I have not used it before.

      Regards, Juan

  • Posted on Sep 04, 2013 at 03:03 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 05, 2013 at 09:55 AM

    Well, we have tried activating the Transaction Usage in ERM and end up getting an error:

    Transaction usage operation failed; input data length not a multiple of blocksize

    Not too much information on that I can find.

    Regards

    Ray

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.