Maintaining the administrator log

You can delete log entries earlier than a specific date with a simple delete command using the name of the administrator log table (alat_admin_log) and the date field (admin_log_date).

For example, the SQL statement for MSSQL and Sybase that removes the administrator log entries occurred prior to December 1, 2010 is, delete from alat_admin_log where admin_log_date < '12/1/10'.

For Oracle, you must use the date format 10-Jan-02.