ReportServer Forum

bpeikes

Member

Registered: 2016-10-29

Huge rs_audit_log_property table

We have a relatively small install of report server, but for some reason, the rs_audit_log_property table has over 4 million records, and is taking several gigs of space on disk. Is there anyway to reduce the size?

jalbrecht

Administrator

Registered: 2016-10-21

Re: Huge rs_audit_log_property table

Hi bpeikes,

Check

SELECT E.*, P.KEY_FIELD, P.VALUE
FROM RS_AUDIT_LOG_ENTRY E join RS_AUDIT_LOG_PROPERTY P on E.ENTITY_ID = P.LOG_ENTRY_ID
ORDER BY DATE_FIELD desc

to see relation between RS_AUDIT_LOG Tables ..ENTRY and ..PROPERTY. In General several Property rows match with one ENTRY row. Always deal with both of them. They provide you with useful statistics about your instance.

Whenever you manipulate table content make sure you have a restore option. Only Delete Log Entries when Reportserver is down.

Hope that helps

Jan

bpeikes

Member

Registered: 2016-10-29

Re: Huge rs_audit_log_property table

I see the relationship, but how would you recommend trimming this down? Does this table simply keep growing?

bpeikes

Member

Registered: 2016-10-29

Re: Huge rs_audit_log_property table

Just wondering if there is a recommendation on how to trim the audit logs. The rs_audit_log_property table is now 9GB. You said that we'd need to trim them, but it's not clear how. For instance, is there a cascade delete between rs_audit_log_property and the rs_audit_log_entry table?

Ideally, there would be a way from the interface to clear the audit log, or at least part of it. I can't imagine why we would have such a ridiculously large audit log. There are not that many changes made to this server.

jalbrecht

Administrator

Registered: 2016-10-21

Re: Huge rs_audit_log_property table

Hi bpeikes,

pls. check: https://reportserver.net/en/guides/admi … intenance/

and here:
17.2. Logging
All actions, such as changes to reports or execution of reports are logged in the ReportServer's audit log. The log is split over two database tables. The table RS_AUDIT_LOG_ENTRY contains all logged actions while the table RS_AUDIT_LOG_PROPERTY contains additional information for each action. Note that the tables are not truncated automatically and that on a system with heavy load the tables can thus become very big. It is hence recommended to set up an automatic archiving task. This can be achieved using a ReportServer script, or externally using the native scheduler of your RDBMS.

In RS CE Edition there is no scripting, hence use your RDBMS's Scheduler to empty the tables ...

wbr jan