Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1798

Provide a script for administrators to purge the Audit Log

    XMLWordPrintable

Details

    Description

      Current Situation

      • The Audit Log view works based on a database table that stores information about user interventions that modify JobScheduler objects.
      • The same information is stored with the ./logs/JOCAuditLog.log file.

      Desired Behavior

      • A script is provided for administrators to purge the Audit Log. We consider it critical to remove entries from the Audit Log as this information could be required for compliance purposes. Therefore a script is provided and not an operation with the GUI.
      • The script cleanup_auditlog_table.cmd | .sh is provided that is parameterized by the number of days counted from today for which the entries in the audit log table should be removed.

      For older releases from 1.12.0

      The script can be added to a JobScheduler installation from 1.12.0 by the following steps:

      1. download JS-1798-linux.tar.gz (for Windows) or JS-1798-linux.tar.gz (for Linux), respectively
      2. extract the archive into the JobScheduler installation (SCHEDULER_HOME)
      3. call the "scheduler_install_tables"-script from the command prompt with the argument audit_log_cleanup_procedure.sql
        Linux
        > ./install/scheduler_install_tables.sh audit_log_cleanup_procedure.sql
        
        Windows
        > .\install\scheduler_install_tables.cmd audit_log_cleanup_procedure.sql
        
      4. If necessary, the script must still be adapted at below ???, where otherwise the installer substitutes values of the installation.
        But it should also work without this step, because the required environment variables should be read from the ./bin/jobscheduler_environment_variables.(sh|cmd).
        Linux, cleanup_auditlog_table.sh, line 17ff
        test -z "$SCHEDULER_HOME" && SCHEDULER_HOME="???"
        test -z "$SCHEDULER_DATA" && SCHEDULER_DATA="???"
        test -z "$JAVA_HOME" && JAVA_HOME="???"
        
        Windows, cleanup_auditlog_table.cmd, line 14ff
        if not defined INSTALL_PATH set INSTALL_PATH=???
        if not defined APPDATA_PATH set APPDATA_PATH=???
        if not defined JAVA_HOME set JAVA_HOME=???
        

      Attachments

        Issue Links

          Activity

            People

              oh Oliver Haufe
              ap Andreas PĆ¼schel
              Santiago Aucejo Petzoldt Santiago Aucejo Petzoldt
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: