-
Type: Improvement
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 10.3
-
Component/s: None
-
Tags:
-
Sprint:nxcore 10.10.2, nxcore 10.10.3
-
Story Points:3
https://doc.nuxeo.com/nxdoc/purging-audit-logs-nxp_logs/ describes the way to purge the SQL audit logs.
The audit entries that have no extended info are not removed by theses procedures, so lots of entries remain unduly.
In adding the following to the SQL script:
DELETE FROM nxp_logs WHERE nxp_logs.log_event_date < maxDate::date GET DIAGNOSTICS nblines = ROW_COUNT; SELECT nblines+total INTO total; RAISE INFO '% lines cleanup on table nxp_logs', nblines;
you can get rid on the undue entries.