Script to cleear data workflow history lists

Question

We have 1100 sub sites in CSV and each sub site has list called "Nintex Workflow History" list

Now after selecting below "NintexWorkflowHistory" list on ribbon there is option to PURGE.

I have command to purge Nintex workflow History

Is there any script to reach to this list and execute that command. I know command. I just need to put that command in the script and perform operation on this list for 1100 sites.

Please suggest.

In case if you think this is 3rd party I just need your suggestion how we can achieve this with script.

Answer 1

Hi @sns,

Per my test, I have a csv like following pic

And you can read the csv by following script then delete the list in these Url

Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue 

#Read urls in csv
$Items = Import-Csv -Path C:\xie\SPurl.csv
$Urls = $Items.Url
Write-Output $Urls

#loop each url and get the list in site
foreach($Url in $Urls){
    $SPWeb = Get-SPWeb $Url
    $SPList = $SPWeb.Lists["NintexWorkflowHistory"]
    $SPList.AllowDeletion = $true
    $SPList.Update()
    $SPList.Delete()
    write-host "List has been deleted successfully!"
}

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @sns,

You can use the following script to purge history

Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue 
#Read urls in csv
$Items = Import-Csv -Path C:\xie\SPurl.csv
$Urls = $Items.Url
Write-Output $Urls
#loop each url and get the list in site
foreach($Url in $Urls){
$web = Get-SPWeb $Url
NWAdmin.exe -o PurgehistoryListData -state completed -url $Url
}