Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-7829

Customizable Audit log houskeeping

    XMLWordPrintable

Details

    • New Feature Request
    • Status: Open
    • Trivial
    • Resolution: Unresolved
    • 6.0.6
    • None
    • None
    • None

    Description

      My 4 month zabbix installation has Audit log almost the same size as history_uint for one month

      +----------------------------+----------+
      | TABLE_NAME                 | SIZE_MB  |
      +----------------------------+----------+
      | history_uint               | 66837.02 |
      | auditlog                   | 65381.98 |
      | history                    | 19043.19 |
      | trends_uint                |  4734.53 |
      | trends                     |   999.50 |
      | history_log                |   711.34 |
      | history_text               |   492.59 |
      | alerts                     |   119.75 |
      | items                      |    82.14 |
      | history_str                |    44.02 |
      | triggers                   |    29.03 |
      

      I've checked my audit log and it is full of records from System user about element update, LLD discovery and others. It might be helpful in investigations, but I don't think I need it for 1 year.

      At the same time I want to know who (real user) disabled trigger or changed template 6 month ago.

      It would be good to have ability to configure housekeeping periods separately for System events and Users events.

      Or could you provide SQL script to cleanup Audit log records from System user older than month or even week?

      Attachments

        Activity

          People

            Unassigned Unassigned
            abyss Andrey Kunitsyn
            Votes:
            3 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated: