cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Use PurgeHistoryListData to an specific Nintex Workflow History list

Hello, 

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]
@SiteID='guid,
@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
GO

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!

Labels: (2)
0 Kudos
Reply