How To: Common Task
- Log in to the SMS from a client.
- On the SMS toolbar, navigate to the Admin > Database tab.
- To Edit retention settings do one of the following:
- In the Database Maintenance area, highlight an entry and click Edit.
- In the Database Maintenance area, highlight an entry right-click and click Edit.
- In the Database Maintenance area, double-click an entry.
- On the top menu click Edit > Details.
- The Admin - Maintenance Settings dialog box opens.
- Enter a value for the maximum permitted age of data in the Clear data older than field. Data older than the entered value are removed from the database during the cleanup process.
- Enter a value for the maximum number of permitted rows in the Clear records exceeding the newest field. The database cleanup process removes 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.
- Click OK.
- In the Database Maintenance area, select an entry and click Reset.
- Confirm that you want to delete all data from the selected database table by clicking Yes.
- In the Database Maintenance area, select an entry and click Cleanup Now. Depending on settings, the system removes or archives all entries older than the Age setting and more than the set Max Rows.
Reference: SMS User Guide
