web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch! 🚀
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Blogs / Magnetism Solutions Dynamics CRM Blog / Quick Tip: Locate Plugins a...

Quick Tip: Locate Plugins and Steps

Views (4679)
MagnetismXRM Profile Picture MagnetismXRM 6,230

We have a large Dynamics CRM 2011 project with over 300 plugin steps, looking through the plugin registration or customizations for a specific plugin or a step isn't easy. I get dizzy!

Here's a SQL query that you can use to quickly filter and find the plugin or the step that you're looking for.

select distinct
c.LogicalName,
a.EventHandlerName,
a.SdkMessageIdName,
case a.Stage 
    when 10 then 'Pre Validation'
    when 20 then 'Pre'
    when 30 then ''
    when 40 then 'Post'
    when 50 then 'Post (Deprecated)'
end as Stage,
case a.Mode 
    when 0 then 'Synchronous'
    when 1 then 'Asynchronous'
end as Mode,
isnull(a.FilteringAttributes, '') as FilteringAttributes
from SdkMessageProcessingStep a
inner join SdkMessageFilter b on a.SdkMessageFilterId = b.SdkMessageFilterId
inner join MetadataSchema.Entity c on c.ObjectTypeCode = b.PrimaryObjectTypeCode
where a.IsHidden = 0
order by c.LogicalName, a.EventHandlerName

The query above is very basic, it'll show you the entity, message, stage, mode, filtering attributes that are registered for each plugin step.

Enjoy!

Comments

*This post is locked for comments