• Icon: Suggestion Suggestion
    • Resolution: Fixed
    • 3.7.0
    • None
    • None
    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Problem Definition

      We currently have an SLA Audit Log introduced since JSD 3.4.1 for troubleshooting SLA. Although this feature isn't designed for end users and should require no maintenance by Service Desk admins, there is no automatic house-cleaning provided for the data it accumulates in AO_54307E_SLAAUDITLOGDATA and AO_54307E_SLAAUDITLOG tables.

      On a heavily used JSD instance this tables could swell up to millions of records within a few months.

      Suggested Solution

      Provide a scheduled job to clean up the AO_54307E_SLAAUDITLOGDATA and AO_54307E_SLAAUDITLOG tables, or allow some configurable clean up schedule.

            [JSDSERVER-5266] Provide clean up schedule job for AO_54307E_SLAAUDITLOGDATA

            Mr. Mouton made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 852349 ]
            Konde made changes -
            Remote Link Original: This issue links to "JSDS-961 (JIRA Server (Bulldog))" [ 308016 ] New: This issue links to "JSMDC-961 (JIRA Server (Bulldog))" [ 308016 ]
            Elton Santos made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 562404 ]
            Archana Menon made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 483900 ]
            Katherine Yabut made changes -
            Workflow Original: JAC Suggestion Workflow [ 3011937 ] New: JAC Suggestion Workflow 3 [ 3647030 ]
            Status Original: RESOLVED [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: Confluence Workflow - Public Facing v4 [ 2665499 ] New: JAC Suggestion Workflow [ 3011937 ]
            Owen made changes -
            Workflow Original: JSD Suggestion Workflow - TEMP [ 2411110 ] New: Confluence Workflow - Public Facing v4 [ 2665499 ]
            Status Original: Closed [ 6 ] New: Resolved [ 5 ]
            Matthew McMahon (Inactive) made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: Open [ 1 ] New: Closed [ 6 ]
            Matthew McMahon (Inactive) made changes -
            Assignee New: Matthew McMahon [ mmcmahon ]
            Matthew McMahon (Inactive) made changes -
            Fix Version/s New: 3.7.0 [ 72395 ]

              mmcmahon Matthew McMahon (Inactive)
              takindele Taiwo Akindele (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: