Few tables in AutomationEdge database get populated with a large amount of data. Over a period of time the records in these tables need to be purged so that the system can run optimally.
Purging allows setup a Purge Policy and Purge Schedule to purge these database tables as needed. This results in, reduction of database and disk space usage and in turn increases AutomationEdge system performance.
Purging option is available for the following data tables,
- Audit Logs
- Workflow Requests
- Notification History
On AE UI a Purging menu under Settings has been introduced for purging this data. Purging has three menu options, Purge Policy, Purge Schedule and Archives.
Following are the Purging options permissions,
- A System Administrator has permissions to setup Purge Policy and Purge Schedule,
- A Tenant Administrator can only edit the Purge Policy at the Tenant level setup by a System Administrator. A Tenant Administrator cannot setup or edit a Purge Schedule.
- Tenant level Archives are only visible with an option to download to Tenant Administrators.
Since a System Administrator has permissions to setup and view only Purge Policy and Purge Schedule, these two menu options are discussed below,
Purge Policy determines Purge Duration (in months) for each of the table data for Audit Logs, Workflow Requests and Notification History. A System Administrator can set a Purge Policy while a Tenant Administrator can only edit the policy.
Following are the steps to create a Purge policy,
- Navigate to PurgingPurge Policy menu
- Click Add button
Figure 13a: Add Purge policy
- The Purge Policy page appears.
Figure 13b: Purge Policy Configurations
- Provide desired Purge Duration in months for each of the four tables.
- Set Notification details. Click Save.
Figure 13c: Purge policy details
- Purge Policy saves successfully message is displayed as seen below.
Figure 13d: Purge Policy Saved Successfully
A System Administrator can create a Purge Schedule whereas a Tenant Administrator can only view a Purge Schedule created by the System Administrator.
Following are the steps to create a Purge Schedule,
- Navigate to PurgingPurge Schedule menu.
- Click Add button.
Figure 13e: Add Purge Schedule
- Purge Schedule configuration page appears based on Day of Month as seen below.
Figure 13f: Purge Schedule Configuration
- Criteria dropdown has two values Day of Month and Day of Week as seen below.
Figure 13g: Choose Purge Schedule Criteria
- Let us setup a Purge Schedule based on Day of Month as seen below. Click Save.
Figure 13h: Purge Schedule Details based on Day of Month
- Purge Schedule created successfully message appears as seen below.
Figure 13i: Purge Schedule Created
- You may now edit this schedule or delete this schedule and create a new schedule.
- Select the second option for Criteria from the drop down list is Day of Week. Purge Schedule configuration page appears as below.
Figure 13j: Purge Schedule Details based on Day of Week
- This completes the process to create a Purge Schedule.