I just published the following KB with a number of useful sql statements around audit records:-
- The size of the DBs in the MySQL instance
- The amount of data per table
- The newest and oldest audit record
- The number of audit records it contains
- The date range of these records
Please review and comment on if you find useful or spot improvements.
CA APIM Support