Get CRM list of Plug-in using SQL Query

img_0449Use below query:

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
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

Advertisements
Tagged with: , ,
Posted in CRM Query

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

Posts
%d bloggers like this: