Useful SQL statements to manage Audit Records

Discussion created by ChristopherClark Employee on Apr 12, 2017



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


Audit records in ssg db - CA Knowledge 


Please review and comment on if you find useful or spot improvements.



Christopher Clark

CA APIM Support