How do you guys purge System Activity records?
When I open the search box in System Activity Purge, there is no option to enter a cut-off date. Unfortunately, in 10 months, this table has grown to 30GB and 90M rows! I bet “return all records” would crash Epicor, or put a serious hurt on the DB.
I tried entering a date in the ‘Starting At’ searchbox - It wouldn’t take a forward slash, so I entered the date as 02162019 for Feb 16, 2019, but the search returned results after that date.
I wasn’t able to get a QuickSearch or BAQ search set up, since BAQ would time out during my testing.
To delete old System Activity Log records:
- Within Epicor, from the main menu navigate to System Management > Purge/Cleanup Routines > System Activity Purge.
- Click the search button.
- Select an Ending date of one month earlier from today (or some other criteria)