The SMS database cleanup processes leverage the retention policies. The database needs
to be managed to ensure its size does not exceed a desired maximum. By removing old
data and limiting the amount of data stored for a particular data type, the database
size can be constrained.
The SMS performs automatic cleanup procedures based on the values specified in the
maintenance settings of the retention policies, that is, the age of the data and maximum
rows allowed. The cleanup process removes rows that are older than the Age setting
and also decreases the number of stored rows so as not to exceed MaxRows. This cleanup
process is automatically performed at least one time within a 24-hour period. You
have the ability to initiate an immediate clean up and to edit the retention values.
The Database Maintenance area displays the following information.
| Column | Description |
| Data | Name of the database data. |
| Rows | Current number of rows of data in the database. |
| Max Rows | Maximum number of rows for the data in the database. The system clears records at the end of the list to make room for the newest entries, always keeping the number of total records equal to or less than this value. You can edit this value. |
| Age | Number of days to keep data before clearing it. The system clears data older than this setting. You can edit this setting. |
| Status | Cleanup status. |
| Last Cleanup | Last time the entries were cleaned. Cleanup occurs daily. You can also initiate an immediate cleanup by clicking Cleanup Now. |
| Events | Filter hits retrieved from managed devices. |
| Audit Log | Audit log records for the SMS. |
| Malware DV | Auxiliary DV (Threat DV) filter package for the SMS. |
| Core Controller Flow Management Method Stats | Flow Management Method Stats for managed Core Controllers. |
| Device Audit Log | Audit log records for managed devices. |
| Device Monitoring Data | Monitoring statistics for managed devices. |
| Device System Log | System log records for managed devices. |
| Device Traffic Data | Traffic statistics for managed devices. |
| DV | Digital Vaccine for the SMS. |
| Historical Events | Filter hit-based data for SMS reporting. |
| Historical DDOS Stats | Device DDOS statistics for SMS reporting. |
| Historical IP User Mapping | IP user mapping data for SMS reporting. |
| Historical Port Traffic Stats | Device port traffic statistics for SMS reporting. |
| Historical Rate Limit Stats | Device rate limit statistics for SMS reporting. |
| Network Mapping | Network mapping and IP correlation data for Responder. |
| IP Address Lookup Results | IP addresses and IP address groups for event IP address lookup. |
| IP User Mapping | IP user and group mapping. |
| Device SSL Log | SSL inspection log for managed devices. |
| Next Generation VPN Log | VPN logs from managed NGFW appliances. |
| Notifications | Latest SMS and managed device log notifications. |
| Profile Change History | Inspection profile version history. |
| Response History | Response History events for Responder. |
| sFlow® | sFlow® statistics from managed devices. |
| SMS Monitoring Data | SMS-specific monitoring data. |
| Events HTTP Context | URI metadata (i.e., hostname, URI, and Method) from managed devices. |
| User ID IP Correlation | User log in and group information from the Identity Agent. |
| VPN | X-series VPN logs. |
| Segment Traffic Stats | Segment traffic statistics from managed devices. |