Provide clean up schedule job for AO_54307E_SLAAUDITLOGDATA

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Fixed
    • 3.7.0
    • Component/s: None
    • None

      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.

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

              Created:
              Updated:
              Resolved: