Friday, September 07, 2012

Extracting CRM plugin unsecure configuration information

Here is the SQL to extract the unsecure configuration information for a CRM plugin:

Select step.* from SdkMessageProcessingStepBase as step
LEFT JOIN PluginTypeBase as pluginType on pluginType.PluginTypeId = step.PluginTypeId
LEFT JOIN PluginAssemblyBase as pluginAssembly on pluginAssembly.PluginAssemblyId = pluginType.PluginAssemblyId
LEFT JOIN SdkMessageProcessingStepImageBase as stepImage on step.SdkMessageProcessingStepId = stepImage.SdkMessageProcessingStepId
--WHERE pluginAssembly.Name like 'plugin name'

No comments: