#1 2015-03-24 12:45:03

dee
Member
Registered: 2015-03-24

Enable/Disable Auditing ?

We're looking to improve the performance of ReportServer and we were wondering if its possible to disable the 'auditing' actions recorded in the operational database ?

Thanks !

Offline

#2 2015-03-24 16:59:04

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Enable/Disable Auditing ?

Hi dee,

welcome to the ReportServer forum. You should be able to shutdown the audit logging by executing the following script:

import net.datenwerke.rs.utils.eventlogger.EventLoggerService

def service = GLOBALS.getInstance(EventLoggerService.class)
service.shutdownWatchdog()
service.shutdown()

Out of curiosity. Do you have any indication that the audit logging affects the performance of your database?

Cheers
-Arno

Offline

#3 2015-03-24 17:05:08

dee
Member
Registered: 2015-03-24

Re: Enable/Disable Auditing ?

Thanks Arno !

When you say execute the script - in what way ? sorry if I'm asking something which is obvious.

Now that we know how to shut it down we'll be able to benchmark it.

We'll update on the results if thats something that could assist anyone.

Thanks

Last edited by dee (2015-03-24 17:12:24)

Offline

#4 2015-03-24 17:13:32

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Enable/Disable Auditing ?

Hey dee,

I am definitely interested in any benchmarks that you are making.

Cheers
-Arno

Offline

#5 2015-03-25 07:18:56

dee
Member
Registered: 2015-03-24

Re: Enable/Disable Auditing ?

When you say execute the script - in what way ? sorry if I'm asking something which is obvious.

Offline

#6 2015-03-25 07:25:45

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Enable/Disable Auditing ?

ReportServer scripts go in the internal file server somewhere below the bin directory. You can execute a script from the terminal (CTRL+ALT+T opens the terminal). Assuming your script is in /bin/tmp/disableauditlog.groovy you can execute the script by running the commands

cd /fileserver/bin/tmp
exec disableauditlog.groovy

For further information have a look at the admin and scripting guides http://www.reportserver.net/en/services/.

Cheers
-Arno

Offline

#7 2015-04-29 12:50:46

ralex
Member
Registered: 2015-04-20

Re: Enable/Disable Auditing ?

Hi,
instead of completely shutdown the audit, how is possible to reduce the log's level?
Thanks,

Alex

Offline

#8 2015-04-29 15:45:25

Arno Mittelbach
datenwerke
Registered: 2012-02-14

Re: Enable/Disable Auditing ?

Hi Alex,

ReportServer currently does not distinguish between different log levels.

Cheers
-Arno

Offline

Board footer

Powered by FluxBB