How can I clear/reset the workflow count for a list. This list items have already been deleted, but the "Workflows in progress" numbers are still the same. I would like to reset these numbers to zero. Plus I'm worried that these are in fact still pending and using up server resources.

enter image description here

What confused me is that the "Workflow Health" status seems to be correct. enter image description here

Any Ideas?


You can cancel the in progress workflow by PowerShell. Please refer to old discussion here for sample code and reference.

  • Hi, thanks for the response, but that's not what i was looking for. This works only for list items that are still in the list. My list is basically empty. All items have been deleted and the recycle bin (both stages) has been emptied out. – Jaitsujin Nov 12 '20 at 1:16
  • i need to be able to delete/clear orphaned workflow references for list items that have been deleted. running the cleanup job didn't work either. – Jaitsujin Nov 12 '20 at 1:18
  • Are the deleted items still in recycle bin? – Mark L Nov 12 '20 at 1:45
  • No, all items had already been purged. – Jaitsujin Nov 12 '20 at 2:00

I finally figured it with some help from the post below. https://www.sharepointeurope.com/wfinstancemanagementdb-in-workflow-manager/

The dbo.Instances table within the WFInstanceManagementDB database is key here.

enter image description here

After deleting all orphaned/suspended workflows here, the progress list was cleared.

enter image description here

Finally piece of mind!

Although this mind not be the best recommended way, it definitely worked for me. So just in case some one has the same issue, make sure you use with causion!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.