ChristopherClark

Useful SQL statements to manage Audit Records

Discussion created by ChristopherClark Employee on Apr 12, 2017

Hello

 

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

 

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1981945.html

 

 

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

 

Regards

Christopher Clark

CA APIM Support

Outcomes