JS - JobScheduler
  1. JS - JobScheduler
  2. JS-1798

Provide a script for administrators to purge the Audit Log

    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=???
        

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

            • Assignee:
              Oliver Haufe
              Reporter:
              Andreas Püschel
              Approver:
              Santiago Aucejo Petzoldt
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: