Deleting old data from 'AUDIT_AUDITEVENT' table in 6.2

Issue

• I want to clean up the AUDIT_AUDITEVENT table because the old data is taking up too much space.

Environment

• Portal 6.2

Resolution

Note: The following information involves customizations that are beyond the scope of Liferay Support. Please exercise appropriate discretion in the use of this information to choose or to customize the API based on your requirement.

• Liferay does not recommend altering the database directly. Therefore, if looking to clean up the table, utilize the following APIs and create a custom script to delete Audit Events.

  AuditEventLocalServiceBaseImpl.deleteAuditEvent(long auditEventId)
  AuditEventLocalServiceBaseImpl.deleteAuditEvent(AuditEvent auditEvent)

Additional Information

• Please see the following documentation on scripting to help in the customization process: Introduction to Using Scripting for Advanced Flexibility.