Powershell script to delete all versions history in Sharepoint Site

Question

Hi All,&nbsp;I have a SharePoint script which is designed to delete all version history for all files in a SharePoint site but keep the 10 latest versions of the files. Script is attached but i am always getting this error when running the script.&nbsp; Site URL is correct and the user profile has Site Owner/Admin privileges at full control on the SharePoint site. Please can we get some help asap as we have 50 GB left in our ORG and are loosing 10 GB Per day and by end of this week we will run of SharePoint storage even though we have 2.4 TB&nbsp;&nbsp;MethodInvocationException:Line |50 | $ctx.ExecuteQuery()| ~~~~~~~~~~~~~~~~~~~| Exception calling "ExecuteQuery" with "0" argument(s): "The remote server returned an error: (400) Bad Request."MethodInvocationException:Line |31 | $ctx.ExecuteQuery()| ~~~~~~~~~~~~~~~~~~~| Exception calling "ExecuteQuery" with "0" argument(s): "The remote server returned an error: (400) Bad Request."OperationStopped:Line |33 | foreach ($file in $folder.Files) {| ~~~~~| The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.MethodInvocationException:Line |40 | $ctx.ExecuteQuery()| ~~~~~~~~~~~~~~~~~~~| Exception calling "ExecuteQuery" with "0" argument(s): "The remote server returned an error: (400) Bad Request."OperationStopped:Line |42 | foreach ($subFolder in $folder.Folders) {| ~~~~~~~~~~| The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.Completed. Kept the latest 10 versions for all files in the site.PS C:\PowerShell-7.3.7-win-x64&gt;&nbsp;

leonpavesic · Answer

Hi&nbsp;rohankapz,The error message The remote server returned an error: (400) Bad Request. can occur for a number of reasons, such as:The SharePoint site URL is incorrect.The user account does not have the necessary permissions to delete version history.There is a problem with the SharePoint site.You can try this&nbsp;PowerShell script to delete all version history in Sharepoint Site:&nbsp;# Import the SharePoint Client Library
Import-Module SharePointPnPPowerShellOnline

# Connect to the SharePoint site
$siteUrl = "https://&lt;your-sharepoint-site-url&gt;"
Connect-SPOService -Url $siteUrl

# Get the root folder of the SharePoint site
$rootFolder = Get-SPOFolder -Url $siteUrl

# Delete all version history for all files in the SharePoint site
foreach ($file in $rootFolder.Files) {
    $file.VersionHistory.DeleteAll()
    $ctx.ExecuteQuery()
}

# Delete all version history for all subfolders in the SharePoint site
foreach ($subFolder in $rootFolder.Folders) {
    Delete-SPOFolderVersionHistory -FolderUrl $subFolder.Url
}

# Disconnect from the SharePoint site
Disconnect-SPOService&nbsp;&nbsp;Please click Mark as Best Response &amp; Like if my post helped you to solve your issue.This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.Kindest regards,Leon Pavesic(LinkedIn)

rohankapz · Answer

Hi LeonPavesic ,Can i have an updated script which keep the 10 latest versions. I have full control permissions on the site and SharePoint URL is correct.?

leonpavesic · Answer

Hi&nbsp;rohankapz,you can try to use this script:&nbsp;&nbsp;# Import the SharePoint Client Library
Import-Module SharePointPnPPowerShellOnline

# Connect to the SharePoint site
$siteUrl = "https://&lt;your-sharepoint-site-url&gt;"
Connect-SPOService -Url $siteUrl

# Get the root folder of the SharePoint site
$rootFolder = Get-SPOFolder -Url $siteUrl

# Get all the files in the root folder
$files = $rootFolder.Files

# Iterate through each file and delete all versions but the latest 10
foreach ($file in $files) {
    $versionHistory = $file.VersionHistory

# Sort the versions by creation date, descending
    $versions = $versionHistory.OrderByDescending({ $_.CreationTime })

# Keep the latest 10 versions and delete the rest
    $versionsToDelete = $versions | Select-Object -Skip 10
    foreach ($versionToDelete in $versionsToDelete) {
        $versionToDelete.Delete()
    }

# Execute the changes
    $ctx.ExecuteQuery()
}

# Disconnect from the SharePoint site
Disconnect-SPOService&nbsp;To use this script, simply replace the &lt;your-sharepoint-site-url&gt; placeholder with the URL of your SharePoint site. Then, run the script in elevated PowerShell or you can use SharePoint Online Management Shell:Download SharePoint Online Management Shell from Official Microsoft Download CenterIt is important to have&nbsp;the latest version of the SharePoint PnP PowerShell Online module.To install the latest SharePoint PnP PowerShell Online module, you can use the following steps:Open PowerShell with elevated privileges.Run the following command:&nbsp;&nbsp;Install-Module PnP.PowerShell -Scope CurrentUser&nbsp;This will install the latest stable version of the SharePoint PnP PowerShell Online module for the current user.&nbsp;Once the module is installed, you can import it into your PowerShell session using the following command:&nbsp;Import-Module PnP.PowerShell&nbsp;If you are already using the SharePointPnPPowerShellOnline module, you can uninstall it before installing the PnP.PowerShell module. To uninstall the SharePointPnPPowerShellOnline module, run the following command:&nbsp;Uninstall-Module -Name SharePointPnPPowerShellOnline -AllVersions -Force&nbsp;&nbsp;Please click Mark as Best Response &amp; Like if my post helped you to solve your issue.This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.Kindest regards,Leon Pavesic(LinkedIn)

rohankapz · Answer

Hi LeonPavesic,I was able to add the modules and run the Connect SPO command, but when i try to run the script you provided i get the following errors.PS C:\Windows\system32&gt; # Import the SharePoint Client LibraryImport-Module SharePointPnPPowerShellOnline# Connect to the SharePoint site$siteUrl = "https://essensysuk.sharepoint.com/sites/Rohantest"Connect-SPOService -Url $siteUrl# Get the root folder of the SharePoint site$rootFolder = Get-SPOFolder -Url $siteUrl# Get all the files in the root folder$files = $rootFolder.Files# Iterate through each file and delete all versions but the latest 10foreach ($file in $files) {$versionHistory = $file.VersionHistory# Sort the versions by creation date, descending$versions = $versionHistory.OrderByDescending({ $_.CreationTime })# Keep the latest 10 versions and delete the rest$versionsToDelete = $versions | Select-Object -Skip 10foreach ($versionToDelete in $versionsToDelete) {$versionToDelete.Delete()}# Execute the changes$ctx.ExecuteQuery()}# Disconnect from theWARNING: The names of some imported commands from the module 'SharePointPnPPowerShellOnline' include unapproved verbs that might make them less discoverable. To find the commands with unapproved verbs, run the Import-Module command again with the Verbose parameter. For a list of approved verbs, type Get-Verb.Connect-SPOService : No valid OAuth 2.0 authentication session existsAt line:6 char:1+ Connect-SPOService -Url $siteUrl+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : NotSpecified: (:) [Connect-SPOService], AuthenticationException+ FullyQualifiedErrorId : Microsoft.Online.SharePoint.PowerShell.AuthenticationException,Microsoft.Online.SharePoint.PowerShell.ConnectSPOServiceGet-SPOFolder : The term 'Get-SPOFolder' is not recognized as the name of a cmdlet, function, script file, or operableprogram. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.At line:9 char:15+ $rootFolder = Get-SPOFolder -Url $siteUrl+ ~~~~~~~~~~~~~+ CategoryInfo : ObjectNotFound: (Get-SPOFolder:String) [], CommandNotFoundException+ FullyQualifiedErrorId : CommandNotFoundExceptionThe collection has not been initialized. It has not been requested or the request has not been executed. It may need to beexplicitly requested.At line:15 char:10+ foreach ($file in $files) {+ ~~~~~+ CategoryInfo : OperationStopped: (:) [], CollectionNotInitializedException+ FullyQualifiedErrorId : Microsoft.SharePoint.Client.CollectionNotInitializedException

leonpavesic · Answer

Hi&nbsp;rohankapz,I'm glad you were able to install the modules and connect to your SharePoint site.However, I'm sorry to hear that you're getting errors when trying to run the script I provided.Here are some troubleshooting tips:Make sure you're using the latest version of the SharePoint PnP PowerShell Online module. You can check this by running the following command:&nbsp;Get-Module SharePointPnPPowerShellOnline&nbsp;The version number should be at least 1.24.0. If it's not, you can update the module using the following command:&nbsp;Update-Module SharePointPnPPowerShellOnline -Scope CurrentUser&nbsp;&nbsp;Make sure you're using the correct URI syntax for your SharePoint site. The error message you're getting indicates that the URI is invalid. Try using the following format:https://&lt;your-sharepoint-tenant-name&gt;.sharepoint.com/&lt;your-site-name&gt;Make sure the Get-SPOFolder cmdlet is available. This cmdlet is not included in the PnP.PowerShell module by default. To install it, run the following command:&nbsp;&nbsp;Install-Module Microsoft.Online.SharePoint.PowerShell -Scope CurrentUser&nbsp;&nbsp;The warning message you are seeing is because the SharePoint PnP PowerShell Online module includes some commands with unapproved verbs. To find the commands with unapproved verbs, run the following command:&nbsp;Import-Module SharePointPnPPowerShellOnline -Verbose&nbsp;Then try to use the script one more time.&nbsp;# Import the SharePoint Client Library
Import-Module SharePointPnPPowerShellOnline

# Connect to the SharePoint site
$siteUrl = "https://essensysuk.sharepoint.com/sites/Rohantest"
Connect-SPOService -Url $siteUrl

# Get the root folder of the SharePoint site
$rootFolder = Get-SPOFolder -Url $siteUrl

# Get all the files in the root folder
$files = $rootFolder.Files

# Iterate through each file and delete all versions but the latest 10
foreach ($file in $files) {
    $versionHistory = $file.VersionHistory

# Sort the versions by creation date, descending
    $versions = $versionHistory.OrderByDescending({ $_.CreationTime })

# Keep the latest 10 versions and delete the rest
    $versionsToDelete = $versions | Select-Object -Skip 10
    foreach ($versionToDelete in $versionsToDelete) {
        $versionToDelete.Delete()
    }

# Execute the changes
    $ctx.ExecuteQuery()
}

# Disconnect from the SharePoint site
Disconnect-SPOService&nbsp;&nbsp;Please click Mark as Best Response &amp; Like if my post helped you to solve your issue.This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.Kindest regards,Leon Pavesic (LinkedIn)

Forum Discussion

Powershell script to delete all versions history in Sharepoint Site

7 Replies

Resources