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