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
- Go into the SQL server
- Open SQL Management Studio
- Run the query below against your *_MSCRM database
SELECT name, xaml
WHERE Xaml like '%AssemblyQualifiedName=%'
ORDER BY name