JasperServer Audit Report

[anandharaj]

Hi,

 

Is there a way to get audit report on JS? Meaning, who generated which report and what time. This would be nice to monitor the JS performance and to do some action based on this report.

 

If JS will introduce this as build-in function, it will be a very cool for administrator.

 

Sample report would be something like:

 

Username | Report Name | Date Generated | Duration | Status

---------------------------------------------------------------

Anan | My Report | 2007-11-01 8.00| 5 Mins | Successful

[lucianc]

Auditing is not yet built into JasperServer. Once that is done, administrators would of course be able to generate audit reports.

 

Regards,

Lucian

[carminez]

What is the status of this? Is Auditing available in 3.0? Professional/Community?

[anandharaj]

In community version its not available...not sure about pro version...

[swood]

We haven't done audit reports yet for Community Edition or Professional.

Capturing the data is relatively easy - just add an aspect around the EngineService. Reporting and analyzing the data would be easy ;-)

 

 

Sherman

Jaspersoft

[anandharaj]

Thanks swood, hope this will be available in next JS version.

[samvijay]

 

Lucianc/swood

 

I did not find the auditing feature even in JS 3.5, is there any plan to implement the same in near future

 

--Samvijay

[swood]

It did not make it for the last release. We are aiming for it to be in the next release.

 

Sherman

Jaspersoft

[anandharaj]

Thats good news Swood. :-)

[silvannos]

I'm guessing that this has not been implemented in 3.7 either. Just wanted to make sure you guys don't forget about this as it would be very useful. :D

On a related note, using the JasperServer database I was able to generate a report that does this except for one issue. The JIACCESSEVENT has information on when something happens to a report which is great except for the fact that there is no data concerning the type of event that took place. For example, just running a report from the JasperServer web interface logs 4 different events, which makes the times report were executed hard to count.

EDIT: Sorry about this, I finally found out that it is only available on the enterprise edition.

Thanks,

Simon

Post Edited by silvannos at 04/13/2010 10:51 AM

[dhoppmann]

Hey silvannos,

What did you do? I was using this query, but when I log in as this user/tenant, I do not see new entries. How much logging is actually put into the JIAccessEvent table?

SELECT * FROM JIUser JOIN JITenant ON JITenant.id=JIUser.tenantId
JOIN JIAccessEvent ON JIAccessEvent.user_id=JIUser.id
JOIN JIResource ON JIResource.id=JIAccessEvent.resource_id
JOIN JIReportUnit ON JIReportUnit.id=JIResource.id
WHERE username='$' AND tenantName='$'
ORDER BY update_date DESC;

Thanks!

[mnoland2]

I was able to make this work a little better by excluding things like  datasources, and Input_controls (see the where clause) you may need to chane the "date_trunc" and where statement depending on youre setup

 Note

this only shows if the user accessed a report.

 

 

Code:

Post Edited by mnoland2 at 12/01/2010 22:35

[nithyanand11]

Could you please help .. In a report with subreport..if i set  strech type = "related to tallest object".. the main report gets break in new page when the subreport in long.. how to handle this scnerio.....

 

.

.

Thanks in advance

[phamk]

Hello,

I am using this query to audit the access to the reports (Main_jrxml). Hope this can help.

select distinct JIReportUnit.mainReport,
date_format(JIAccessEvent.event_date,"%y-%m-%d") dformat, JIAccessEvent.user_id, JIAccessEvent.resource_id,
JIResource.name,
username,
tenantAlias
from JIAccessEvent
join JIReportUnit on JIReportUnit.id = JIAccessEvent.resource_id
join JIResource on JIResource.id=JIReportUnit.mainReport
join JIUser on JIUser.id = JIAccessEvent.user_id
join JITenant on JITenant.id=JIUser.tenantId
where JIResource.label = "Main jrxml"
order by dformat desc

 

[shmee]

Thanks for the tips guys! I was just thinking about how I wanted to audit the JasperServer, so I checked the forum, and this thread got me started.

 

Though it would be much cooler to have built in user and report auditing.