Home > Dynamics CRM, SQL Server > CRM 4.0 & 2011 – SQL Code to show where your Plug-ins are registered

CRM 4.0 & 2011 – SQL Code to show where your Plug-ins are registered

When you register your plug-ins for Microsoft Dynamics CRM 4.0 or 2011 you either choose to register to Disk, Database or the GAC. I always prefer the database option so my CRM system is altogether and easier to move with deployments if required.

When you use the Plug-in Registration Tool, the action you choose will be written to the Microsoft CRM SQL Database. Therefore we can write T-SQL to give us that information.

Below is the T-SQL you can use to tell you where your Plug-ins are registered. This works for CRM 4.0 and CRM 2011.

SELECT Name, 
CASE SourceType 
WHEN 0 THEN ‘Database’ 
WHEN 1 THEN ‘Disk’ 
WHEN 2 THEN ‘GAC’ 
END AS ‘Registered Location’ 
FROM PluginAssembly 

 

Output shown below from CRM 2011 SQL Database

CRM2011Output

Nothing stopping you either from building a SSRS Report displaying this information for your System or Deployment Administrators.
 
Enjoy!
Greg Olsen
Yellow Duck Guy
Advertisements
Categories: Dynamics CRM, SQL Server
  1. November 2, 2011 at 8:56 pm

    There is obviously a lot to know about this. I assume you made some nice points in features also.

  1. No trackbacks yet.

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

%d bloggers like this: