I am using resource analyzer to capture the report statistics and creating some custom reports based on this info.

I want to print the elapsed time and run time for each request.

I am able to get elapsed time from column SMELAPTIME (in SMQUERY master file) .. but couldn't find any column for the run time information.

Also pls let me know if i can get the start and end time for both the ranges?

I believe that SMTIME is the RPC start time and if you combine that with the elapsed time (SMELAPTIME as you state) then you should be able to derive the end time.

T

Thanks for your reply.

Just noticed one thing that only some of my fex/proc file's name I can see in WFRPCNAME(under master file SMQUERY). It doesn't show all the proc name, some of them it puts as NULL ...

Could you pls let me know the logic behind it.

Hi Blue Moon,

Sorry, but I do not have access to RA.

Perhaps if someone from the RA project have their ears and eyes open?

T

Procedure name stored only when you execute the procedure from “Object navigator” screen. That is, execute the procedure by right click on it and select the option 'RUN'.

If you open the in text editor and run, it won’t store the procedure name.

Let me know if you need more information.

Thanks Tony/Antony for your help.

I can see all my proc in smquery.

Regards,