topic Archiving Audit Logs in Application Development and Automation Discussions

Archiving Audit Logs

Former Member — Mon, 02 Nov 2009 16:00:17 GMT

Hello Gurus

I want to know how can I archive the Audit Logs that are getting created from SM19/SM20 which are text files into IXOS system.

Any help is appreciated.

I read some documentation about using t-code SARA, but could not fully grasp what it is saying, is this the only way?

Thanks

Re: Archiving Audit Logs

sdipanjan — Mon, 02 Nov 2009 18:25:27 GMT

This activity should be performed by your BASIS team. Please have a look into the attached doc (u may also get such articles by performing a search in SCN):

[Introduction to Data Archiving (CA-ARC)|http://help.sap.com/saphelp_nw70/helpdata/en/4d/455035082e2271e10000009b38f889/frameset.htm]

[SAP Note 102446 Archiving objects|http://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_bc_ccm/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d313032343436%7d]

[Introduction to Data Archiving in SAP R/3 Enterprise|http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/a111ae90-0201-0010-4bbe-809ec5627433&overridelayout=true]

Regards,

Dipanjan

Re: Archiving Audit Logs

Former Member — Mon, 02 Nov 2009 22:21:51 GMT

Have you considered (before searching...) that these are file system logs?

A popular way is to restrict the file size appropriately (you can tune this in RZ11) and burn CD's, or transfer them to a file server when they are no longer needed online (more likely).

Cheers,

Julius

Re: Archiving Audit Logs

Former Member — Tue, 03 Nov 2009 18:01:22 GMT

Hi Julius

Yes, I know that these are flat files getting stored at file system level. Precisely thats the concern, file system growth...

We want the logs to be able to capture just about every activity that happens on the system, so it would be maximum possible

in terms of file size.

Thats why I started to look around for solutions in terms of archiving. We do have IXOS applicaiton in house running.

I was looking for all possible alternatives.

Thanks for your time.

Re: Archiving Audit Logs

Former Member — Tue, 03 Nov 2009 23:33:04 GMT

This is how we do it at our shop:

1. Archive - SM20-> select criteria (date range, number of pages, etc)->run report->save output file to spreadsheet then import to a database.

2. Delete security log after archiving. Run SM18.

Good Luck!