Purging Database Tables > File Analytics Database Tables
   
Version 9.1.01
File Analytics Database Tables
These File Analytics tables are for logs that may need to be periodically purged.
Table Description
Table Name
Default Retention
Notes
Data growth log
apt_afa_data_growth_log
6 Months
KEEP_AFA_DATA_GROWTH_LOG_MONTHS
File size log
apt_afa_file_size_log
6 Months
KEEP_AFA_FILE_SIZE_LOG_MONTHS
Largest file log
apt_afa_largest_files_log
6 Months
KEEP_AFA_LARGEST_FILE_LOG_MONTHS
File type log
apt_afa_file_types
6 Months
KEEP_AFA_FILE_TYPE_LOG_MONTHS
File category log
apt_afa_file_category
6 Months
KEEP_AFA_FILE_CATEGORY_LOG_MONTHS
File lifetime log
apt_afa_file_lifetime_log
6 Months
KEEP_AFA_FILE_LIFETIME_LOG_MONTHS
File summary log
apt_afa_file_summary_log
4 Months
KEEP_AFA_FILE_SUMMARY_LOG_MONTHS
File duplication log
apt_afa_file_duplication_log
6 Months
KEEP_AFA_FILE_DUPLICATION_LOG_MONTHS
File capacity log
apt_afa_file_capacity_log
6 Months
KEEP_AFA_CAPACITY_LOG_MONTHS
Owner category log
apt_afa_owner_category_log
2 Months
KEEP_AFA_OWNER_LOG_MONTHS
Example of Customizing the Data Retention Period:
update ptl_system_parameter set param_value = ‘6’
where param_name =' KEEP_AFA_OWNER_LOG_MONTHS’;