How to get your Dynamics CRM License Key from the Database

Today a colleague asked me how to receive the License Key for a customer’s existing Dynamics CRM environment. As I did not knew the version used at the customer, I send him the information for alle environments, I currently work with.

Dynamics CRM 2011

USE MSCRM_CONFIG
SELECT LicenseKeyV5RTM FROM ConfigSettings

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’

This post is based on a blog post by Hosk, but he did not update it yet for Dynamics CRM 2015. 😉

So no credits for me today. 🙂