Jump to content

JasperServer Audit Report


anandharaj

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 14
  • Created
  • Last Reply

Top Posters In This Topic

  • 11 months later...
  • 5 months later...
  • 3 weeks later...
  • 11 months later...

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
Link to comment
Share on other sites

  • 1 month later...

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!

Link to comment
Share on other sites

  • 6 months later...

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
Link to comment
Share on other sites

  • 3 months later...

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

 

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...