Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 1 Oct 2011 10:30 PM
  • Last revision by (eMicrosoft Partne)
  • When: 1 Aug 2013 9:53 AM
  • Revisions: 10
  • Comments: 7
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2010: How to Delete Completed Workflow Instances

SharePoint 2010: How to Delete Completed Workflow Instances

SharePoint 2010: How to Delete Completed Workflow Instances

Table of Contents



Introduction:

Few days back a contributor requested me to write a tool that will cleanup completed workflow instances from a list. Hence I have developed this script, it takes site url and list name as input and then it spans through all items in the list and clears up all completed workflow instances.

This works for sharepoint 2007 as well as sharepoint 2010. This can be executed from any WFE in the farm. The code is as below:

C# Code Example:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Workflow;
 
 
namespace CompletedWorkflowCleanUp
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("Please enter the site url");
            String siteUrl = Console.ReadLine();
            Console.WriteLine("Please enter the list title");
            String listName = Console.ReadLine();
            using (SPSite site = new SPSite(siteUrl))
            {
                SPWorkflowManager workflowManager = site.WorkflowManager;
                using (SPWeb web = site.OpenWeb())
                {
                    SPList list = web.Lists[listName];
                    SPListItemCollection listItems = list.Items;
                    foreach (SPListItem listItem in listItems)
                    {
                        SPWorkflowCollection wCollection = listItem.Workflows;
                  
                        for (int i = 0; i < wCollection.Count; i++)
                        {
                            if (wCollection[i].IsCompleted)
                            {
                                workflowManager.RemoveWorkflowFromListItem(wCollection[i]);
                                listItem.Update();
                            }
 
 
                        }
                       
                    }
                    Console.WriteLine("Completed workflow instances are deleted for the list" +list);
                    Console.ReadLine();
                }
            }
        }
    }
}
, , , , , , [Edit tags]
Leave a Comment
  • Please add 4 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 30 Jul 2013 6:54 AM

    Gokan Ozcifci edited Revision 6. Comment: title and formatting  

  • 23 Jul 2013 3:12 AM

    Patris_70 edited Revision 5. Comment: deleted (en-US) from title

  • 18 Feb 2012 12:42 PM

    Craig Lussier edited Revision 4. Comment: added en-US to tags and title

  • 29 Nov 2011 4:58 PM

    Ed Price - MSFT edited Revision 3. Comment: Title casing

  • 9 Oct 2011 5:15 PM

    Craig Lussier edited Revision 2. Comment: minor text edit

  • 9 Oct 2011 5:14 PM

    Craig Lussier edited Revision 1. Comment: added toc

  • 3 Oct 2011 2:18 PM

    Ed Price - MSFT edited Original. Comment: Adding tags

Page 1 of 1 (7 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 3 Oct 2011 2:18 PM

    Ed Price - MSFT edited Original. Comment: Adding tags

  • Posted by
    on 9 Oct 2011 5:14 PM

    Craig Lussier edited Revision 1. Comment: added toc

  • Posted by
    on 9 Oct 2011 5:15 PM

    Craig Lussier edited Revision 2. Comment: minor text edit

  • Posted by
    on 29 Nov 2011 4:58 PM

    Ed Price - MSFT edited Revision 3. Comment: Title casing

  • Posted by
    on 18 Feb 2012 12:42 PM

    Craig Lussier edited Revision 4. Comment: added en-US to tags and title

  • Posted by
    on 23 Jul 2013 3:12 AM

    Patris_70 edited Revision 5. Comment: deleted (en-US) from title

  • Posted by
    on 30 Jul 2013 6:54 AM

    Gokan Ozcifci edited Revision 6. Comment: title and formatting  

Page 1 of 1 (7 items)