ST03N - report for multiple users

[Former Member]

Hi, I have a task to do, we need to generate a list of transactions run by 700 users within last 3 months. I can easy find transaction run within last 3 months by each users in ST03N but It is not possible to check that fro 700 users at once, is there a method to check that for all users or I need to go one by one 700 times? thank you

[Former Member]

Hi,

I think you can get that data from EXPERT MODE in ST03N

Thanks,

Ravi

[bxiv]

If you have access to a Solution Manager you can leverage SDA and it will pull all that information up for 3/4/5/12/etc months for transactions called.

[JPReyes]

Simple answer, you can't using ST03N.

The easiest way to do this is using data from the Security Audit Log SM20 and export it to a handy excel sheet.

If you search you will find lots of threads about this.

Regards, Juan

[Former Member]

Write a Z program, look at the SWNC_GET* function modules.

Cheers Michael

[Former Member]

hi M HO, thanks but I do not have authorization to do that, development is done by external company in our system, it takes ages to have something like that in production, we need to have it this week so need some SE16N/SE38/SQVI solution or maybe it is possible from ST03N

[Former Member]

To get all users with transactions per month, you can run SWNC_GET_WORKLOAD_STATISTIC directly from SE37. Use these params:

SYSTEMID	<SID>
INSTANCE	TOTAL
PERIODTYPE	M
PERIODSTRT	01.07.2013

PERIODSTRT is just the first day of the month, the format might be slightly different on your system.

Table USERTCODE holds the information you are looking for.

Cheers Michael