How to get list of all transactions executed by all users in 03 to 06 months

[former_member190076]

Hi,

In ECC, How can I get a complete list of all the transactions executed by all the users in the last 03 to 06 months. I know we can somehow get this information via ST03N but that involves manually clicking each user to see its executed transactions which is difficult to do for a thousand users. Please let me know if we can get a plain list of all the users along with all the transactions executed in one screen.

[Laszlo_B]

Hello Mohsin,

by default no programs / transactions log the started transactions for that long time.

For this purpose, the Security Audit Log can be used, which are available from transaction SM19 / SM20.

Here is a basic documentation on using these transactions: http://scn.sap.com/docs/DOC-60743.

(Bear in mind though that storing these information for 3-6 months might need a lot of disk space.)

Best regards,

Laszlo

[former_member204080]

Hi ,

As mentioned by Laszlo there is no SAP standard functionality for this

You either have to manually get it from ST03N or

You could check the program SAPWL_ST03N  and try to write a customized script to pick only required data (user and transaction) from the underlying tables

Regards,

Murali