06-10-2008 10:28 AM
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
06-10-2008 1:19 PM
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".
06-10-2008 1:19 PM
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".
06-10-2008 1:46 PM
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