SAP User login time and Transaction History

[Former Member]

Dear Experts,

I am looking for your advice to get the user transaction history and frequency of login's or number of login per day or a week , Our customer wants this report on daily basis so that they can check how many users are frequently using and how many are not using. I had a look at the forums and found some older posts, they talk about using SUIM and activating system audit and checking ST03. Our customer uses a Third party application ACL Audit to get this data from SAP , as you know from ACL you get data from the SAP tables rather than executing ABAP Programes .

I would like to ask you if any one has done this scenario ? What are the tables that can give us the data on User login's and transaction history .

Please Help

Thanks,

Ravi

[Former Member]

> ... you get data from the SAP tables rather than executing ABAP Programes .

This is a clear indication that you have not even read the programs, though they are not easy to understand.

For a taste of things to come see this flamewar:

For some of the "transactions" you can take a look at the application logs in the update FM's as you seem not to have done that yet.

But the basic answer is no. There is no meaningfull nor reliable way to do this via a table directly, let alone a single one.

If you must have this data in an external DB, then the best solution is to use stable APIs for the SM20 and SM21 data. Report RSAU_READ_AUDITLOG_EXTERNAL will help you further to find the BAPI "return table".

SM20 is also the correct source. The ST03 data is not the correct source nor reliable.

Cheers,

Julius

[Former Member]

Hi Julius,

I am new to Netweaver and SAP Products. We have recently installed SSM 7.0 with Netweaver CE 7.0.

Our org needs a User Audit report similar to the above question.

Are there any documents or do you have any direction on how to obtain data (from which tables?) to develop a User Audit (login) report?

Thanks in advance.

Regards

David

[Former Member]

Hi,

All of this data is obtainable. Transaction STAD is a good starting point, this can show a report for users log ins and which transactions were run.

There are free tools out there (CSI STAD extractor database) which you can use to economically extract and make sense of this data. It is both reliable and easily formatted for consumption.