Re: Powershell script to delete all versions of files in a sharepoint site from all libraries

Greg_from_Pond 

Yes you are correct, from what I can see His script is generate from ChatGPT/Copilot and he hasn't looked through it, which can cause problems as GPT makes things up as it goes sometimes....Which in this case would have been pretty dangerous...

This script should do it for you, change the 5 to how many you want to save:

# This script deletes all but the 5 latest versions of each document in a SharePoint Online library

# Connect to SharePoint Online site
$siteUrl = "https://contoso.sharepoint.com/sites/MySite"
Connect-PnPOnline -Url $siteUrl -Interactive

# Get the library name
$libraryName = "Documents"

# Get all the items in the library
$items = Get-PnPListItem -List $libraryName

# Loop through each item
foreach ($item in $items) {
    # Get the file object
    $file = $item.File

    # Get the versions of the file
    $versions = $file.Versions

    # Sort the versions by creation date in descending order
    $sortedVersions = $versions | Sort-Object -Property Created -Descending

    # Skip the first 5 versions and delete the rest
    $sortedVersions | Select-Object -Skip 5 | ForEach-Object {
        $_.DeleteObject()
    }
}

Hi rohankapz,

To fix the script error you are getting, you need to install the Microsoft SharePoint Online Client Library. You can do this by running the following command in PowerShell:

Install-Module -Name Microsoft.SharePointOnline.CSOM -Force -AllowClobber

Once the module is installed and imported:

Import-Module Microsoft.SharePoint.Online.CSOM

you should be able to run the script without any errors.

# Install the Microsoft SharePoint Online Client Library
Install-Module -Name Microsoft.SharePointOnline.CSOM -Force -AllowClobber

# Import the SharePoint Online Client Library
Import-Module Microsoft.SharePoint.Online.CSOM

# Connect to the SharePoint Online site
$siteUrl = "https://contoso.sharepoint.com/sites/my-site"
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)

# Get all the web libraries in the site
$web = $ctx.Web
$libraries = $web.Lists

# Iterate through each library and delete all versions of all files and folders
foreach ($library in $libraries) {
    # Get all the files in the library
    $files = $library.Files

    # Iterate through each file and delete all versions
    foreach ($file in $files) {
        # Get the file's version history
        $versionHistory = $file.VersionHistory

        # Keep the latest 10 versions and delete the rest
        $versionsToDelete = $versionHistory.Where({ $_.VersionLabel -eq "1.0" -or $_.VersionLabel -eq "2.0" -or $_.VersionLabel -eq "3.0" -or $_.VersionLabel -eq "4.0" -or $_.VersionLabel -eq "5.0" -or $_.VersionLabel -eq "6.0" -or $_.VersionLabel -eq "7.0" -or $_.VersionLabel -eq "8.0" -or $_.VersionLabel -eq "9.0" })
        foreach ($versionToDelete in $versionsToDelete) {
            $versionToDelete.Delete()
        }
    }
}

# Execute the script
$ctx.ExecuteQuery()