Use ScriptRunner to purge trash over X days old

Question

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

Renni Verho · Answer

/*
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} "

Danny Prill_9k1s2j · Answer

@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 · Answer

Managed to create automated script which is running regularly.