Uploaded image for project: 'Nuxeo Documentation'
  1. Nuxeo Documentation
  2. NXDOC-1721

Fix audit purge script to remove entries without extended info

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.3
    • Component/s: None

      Description

      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.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 3 hours
                3h