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

Gayan Perera, 07 March 2012

We’re currently in the process of upgrading a large Dynamics CRM 4 to CRM 2011. CRM 4 was implemented by another vendor and has over 80 workflows! Some of which are very complex with custom workflow activities.

We wanted to quickly get a list of all the workflows that had custom activities without going through each one manually.

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