PDA

View Full Version : Reports usage stats, log report visitors



tdomanek
03-16-2012, 11:23 AM
Hi
We would like to log information about report visitors. Then, based on them, we would like to present reports statistics. We want to turn off some "unpopular" reports. We are also interested in reports’ generation time.
How to configure log4j (Pentaho BI Server 3.10.0-stable) to log following information:

1) On report execution begin (when request is submitted)

SessionId,
RequestId, (unique key per session)
User,
Report
DateTime
Report parameters (optionally)


2) On report execution is complete (optionally)

SessionId,
RequestId,
User,
Report
DateTime
Result (Success or error – optionally)

Then I would like to join this information on condition 1)SessionId = 2)Session && 1)RequestId = 2)RequestId
Thanks for help.
Tomek.

codek
03-16-2012, 11:47 AM
you can't just configure log4j to log stuff like that. Take a look at the audit log, it will have some of this stuff.

the only thing you can do in log4j is turn logging on and off for different sections of the software that have already been configured to log in a certain way.

gutlez
03-16-2012, 12:43 PM
Try this thread (http://forums.pentaho.com/showthread.php?72457-Audit-user-login-and-report-usage) for ideas...

tdomanek
03-17-2012, 03:41 AM
Thanks for suggestions. I know that I can use log4j to turn logging on and off for different sections of the software. So I was thinking about some sections of softwer which log this kind of information, and then I wanted to parse this log. But I see that audit log is probably what I was looking for. Thanks again.

Tomek.