The table adtinfo is used to store Navigator audit records. These records are controlled by the settings in the web security audit profile. See How do I audit usage of requests or changes made using Navigator for additional information.
The size of the table is controlled in the workgroup server properties with a default of 0 (zero) which is unlimited. If you want to limit the size, setting a value other than 0 will cause the audit table to wrap around at that value. That is, a value of 50000 will grow until 50000 records are in it and then start overwriting the oldest records.
With this method, the interval of data is not fixed. Many organizations have a requirement to keep audit data for a specific number of days, months or years which a specific size does not guarantee. In this case, the size needs to be left at 0 (unlimited) and you will need to periodically prune old data from the tables.
The following is sample SQL for MySQL that would remove all audit data greater than 30 days old.
delete from adtinfo where from_unixtime(audit_time_stamp) < CURDATE() - INTERVAL 30 DAY;
The following is sample SQL for Oracle DB that would remove all audit data greater than 30 days old.
delete from adtinfo where to_date('19700101', 'YYYYMMDD') + NUMTODSINTERVAL(audit_time_stamp , 'SECOND' ) < CURRENT_TIMESTAMP - NUMTODSINTERVAL(30, 'DAY');
One method to prune the data automatically would be to put this query in an AutoPilot M6 SQL Query expert and configure the expert to run once a day by setting the Sampling rate (sec) to 86400.