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=%'

No Comments