Table usage in Sophos UTM
The reporting sub-system inserts new data into the following tables:
rotate_adbs.plx moves and aggregates the last days data into the
_archive tables and
adbs_maintenance.plx removes old data (as defined in /etc/adbs_maintenance.conf, Webadmin Reporting | Settings).
_data views combine each table with it's
_archive counterpart, in order to get all the data into one query for all reporting-related tasks. The view
mailsec_contacts give easy access to the relations needed for the extended mailsecurity reporting.