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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Analysing Large ST01 Files

Go to solution
Former Member

‎06-10-2008 10:28 AM

0 Kudos

Morning All,

Have been performing blocks of traces for some new process activities for Portal in our R/3 Dev system using the trace transaction code ST01.

Some of these trace files are very large, over 10,000 lines when downloaded into excel etc. Please SAP Security gurus can anyone tell me if their is an easy way or a tool to make it easy to analyse large ST01 files so that I dont have to check hundreds of duplicate authorisation lines.

Thanks

Steve

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎06-10-2008 1:19 PM

0 Kudos

You may want to reduce the amount of time you activate the trace for. Also, once you get the file into excel, since the files are very often the same auth object and values - you have use a filter with a "unique records only" to get only 1 unique value for each auth object and value combination. In excel, select the columns with the auth object and value and then go to data \ advanced filter. You will see the option for "unique records only".

2 REPLIES 2

Go to solution
Former Member

‎06-10-2008 1:19 PM

0 Kudos

You may want to reduce the amount of time you activate the trace for. Also, once you get the file into excel, since the files are very often the same auth object and values - you have use a filter with a "unique records only" to get only 1 unique value for each auth object and value combination. In excel, select the columns with the auth object and value and then go to data \ advanced filter. You will see the option for "unique records only".

Go to solution
Former Member

‎06-10-2008 1:46 PM

0 Kudos

Thanks for this, I wasnt able to get the time down as the large file contained all activities for a role; however fiddling with those autofilters has got it down to 335 rows which is a 97% reduction in rows and should be enough to be able to get on with it, its only 5 auth objects to play with so many thanks.

Edited by: Steve Bodell on Jun 10, 2008 3:00 PM