How to delete Change Log

Information

• Products: Sparkrock 2016
• Summary: Procedure to delete Change Log Entries

Details

It is important to delete the accumulated Change Log Entries once in a while or after a period/fiscal year is audited and closed, so as to clean up space in the database. Also, older data grows increaslingly redundant with time.

Cause

Not Applicable

Impact / Risks

Failure to regularly delete the Change Log Entries may take up a large amount of database space and will affect performance, especially when many tables and fields are tracked.

Resolution

To delete the accumulated Change Log Entries, search for Delete Change Log Entries and choose that function. You will see a page like this below:

You should enter a value in the available filters, like 'Date and Time' to only delete the logs up to a certain date. You may also enter a date range, or leave it blank if you need to clean up the entire table of data. Choose OK to perform the deletion.

Workaround

Not applicable

Related Information

Change Log - Setup and Best Practices

Update History

Date	Details	Link
12/30/2019	The first version of this KnowledgeBase article was created.

 

Keywords/tags

change log, maintenance

Attachment

Not applicable