Report with tcodes utilization on per user & per date basis

Question

We want to create a report with Select Criteria DATE & USER and we display the Transactions that run per user & per date.

I know the transaction ST03N but it does not extract the data as I want (DATE-USER-TCODES).

Does anyone know where to find these data, which tables?

Thanks in advance Elias

Answer 1

Everything is in ST03N:

1. Select target system from the list in the very top menu
2. Expand the list of periods (day, month, total) and select the necessary leaf in the necessary node

3. After double-click (important!) on that leaf the window will appear in the bottom-left corner. In that window one can choose the necessary stats. Here we need to select User and Settlement Statistics and User Profile below.
4. After double-click on the necessary stat, windows in the right will be filled with data.
5. Here we need to double-click again on the target user and all his tcodes on the selected date will be displayed in the popup.

P.S. If you miss User and Settlements Statistics node in your system, then some of the Performance Collectors are not set up properly on your system.

Answer 2

You won't be able to get this from one specific table; however, you can use the following function module to fetch the information:

SWNC_COLLECTOR_GET_AGGREGATES

You will have to pass the following parameters:

IMHOSTNAME                                      "HOSTNAME"
IMDATUM                                         "DATE"
IMPERITYPE                                      "D/W/M"

Variable EX_DATA-APPLICATION_STAT will have all the info you need.

Answer 3

Do you mean, you want to display, what a specific user did in the system on a given day? If yes, have a look at transaction STAD.

Answer 4

The table that stores all data from ST03N is MONI, however it is encoded and cannot be read. You will have to write a custom program using SWNC_COLLECTOR_GET_AGGREGATES function module or check out ones already available online.