Saturday, December 29, 2012

CREATE DAILY AUDIT LOG AUTOMATICALLY


For audit monitoring purpose, I want to create background job which generated SAP audit log report daily. After searching in google, I get the tricks from this link http://forums.sdn.sap.com/thread.jspa?threadID=1234536
So, here I only to show you how to do that by screenshot based on my experience and also combine this with dynamic variant so parameter date on the program change automatically every time background job is running
SAP Report Name that I will use here is RSAU_SELECT_EVENTS
First, run Tcode SE38. Fill program / report name, choose Subobjects Variants then click Change button 


This dialog box will appear, fill variant name (for example here is AUDITLOG) and then click Create button


The screen below will appear, fill in selection for variant that you choose and click Attributes to set dynamic variant for date.

 
When Variant Attributes screen appear, set Selection variable for Current Date to D (Dynamic date calculation) and set variable for first row of Curent Date to Current date – 1 days and second row of Curent Date to Current Date. You can add description to variant. Save variant by click on Save button  then click Back button



First row of Curent Date only represent From Date and second row of Curent Date only represent To Date, so if you want to set fixed Time you must entry manually on this screen (after click Back from screen Variant Attributes). Save variant by click on Save button


Then, now I can make background job using report RSAU_SELECT_EVENTS and variant AUDITLOG.
I combine this with sending the spool result to your mail. So I must not log in to download data.
Keep trying and good luck :)

No comments:

Post a Comment