Find all SPD workflows in site collection

Question

I am migrating a sharepoint farm and need to update all SPD workflows in the migrated site collection. I need to get a list of all SPD workflows that exist in the site collection so I can update URLs, email addresses etc.

I know I can open each site in SPD and check for workflows from there - however, there are over a 100 sites and subsites and I'm sure there is a better way to list all workflows (SQL query, Powershell script).

Any help would be appreciated, Greg

Update: Ok, so a quick and dirty way of listing all workflows is to run the following SQL query on the content DB

SELECT dirname, leafname FROM allDocs WHERE LeafName LIKE '%.xoml'

If anyone has a better way (Powershell anyone?) let me know.

Answer 1

You can do this using Powershell. Loop through all sites in your site collection, then all lists, then all workflow associations.

$site = Get-SPSite("your-site-url");
$site.AllWebs | foreach { $_.Lists | foreach { $_.WorkflowAssociations | foreach { 
  write-host "Site:" $_.ParentWeb.Url ", List:" $_.ParentList.Title ", Workflow:" $_.Name
} } }

Answer 2

Check this code, i dont remember but find it somewhere in the WEB: It listing all workflows inside one site collection and generating CSV table.

#Load SharePoint 2007 Assemblies
[System.Reflection.Assembly]::Load("Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c") | out-null

$siteurl="http://site.domain.com"
$site=new-object Microsoft.SharePoint.SPSite($siteurl)

#Initialize Workflow Count variable
$workflowcount = 0

#Foreach loop to loop through all webs, and lists with workflow associations, and exclude workflows that have previous versions and write findings to .csv file.

function Get-Workflows()
{
    foreach($web in $site.AllWebs)
    {
            foreach($list in $web.Lists)
            {
                foreach($wf in $list.WorkflowAssociations)
                {
                        if ($wf.Name -notlike "*Previous Version*")
                        {
                            $hash = @{"[URL]"=$web.Url;"[List Name]"=$list.Title;"[Workflow]"=$wf.Name}
                             New-Object PSObject -Property $hash | Sort-Object

                        }
                }
            }
    }
}

foreach($web in $site.AllWebs)
{
    foreach($list in $web.Lists)
    {
        foreach($wf in $list.WorkflowAssociations)
        {
            if ($wf.Name -notlike "*Previous Version*")
            {
               $workflowcount += 1
            }
        }
    }
}

Get-Workflows | Export-csv E:\workflows.csv
"Workflow Count " + $workflowcount >> E:\workflows.csv

$site.Dispose()