Create a table cleanup rule in Core UI

task brazil Updated Sep 10, 2026 2 min read activate-table-cleanup.md
Raw file servicenow.com

Define the criteria for deleting unwanted records in a table cleanup rule.

Before you begin

Role required: admin

Procedure

  1. Access the new Auto Flush form in one of the following ways.

Option

Steps

Using the Data Management Console

  1. Navigate to All > System Data Management > Data Management Console > ****.
  2. On the Overview tab, select New cleanup rule.

Using a data management policy

  1. Navigate to All > System Data Management > Data Management Policies.
  2. Select the data management policy for the table with records that you want to delete.
  3. In the Table Cleanup Rules related list, select New.
2. On the form, fill in the fields.

Field

Description`

Tablename

The name of the target table.

Matchfield

The Date/Time field in the target table that is used to monitor duration. Defaults to sys_created_on, which deletes records based on the amount of time since their creation date.

Age in seconds

The amount of time the system waits before deleting records. When the Matchfield value becomes older than the Age in seconds, the record is deleted.

Active

Option to activate or deactivate table cleaning for this table.

Application

The application scope to which this table cleaner job applies.

Clean journals

If selected, related records in the Journal Entry [sys_journal_field] table are also deleted.If cleared, the system deletes records from the target table, but not any related journal records in this table.

Clean audit

If selected, related records in these audit tables are also deleted:- Sys Audit [sys_audit] table

  • Audit Relationship Change [sys_audit_relation] table Note that the audit records that are created by table cleaner in the Audit Deleted Record [sys_audit_delete] table are preserved.

If cleared, the system deletes records from the target table, but not any related audit records in these tables.

Cascade delete

If selected, this option deletes all matching records plus any records referring to them. If cleared, the system deletes matching records, but not records referring to them.

Conditions

Condition builder for specifying filter conditions that define the records to be removed. For example, you might specify that only records where 'active = false AND state =closed' are deleted.

3. Select **Submit**.

Result

The table cleanup rule runs automatically and deletes records when they meet the specified record age and any conditions that you set for them.

Parent Topic:Deleting older or unwanted records in Core UI

Search documentation
Search document titles and file paths on the brazil branch