How to delete mass amount of data from FF Logs?
Does anyone know a good way to delete a mass amount of data from the FF logs?
We have a large amount of data on our FF log tables and want to remove some of it. (Our ZFFTNSLOG table has over 18 million records and the ZFFCDHDR table has over 242 million.) I tried using the Archive function found on Administration->Archive->Delete/Download Log but because of the amount of data it will only let me delete about two weeks (roughly about 40,000 records) at a time. Since I have about six years of data to remove, this isn't a real practical solution.
As a possible alternative, we could maybe get by with just getting rid of the change details. Does anyone know if we can delete all of the records from the ZFFCDHDR table without messing up our FF log reporting ability?
I also looked at running the FFArchive job, but it looks like it would delete all FF data, which we don't want to do for Audit reasons. We just want to get rid of older data.
We are on GRC 5.3 SP 18.