2008 Jul 14 12:54 PM
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.
2008 Jul 14 7:22 PM
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
2008 Jul 14 1:06 PM
Hi,
In st03n there is button (4th from right )Export to .You can use this to download it in excel
hope this helps
2008 Jul 14 1:11 PM
Try SM20. Security audit log needs to be enabled.
To download, go to List->Export
You can also try STAD and download the details.
2008 Jul 14 7:22 PM
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
2008 Jul 17 6:50 AM
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.
2010 Apr 28 4:41 PM
2010 Apr 29 9:20 AM
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
2012 Apr 20 4:26 PM
Hi,
From Ajit's reply above, I could not execute step 8.
Grateful if any one could please advise.
Thank you.
2012 May 07 12:50 PM
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
2012 May 07 1:58 PM
Hi Ajit.
Thanks.. for the detailed steps. That is very helpful.
Thanks Fahim for the clarification.
Regards
indu