Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Pulling the history of the user for list of transactions used

Former Member
0 Kudos

Hi,

Can any one help me in finding the list of transaction accessed by a user for the past 3 months.

And is there anyway we can get it in a report ..eg excel sheet.

In ST03 I think we can see the transactions.

But I am not able to pull the report.

Can any one provide me a step by step procedure to pull the same.

Your assistance will be greately appreciated.

Regards,

Lalita.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Lalita,

Step 1: Execute the ST03N

Step 2: Select Expert Mode from the Drop down on The Administrator Icon

Step 3: Double-click the sever name to expand and get the details

Step 4: Scroll down using the up/down scroll about on the left of the screen and select the appropriate month.

Step 5: Double-click the selected month

Step 6: Expand the User and settlement Statistics option and Double-click User Profile

This displays all the information about the Useru2019s profile

Step 7: Find the user for whom you want to get the list of Tcodes executed in a stipulated period

Step 8: List of T. Codes executed by the user

Step 9: Click the Report/Transaction to highlight the complete row and Right-click to select the Copy text option.

This will copy the text to clipboard. You can paste the same in any office suite, i.e., Excel, RTF, Word etc.,

Hope this helps you...

Ajit

9 REPLIES 9

Former Member
0 Kudos

Hi,

In st03n there is button (4th from right )Export to .You can use this to download it in excel

hope this helps

former_member1061482
Participant
0 Kudos

Try SM20. Security audit log needs to be enabled.

To download, go to List->Export

You can also try STAD and download the details.

Former Member
0 Kudos

Hi Lalita,

Step 1: Execute the ST03N

Step 2: Select Expert Mode from the Drop down on The Administrator Icon

Step 3: Double-click the sever name to expand and get the details

Step 4: Scroll down using the up/down scroll about on the left of the screen and select the appropriate month.

Step 5: Double-click the selected month

Step 6: Expand the User and settlement Statistics option and Double-click User Profile

This displays all the information about the Useru2019s profile

Step 7: Find the user for whom you want to get the list of Tcodes executed in a stipulated period

Step 8: List of T. Codes executed by the user

Step 9: Click the Report/Transaction to highlight the complete row and Right-click to select the Copy text option.

This will copy the text to clipboard. You can paste the same in any office suite, i.e., Excel, RTF, Word etc.,

Hope this helps you...

Ajit

0 Kudos

Thank you all for providing immeidate reply.

Hi Ajit,

That's excellent. It is working very well. Appreciate your help.

Thanks so much for the solution you have provided. I am able to pull the history of transactions used by a particular user.

ajit, is there any way we can find out the terminal from where he is executing these transactions?

Regards,

Lalita.

0 Kudos

This message was moderated.

0 Kudos

Basically, STAT an STAD transcation calls program RSSTAT26. You can perfom the activity in Background.

All you need to do is:

1.Go to se38 -> Program RSSTAT26 -> Execute . Fill in the details of the selectionscreen with the transaction field as * Client as *

2..Leave the date field as it is and goto Menu tab-> "GOTO" -> Variants -> Save as Variant

3. Name the variant. In the Objects for Selection screen Identify the date field as Dyanamic and use the Current date variable

This will create a variant for your purpose. All you need to do is run a background job with step as

Program RSSTAT26

Variant "The variant that you created"

The spool will have all the necessary details.

This works for me..hope it goes for you too.

pointbegging removed by moderator

Edited by: Bernhard Hochreiter on Apr 29, 2010 11:20 AM

0 Kudos

Hi,

From Ajit's reply above, I could not execute step 8.

Grateful if any one could please advise.

Thank you.

0 Kudos

Hi Prakash,

After the 7th step, double click on the user that you were searching for. It will open a pop-up displaying all the transactions the user has executed for the selected month.

You can then export it into an excel.

Hope this helps....

Regards,

FP

0 Kudos

Hi Ajit.

Thanks.. for the detailed steps. That is very helpful.

Thanks Fahim for the clarification.

Regards

indu