Configuring trend and application data retention

Web Security Help | Web Security Solutions | Version 7.8.x

Related topics:

Log Database administration settings

Configuring database partition options

Configuring how URLs are logged

Configuring Log Database maintenance options

Configuring Internet browse time options

Optionally, the Log Database can store trend data to enable presentation reporting on Internet activity trends. When trend reporting is enabled, the ETL database job (see Database jobs) adds daily trend data to the catalog database, and the trend job runs nightly to store weekly, monthly, and yearly trend information.

The Log Database also stores statistical data (like bandwidth and count) for browsers, operating system platforms, and user agent strings to enable application reporting.

Configuring trend data

Use the Trend Data Retention section of the Settings > Reporting > Log Database page to specify how long trend data should be retained in the Log Database.

Mark Store trend data to prompt the ETL job to store trend data, and to activate the nightly trend job.

Trend data is calculated only for data collected while this option is enabled.

Data stored in the database before trend data retention is enabled, or data collected after the option is disabled, cannot be included in trend reports.

When this option is disabled, the Trend database job runs only to process threat-related data in the AMT partition.

Indicate how long to store weekly, monthly, and yearly trend data. Note that increasing the length of time trend data is stored increases the size of the Log Database (see Log Database sizing guidance).


	Note Because trend data is stored in the catalog database, rather than the partition database, trend data storage periods are not dependent on how long database partitions are retained.

The default storage periods for trend data are:


	SQL Server	SQL Server Express
Daily	90 days	60 days
Weekly	26 weeks	13 weeks
Monthly	18 months	6 months
Yearly	5 years	3 years

The nightly trend job purges data when it is older than the specified retention period.

Click OK to cache your changes. Changes are not implemented until you click Save and Deploy.

Configuring application data

Use the Application Data section of the Settings > Reporting > Log Database page to determine how long to keep the statistical data used to populate applications reports (on the Browser, Source Platform, and Search tabs of the Applications page).

The time period you select does not affect how long the actual user agent strings are stored. Those are preserved indefinitely. It only affects statistical information, like bandwidth, number of requests, and number of machines.

By default, statistical data for applications reports is stored for 30 days. To select another value:

Select a new time period from the Keep data for drop-down list. Depending on your database engine, data may be kept for up to 90 days.

Click OK to cache your changes. Changes are not implemented until you click Save and Deploy.