Use ScriptRunner to purge trash over X days old

[Doug]

Is it possible to create a Confluence ScriptRunner script/job to purge items in space trash that have been there over X amount of days? Looking for an automated way to clean up spaces every 90 days or so to reduce storage. Thanks

[Tony Gough [Adaptavist]]

Hi Doug,

We do have a built-in script 'Bulk Purge Trash' which purges the trash of a specific space, or all spaces. Built-in scripts require manually running, however.

To run custom scripts on a schedule, we have the Script Job feature, which you can read more about in the documentation:

https://scriptrunner.adaptavist.com/latest/confluence/ScriptJobs.html

This involves defining a CRON expression which specifies how often the script should run. Additionally, there are example expressions within the Script Job page on the app itself.

I hope this is useful to you, please let me know if you have any further questions!

Kind regards,
Tony

[Renni Verho]

Is that "Bulk Purge Trash" removed in latest plugin version as I cannot find it ? 

[Renni Verho]

Managed to create automated script which is running regularly. 

[Danny Prill]

@Renni Verho 

It would be great, if you could post your script. I've searched the whole internet ;) and cannot find a solution or a script.

Could you?

[Renni Verho]

/*
Script to clean trash from confluence space(s)
script is modified version of script in https://jira.atlassian.com/browse/CONFSERVER-30043
*/

package com.onresolve.confluence.scripts
import com.atlassian.confluence.pages.TrashManager
import com.atlassian.confluence.spaces.SpaceManager
import com.atlassian.confluence.spaces.SpacesQuery
import com.atlassian.confluence.user.AuthenticatedUserThreadLocal
import com.atlassian.spring.container.ContainerManager
import org.apache.log4j.Level
import org.apache.log4j.Logger

def logging = Logger.getLogger("com.onresolve.confluence.scripting.EmptyTrashSpaces")
logging.setLevel(Level.DEBUG)

def trashManager = ContainerManager.getComponent("trashManager") as TrashManager
def spaceManager = ContainerManager.getComponent("spaceManager") as SpaceManager
def spacesQuery = SpacesQuery.newQuery().forUser(AuthenticatedUserThreadLocal.get()).build()
def Spaces = []

// clean all spaces :
Spaces = spaceManager.getAllSpaces(spacesQuery)
logging.info("spaces found : ${Spaces}")

//Way to clean just selected spaces :
/*
Spaces = []
Spaces << spaceManager.getSpace("DEMO")
*/

logging.warn("Spaces trash to be cleaned: ${Spaces}")

Spaces.each {space ->
logging.warn("Empty trash from space: ${space.name}")
trashManager.emptyTrash(space)
}

"Emptied trash from ${Spaces.size()} spaces. List of spaces: ${Spaces} "