Purge events by query

Prev Next

You can use a custom configured query as a base to delete client events.

You must have created a query to find the events you want purged before you start this task.

There are reasons why you might need to purge data or events based on a query. For example, there can be many specific events overwhelming your database. In this example, you might not want to wait for the event to age out if you are keeping your events for six months. Instead you want that specific event deleted immediately or nightly.

Purging these events can significantly improve the performance of your ePO - On-prem server and database.

Configure purging data based on the results of a query.

For details about product features, usage, and best practices, click ? or Help.

  1. Select MenuAutomationServer Tasks, then click ActionNew Task to open the Server Task Builder.

  2. Type a name for the task, for example Delete 1059 client events, then on the Actions tab, click Purge Client Events from the Actions list.

  3. Click Purge by Query, then select the custom query that you created.

    Note

    This menu is automatically populated when table queries are created for client events.

  4. Schedule the task to run every day during non-business hours, then click Save.