Retrieve your CRM 2011 license key from the MSCRM_CONFIG database

It is probably not something you do daily, but sometimes you need to retrieve the CRM license key for a CRM installation.

In CRM 4.0 this could be done using:

  1. USE MSCRM_CONFIG
  2. SELECT LicenseKey FROM ConfigSettings

However, in 2011 this returns null. For reasons unknown Microsoft has created a new column to store the license key and the new query is:

  1. USE MSCRM_CONFIG
  2. SELECT LicenseKeyV5RTM FROM ConfigSettings

About these ads

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