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’