Purge Time-based Data Associated with Variables

You can purge time-based data associated with selected variables. You can select variables by data source, sampling type, and event type, or by production line and production unit.

NOTE: The first time you purge data, if you are purging data from Deleted_Variables, it may be more efficient to first purge data from the Tests table, then purge data from the Deleted Variables table and any other tables.

IMPORTANT: When you select variables, the retention period and records per batch for the Tests table cannot be changed.

To configure a data purge for selected variables

  1. Click Start, point to All Programs, point to Proficy Plant Applications Database Purge, and click Plant Applications Database Purge. The Plant Applications Purge Configuration dialog box appears.

  1. On the Variables (Time Based) tab, click Search. The Search Variable dialog box appears.

  2. Select one or more time-based variables and click OK. The selected variables are added to the Variables (Time Based) page.

NOTE: The retention period and records per batch default to the numbers in the Retention (Months) and Records Per Batch fields at the bottom of the Plant Applications Purge Configuration dialog box.

NOTE: To delete one or more variables, select the variable(s) and press DELETE.

  1. If necessary, change the retention period and the records per batch. For more information, see the topic, Editing retention periods and records per batch.

  2. If desired, click the Units (Event Based) or Tables tabs to purge data associated with units or variables. For instructions on purging data associated with units, see the topic Purge event-based data for selected units. For instructions on purging data from specific tables, see the topic Purge data for selected tables.

  3. Save your configuration. For detailed instruction on saving a configuration, see the topic, Save a purge configuration.

NOTE: You must save your configuration before you can run a purge.

Show video