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’

 

Advertisements