Bulk Delete Attachment Versions

Use this script to delete old attachment versions throughout your instance.

Since old versions are kept each time a new version is saved, this can free up a lot of space in your instance.

Run this script

To use this script, follow these steps:

Navigate to General Configuration → ScriptRunner → Built-In Scripts.
Select Bulk Delete Attachment Versions.
In CQL Query, enter a query to select attachments.
Tip: CQL tips
- This field has CQL autocomplete. Start typing to see suggestions.
- You can select Show Examples to see and use example queries.
- For help with CQL, visit the CQL Guide.
Specify the minimum age of attachment versions you want to delete in Attachment Version Age.
Specify the minimum number to keep regardless of the age selected in Minimum Versions to Keep. Leave the field blank if you only want to retain the latest version.
CAUTION:
Important information about the Attachment Version Age and Minimum Versions to Keep fields:
- Keeping the Minimum Versions to Keep field blank retains only the current version.
- The Minimum Versions to Keep field takes precedence over the Attachment Version Age field if there is an overlap between the values.
  Example: There are 10 attachment versions, all older than one year. If the script is configured to delete attachments older than six months and keep three at a minimum, v8–v10 are kept to abide by the Minimum Versions to Keep field and v1–v7 are deleted.
- When a Minimum Number of Versions to Keep is entered, only the latest versions are kept.
  Example: If there are v1–v5 and 2 are selected to keep at a minimum, v4 and v5 (the current version) are kept.
Check the Notifications box if you want to send notifications for updates.
If the Notifications box is not checked, watchers of the page do not receive an email notification that the attachment versions have been deleted.
Select Run.
You can select Preview instead of Run to view changes before implementing them.

Once you select Run, the Result of the script appears.

Example

Delete attachments older than 5 years old

Follow these steps to run a script that deletes attachments in a certain space that are older than five years while retaining the current version:

Navigate to General Configuration → ScriptRunner → Built-In Scripts.
Select Bulk Delete Attachment Versions.
Enter a CQL Query to select attachments in a space, like type = attachment and space = DS.
Enter Older than for Attachment Version Age, and then enter 5 and select Years when the Older Than fields appear.
Enter 0 (or leave blank) for Minimum Versions to Keep to retain the current version.
Leave Notifications unchecked.
Select Run.

The script returns what attachments have been deleted: