Report to list top dialog execeution times

[himubert]

Hi everyone,

It's been a long time since I last posted a query here. I have a client request to provide a report every week on dialog performance.
Basically, what they need is a list of users who run dialog transactions/programs with execution time equal or more than 1 hour with the following details:
- User ID
- Program name
- Start and end time

It's sort of an SM37 list for dialog transactions instead of background jobs.

Some of these information I believe can be taken from ST03N (ie, total response time of a transaction, total response time of a user) but not in a consolidated format (total response time of all users and transactions). However, I don't think ST03N provides the start and end time for those dialog transactions. Transaction code STAD provides additional information for response time of a transaction with start and end time when double-clicked but the information stored for STAD only lasts up to 2 days.

Would you know any other table/transaction we can use to gather this data from? Thank you so much.

All the best,
Albert

[Bebop]

I think you can rather easily write yourself a report for that using the function module SWNC_COLLECTOR_GET_AGGREGATES.

Regards
Frank

[Zavaros]

Hi,

dialog processes with runtime over 1 hour? Is it a BW system?

btw, ST03 has a top time report. It lists the 40 (or so) longest DIA runs... maybe it helps if there are only few users you should report.

Regards,

Zav