Layer7 API Management

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Useful SQL statements to manage Audit Records

  • 1.  Useful SQL statements to manage Audit Records

    Posted Apr 12, 2017 06:29 AM

    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

     

    Audit records in ssg db - CA Knowledge 

     

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

     

    Regards

    Christopher Clark

    CA APIM Support