Maintaining the administrator log

You can delete the log entries before the specified 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.