Focal Point
[CLOSED] Tracking Report Execution

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2307049886

January 10, 2018, 05:47 AM
Aj_BI
[CLOSED] Tracking Report Execution
Hi All, suppose there is a report created using App Studio and available in Development and Production. Now I need to track that when was the report last run/executed from anywhere(Dashboard/Launch Page/App Studio/URL) so that I can decide weather the report is in use or obsolete. Please advise if there is any logging maintained for such information in App Studio. Thanks in advance...

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
January 10, 2018, 05:56 AM
Frans
This info is available on the server, check if you have Resource Analyzer installed.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
January 10, 2018, 06:59 AM
Aj_BI
Thanks Frans but I am not sure about Resource Analyser. Can you please guide me where I can check it or install it in case it is not already installed. Thanks again...


WebFOCUS 8
Windows, All Outputs
January 10, 2018, 07:21 AM
Frans
Sure, in App studio on the top right you can click reporting Server Console. This opens a browser where you need to go to the tab Resource management (if it does not exists you may not have a license for it. If configured, you will find reports there, else you have to configure first.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
January 10, 2018, 08:44 AM
MartinY
Aj_BI,

You need to be licensed ($$$) to use Resource Analyzer (RA).
RA is a great tool but IMHO I found that it collect too many information for what I normally need (number of execution in a time line) and depending of your environment (usage), the RA DB size may increase very fast and may need maintenance.

Another option is to create your own execution tracking "system".
What you need is to have a fex that will be executed each time before any other report execution (from a profile or a fex include per example) that will grab the report info and save it as in a text file, a focus or SQL table. Using that method you can define what ever and only what you want as stored info.


WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007
January 11, 2018, 01:04 PM
FP Mod Chuck
Aj_BI

There is also a new offering called the Enterprise Usage Monitor that reads the edaprint log and reports on individual users usage. It is an extra cost feature but just wanted you to be aware of it as a solution also.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats