This content has been marked as final. Show 7 replies
We are on 126.96.36.199 and we have a scheduled task that runs everyday to track FR Usage. I am not super technical and I am not the developer of this script, but it basically grabs the log file (I believe it is either FRReportSvr or FRUserLogin) loads it into Oracle and parse it. Then we report the outcome on Oracle Application Express (APEX). It basically shows how many people ran which report, when, how many times, etc. We also do ranking of report usage based on periods, so you can track which reports are being used, which report usage has been declining over time, how the newly developed reports have been doing, etc. It is pretty useful.
Does it sound like something you would develop?
In workspace you can access "Navigate -> Administer -> Usage Tracking"
Here you enable the tracking information. After configuring you can write SQL queries or develop an interactive report to gather the information you need. They are stored in the Workspace/BI database under the V8_USAGE* tables.
Edited by: Nicholas King on May 23, 2011 12:56 PM
Thanks for the reply ,
I need more information about that log file. Can you please give me the location of the file(FRUSERLOGIN.log or FRREPORTSVR.log).I search my entire server but i could not find it.If you can give me any hint like where can i find it or do i need to enable any option which will start generating this file.
Thanks for you help
Edited by: RSG on Jun 9, 2011 9:12 AM