CRM 2015 – Getting the CRM License from the database

key_to_the_city_of_london_charles_lindbergh

A customer was moving their CRM installation to a brand new server and wanted to know the CRM license key.

I note down the CRM license key for each installation and keep them in CRM (where else would I put it!), you can also retrieve this information from partnersource or voice.

You can retrieve it from the MSCRM_CONFIG database with the SQL below.  The query is different for each version of CRM, Microsoft has a new column for each version of CRM.

USE MSCRM_CONFIG

SELECT LicenseKeyV5RTM FROM ConfigSettings

This is useful if you have inherited a CRM on premise .

I was updating this post and found this post had instructions to retrieve the license key from CRM 2013 and CRM 2015.
Dynamics CRM 2013

USE MSCRM_CONFIG
SELECT [NvarCharColumn] AS CRM2013LicenseKey FROM [MSCRM_CONFIG].[dbo].[ConfigSettingsProperties] S WHERE S.ColumnName = ‘LicenseKeyV6RTM’
Dynamics CRM 2015

USE MSCRM_CONFIG
SELECT [NvarCharColumn] AS CRM2015LicenseKey FROM [MSCRM_CONFIG].[dbo].[ConfigSettingsProperties] S WHERE S.ColumnName = ‘LicenseKeyV7RTM’

 

5 thoughts on “CRM 2015 – Getting the CRM License from the database

  1. leandre KOFFI March 20, 2014 / 9:41 am

    Merci ce fut très utilie pour moi!

    Like

  2. Steven Rasmussen June 23, 2015 / 8:29 pm

    FYI – This has changed once again for CRM 2013. The key is now found in the ‘ConfigSettingsProperties’ table. You can use the following SQL statement to retrieve it:

    SELECT
    [NVarCharColumn] AS CRM2013LicenseKey
    FROM [MSCRM_CONFIG].[dbo].[ConfigSettingsProperties] S
    WHERE S.ColumnName = ‘LicenseKeyV6RTM’

    Like

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