K2BAudit Analyzer - Removing query data


As audit data is collected, the audit database will grow with each audited operation stored. In many cases, it is necessary to purge old audit records as they use a lot of storage space and they are no longer useful.


In order to delete old records, K2BAuditAnalyzer contains an option called "Remove Old Records" that allows the user to delete all records up to a certain date (chosen by the user).

Remove old records option

A developer could also use this as an example and build programs to delete old data periodically. For example, the developer could create a procedure that deletes data older than one year, and schedule it so that it is executed automatically.