-
Suggestion
-
Resolution: Fixed
-
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.
[JSDSERVER-5266] Provide clean up schedule job for AO_54307E_SLAAUDITLOGDATA
Remote Link | New: This issue links to "Page (Confluence)" [ 852349 ] |
Remote Link | Original: This issue links to "JSDS-961 (JIRA Server (Bulldog))" [ 308016 ] | New: This issue links to "JSMDC-961 (JIRA Server (Bulldog))" [ 308016 ] |
Remote Link | New: This issue links to "Page (Confluence)" [ 562404 ] |
Remote Link | New: This issue links to "Page (Confluence)" [ 483900 ] |
Workflow | Original: JAC Suggestion Workflow [ 3011937 ] | New: JAC Suggestion Workflow 3 [ 3647030 ] |
Status | Original: RESOLVED [ 5 ] | New: Closed [ 6 ] |
Workflow | Original: Confluence Workflow - Public Facing v4 [ 2665499 ] | New: JAC Suggestion Workflow [ 3011937 ] |
Workflow | Original: JSD Suggestion Workflow - TEMP [ 2411110 ] | New: Confluence Workflow - Public Facing v4 [ 2665499 ] |
Status | Original: Closed [ 6 ] | New: Resolved [ 5 ] |
Resolution | New: Fixed [ 1 ] | |
Status | Original: Open [ 1 ] | New: Closed [ 6 ] |
Assignee | New: Matthew McMahon [ mmcmahon ] |
A cleanup job has been added to 3.7.0
This will run once a day and look for the follow data to delete: