Hello.
We are currently on GP 2018 on-prem.
We are in the process of setting up audit trailing within GP and I had a question around the management of this audit trail data once enabled.
Is it as simple as archiving or purging data from DYNAMICS..SY05000 table at regular intervals? I understand there is a "remove audit trail" window in GP but I was looking at automating this log management from the back-end. Or are there a set of jobs/processes provided by MS to archive/purge this data.
Additionally, roughly how often would this archiving need to happen to prevent any impact on the performance of GP - I know this is a difficult question to answer without other details but looking for a ballpark figure - how big would this table need to get to start having performance issues.
TIA