Large CRM 4 to CRM 2011 Upgrade – Too many workflows…

While in the process of upgrading a large Dynamics CRM 4 to CRM 2011 which has over 80 workflows! Some of which are very complex with custom workflow activities, I needed to quickly identify which of those had custom activity steps.

To get a list of workflows with custom activities do the following

1. Go into the SQL server
2. Open SQL Management Studio
3. Run the query below against your *_MSCRM database

SELECT name, xaml

    FROM Workflow

WHERE Xaml like '%AssemblyQualifiedName=%'

ORDER BY name