AnsweredAssumed Answered

Use PurgeHistoryListData to an specific Nintex Workflow History list

Question asked by enrique.polin on May 23, 2017



We have the original Nintex Workflow History List named "NintexWorkflowHistorywith more than 7 milliion items in one of our subsites, right now I created a new Nintex Workflow History list  named "NintexWorkflowHistory2017" and pointed all the workflows to it.

We already purged the workflow database with the following command:

DECLARE @return_value int
EXEC @return_value = [dbo].[PurgeWorkflowData]
@WebID='guid', --Update to your Site Collection ID
@LastActivityDate = '2017-01-01', --Setting lastworkflowactivity time, this is actions executed older than the date specified
@state = 4 --Running = 2, Completed = 4, Cancelled = 8, Error = 64
SELECT 'Return Value' = @return_value

Now I want to purge the "NintexWorkflowHistory" with:

NWAdmin.exe –o PurgeHistoryListData -siteUrl http://siteurl -lastActivityBefore 2017-01-01 00:00 -state Completed

but I get the follwing message: "No matching workflow instance ids found in the Nintex Workflow database." and not even 1 item is removed.

I found a forum suggesting the parameter -clearAll but I am afraid it also clears the new list  "NintexWorkflowHistory2017"


Is there a way to use the parameter -clearAll to clear an specific Nintex Workflow History list ("NintexWorkflowHistory") keeping safe the list NintexWorkflowHistory2017?


Thank you for your help!