Find list items have old workflow version running

Question

How can I find out which items in my list are running the old version of the workflow?

Answer 1

You can do this via Powershell. Since the previous workflow versions get a different name on replacement, you could check against the name (you could also check against the creation date, of course).

For example

$listName = "ABC"
$workflowName = "ABC-WF"
$site = Get-SPSite("http://myspsite")
$web = $site.OpenWeb()
$list = $web.Lists.TryGetList($listName)
$itemsWithDiffWorkflow = $list.Items | Where-Object { $_.Workflows | Where-Object { $_.ParentAssociation.Name -ne $workflowName -and $_.IsCompleted -eq $false } }
if($itemsWithDiffWorkflow -ne $null)
{
    foreach($item in $itemsWithDiffWorkflow)
    {
        write-host $item.Title
    }
}
$web.Dispose()
$site.Dispose()

This prints out all the item titles of items that have it's workflow not completed and the workflow is not named "ABC" (the newest version). If you have more than one workflow associated with the list, you have to change the script accordingly.

Answer 2

you can simplify this - you do not really need get-SPSite. You can simply remove that line and change the $web line to the following:

$web = get-spweb "https://mysite/web"