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’
Hosk's Dynamic Blog 
Merci ce fut très utilie pour moi!
LikeLike
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’
LikeLike
For CRM 2016 and D365 use:
USE MSCRM_CONFIG
SELECT [NvarCharColumn] AS CRM2015LicenseKey FROM [MSCRM_CONFIG].[dbo].[ConfigSettingsProperties] S WHERE S.ColumnName = ‘LicenseKeyV8RTM’
LikeLike