Dynamics CRM: How To Get The Secure and Unsecure Configurations List

First, before we go to the main idea, do you know about Dynamics CRM Plugin Secure/Unsecure Configuration? We can put a string value on our plugin step, then we can consume those values in our plugin code to do some logic. There are two types of configuration: Secure and Unsecure. The differentiation for these 2 configuration is how the system store the value. For more information, you can check this blog post

How to add Secure and Unsecure configuration in plugin step.

For those who already know about these configurations (Secure and Unsecure), do you ever wonder the easiest way to check your Plugins’ Secure and Unsecure Configurations? To know your configurations, you need to download SQL 4 CDS by Mark Carrington (from XrmToolBox, you just need to go to the store and search with the keyword “SQL 4 CDS“). 

Once done with the step above, you can run this below code to get the configurations list:

SELECT DISTINCT 
       a.Name, 
       a.PluginAssemblyIdName, 
       b.Configuration 'UnsecureConfig', 
       c.SecureConfig 'SecureConfig'
FROM dbo.PluginType a
     JOIN SdkMessageProcessingStep b ON a.PluginTypeId = b.PluginTypeId
     LEFT JOIN dbo.SdkMessageProcessingStepSecureConfig c ON 
     c.SdkMessageProcessingStepSecureConfigId = b.SdkMessageProcessingStepSecureConfigId

Tips: To only get your custom plugin, you can add WHERE criteria (usually your plugin name will have the same prefix, so you can use that too).

Here is the result:

Dynamics CRM Plugin Secure+Unsecure Configuration List

Happy CRM-ing!

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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.