Dynamics CRM – How to find duplicate plug-in steps

Use below query to find the duplicate plug-in steps. If count is greater than 1 means it is duplicate step.

SELECT name, PluginTypeId, plugintypeidname, count(*)
FROM SdkMessageProcessingStep
WHERE IsManaged = 0
and name <> ‘ObjectModel Implementation’
and name <> ”
and name not like’%activityfeed%’
GROUP BY name,PluginTypeId, plugintypeidname
HAVING count(*)>1

Advertisements
Tagged with: , , ,
Posted in CRM New Features

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: