Liferay 6.2 script to remove all old document versions except the latest version. This version can be tasked per-site and /or specific site's folder.

lr62-delete-old-docs-per-site.groovy

// Find and delete old versions of docs per site...

import com.liferay.portal.model.User;
import com.liferay.portal.service.UserLocalServiceUtil;
import java.util.List;
 
import com.liferay.portal.kernel.repository.model.FileEntry;
import com.liferay.portal.kernel.repository.model.FileVersion;
import com.liferay.portal.kernel.repository.model.Folder;
import com.liferay.portlet.documentlibrary.service.DLAppServiceUtil;
import com.liferay.portlet.documentlibrary.service.DLFileVersionLocalServiceUtil;
import com.liferay.portlet.documentlibrary.model.DLFileVersion;

import com.liferay.portlet.documentlibrary.service.DLFileEntryLocalServiceUtil;
import java.text.SimpleDateFormat;
import com.liferay.portal.kernel.util.FastDateFormatFactoryUtil;

previewMode = true;

if(previewMode) {
  out.println(
    """<div class="portlet-msg-alert">Preview mode is on: switch off the flag and execute this script 
    again to make changes to the database</div>""")
}

def SCRIPT_ID = "Remove-File-Versions-Site"

outputFile = new File(
  """${System.getProperty("liferay.home")}/scripting/out-${SCRIPT_ID}.txt""")

outputFile.getParentFile().mkdirs()

def trace(message) {
  out.println(message)
  outputFile << "${message}\n"
}

// Param1: Group ID
// Param2: Folder ID - Use "0" to clean the entire site.
listFiles(219471, 0);

def listFiles(groupId, folderId) {
    allfiles = DLAppServiceUtil.getFileEntries(groupId,folderId);
    for (FileEntry file:allfiles) {
         List results = file.getFileVersions(-1);
         //lrlatestversion = file.getVersion();
         thisFEId = file.getFileEntryId();
         thisVersionColl = DLFileVersionLocalServiceUtil.getLatestFileVersion(thisFEId,true);
         trueLatestVersion = thisVersionColl.getVersion();
         for(FileVersion fv : results){
              try {  
                if(fv.getVersion() != trueLatestVersion){   
                   trace('This version: ' + fv.getVersion() + ' with Title=' + fv.getTitle() + ' is older than ' + trueLatestVersion + ' so deleting ' + fv.getVersion()  );
                    if(!previewMode) {
                      DLAppServiceUtil.deleteFileVersion(file.getFileEntryId(), fv.getVersion() );
                    }
                }
              } catch (Exception e1) {
              println(e1)
              e1.printStackTrace(out)
              }
         }
     }
 
     allfolders = DLAppServiceUtil.getFolders(groupId,folderId);
     for (Folder folder:allfolders) {
          try {
            trace("Checking Folder: " + folder.getName());
           listFiles(groupId,folder.getFolderId());
          } catch (Exception e2) {
            println(e2)
            e2.printStackTrace(out)
          }           
     }
}