cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

alternate Powershell script/SQL for syncterminatedworkflows required

Hello,

we are having a large farm, so workflow timer jobs are getting failed and nintex workflow timer job also not working as expected

as a clean up activity we need some scripts which can be ran on SQL or Powershell.

1) we want to terminate all the works which are error occurred in our environment

2) the workflows which are running more than 180 days and there is no action from any users that needs to be terminated.

3)  Purging the nintex history list per sites rather than site collection DQL queries required.

How to purge large Nintex Workflow History list and dbo WorkflowProgress table

above is for site collection.

-------------------

NWAdmin.exe

–o PurgeHistoryListData -siteUrl http://site  -lastActivityBefore 2015-10-10T12:29:14

-state All

Nwadmin.exe  -o syncterminatedworkflows -url http://site
-terminateDeletedItems -confirm:$true

above commands are getting timed out

any recommendation for cleaning up activities will helpful.

Labels: (2)
Reply
2 Replies
fhunth
Nintex Newbie

Re: alternate Powershell script/SQL for syncterminatedworkflows required

Reply
Automation Master
Automation Master

Re: alternate Powershell script/SQL for syncterminatedworkflows required

If those actions are getting timed out, then you could start with a smaller query that is not too far back in the past and work your way backwards.

Reply