Hi All,
We need to gather statistics of some of the XYZ(application Name) WebFOCUS Reports.
Is it really possible what were running(all fex files starting with wpm) were running from so and so time to so and so time.
and who( network ID) has run it....!!
Is it really possile ...Kindly help me

thanks in advance

This message has been edited. Last edited by: Kerry,

My Bad its statistics.Sorry for typo

Hi,

I believe you are looking for the product called Resource Analyzer.

It is a seperate install and license.
Unfortunately, my company doesn't have it so I can't tell you how useful it is.

Best Regards,

Jimmy Pang

Jimmy Thanks....
Do you mean we really cannot get any abovce mentioned details with what we have today.
I mean normal WF devstudio and console.

Do we really need only resource analyser to get the foot prints of all.

Resource Analyzer is very useful and provides lots of statistics, I guess that's why it costs extra!

By the way, you can correct the speeling in the title of this thread by editing your original post.

This subject has previously been discussed in the forum. The other method, which more than one of us is using, is to write your own code that tracks execution of the programs.

For example, I track the usage of all the reports in our self service application by writing to a FOCUS DB at the end of each execution - fex name, User ID, execution time...

Not that I know of.

From what I understand of that tool (resource analyzer), there is a backend process that stores the information on the executed modules in a tables that you can query. You may want to request more info from IBI.

Best Regards,

Jimmy Pang

Changed the title...
Thank you....!!!

Francis,
Thank you...
Can you elaborate the below example little bit..
Please...


[quote]For example, I track the usage of all the reports in our self service application by writing to a FOCUS DB at the end of each execution - fex name, User ID, execution time

I have used both method.

1- Resource Analyzer - Simple... All info can be stored in a repository. Then you can write queries against those tables.

2- You can include codes to input all the needed info to a table. For example, you run a month end report. At the end of that report, you include codes to grab the userid, time, report name, etc.. and put that in a table. Later you can query against that table for the required information.

Method 1 is highly recommended if budget permits. It's simple and very flexible.

Thanks,
Sayed

This message has been edited. Last edited by: Sayed,

For method 2, I do the following in each program:

At the beginning of the report, I have an INCLUDE that records the system date and time in Dialogue Manager variables.

At the end of the report, I have an INCLUDE that records the system date and time in Dialogue manager variables and calculate the elapsed time using these variables. I then use MODIFY to write a row into a FOCUS database, recording the User ID, fex name and elapsed time.

We do similar, except we have a generic fex that collects the details,and calls the required report.

We track report usage in the same manner as Waz and Francis, very easy to implement and report from.