View all registered Plugin Steps (SQL)

To view all the registered Plugin Steps (for all the plugins) in a single query, use the following SQL statement:

SELECT T.PluginAssemblyIdName AS PluginName, S.name AS StepName, 
S.description AS StepDescription, M.name AS Action, E.name AS Entity, 
CASE S.Stage WHEN 20 THEN 'PRE' WHEN 40 THEN 'POST' ELSE 'OTHER' END AS Stage,
CASE S.StateCode WHEN 0 THEN 'Enabled' WHEN 1 THEN 'Disabled' ELSE 'Other' END AS State
FROM SdkMessageProcessingStepBase S -- Steps Table
JOIN SdkMessage M ON(S.SdkMessageId = M.SdkMessageId)
JOIN SdkMessageFilter F ON(S.SdkMessageFilterId = F.SdkMessageFilterId)
JOIN EntityAsIfPublishedLogicalView E ON(E.ObjectTypeCode = F.PrimaryObjectTypeCode)
JOIN PluginType T ON(T.PluginTypeId = S.PluginTypeId)

2 comments

  1. Hi the query is really helpful, but it does not yield all the records. Can you please help. I have 70 plugins written when I check from PluginTypeBase, but this query returns only 21 records.

Leave a comment

Your email address will not be published. Required fields are marked *