The SQL statistical database of the TTC Security Server consists of multiple tables that serve to record the network traffic activity and controlling actions reported by the individual IP Objects that are active within the traffic control configuration. Each data gathering Object is associated with a group of statistical tables that support the various traffic reports. The default retention period is generally set to 7 days for most of the tables, though some tables default to as high as 60 days. This accumulated data is used to generate the traffic reports as requested by network administrators or produced by scheduled functions such as daily traffic summary reports.

The Statistics Database - Tables Sizes & Retention Days provides the network administrator with a status report of this database, including current utilization and available storage space, as well as utilities to adjust the specified retention periods for the various statistical tables or to purge aged data.

Though the default retention values are sufficient for most networks, your actual administrative needs may require changes to adjust the availability of data for various reporting needs.

• The Delete column indicates the length of time that data will be stored for the associated table before it is automatically purged during nightly processing. To change a retention period, enter the desired value and click on the Update Retention button at the top or bottom of the table.
• The Restore Defaults button is used to reset the recommended values for ALL of the displayed tables. You can exercise this option to review those values without setting them into the registry. If you wish to save the default values to the registry, click on the Update Retention button.
• The Purge Now button will immediately remove ALL aged data. This function should be used after resetting the default values or decreasing a retention (Delete) value.
• Click on the Add to Favorites icon to place a direct link to this table on the Databases 'Favorites' list.

There are no SEARCH or TOOLBOX utilities associated with this table.

Statistics Database Retention Table - online Help