It is probably not something you do daily, but sometimes you need to retrieve the CRM license key for a CRM installation.
In CRM 4.0 this could be done using:
- USE MSCRM_CONFIG
- SELECT LicenseKey FROM ConfigSettings
However, in 2011 this returns null. For reasons unknown Microsoft has created a new column to store the license key and the new query is:
- USE MSCRM_CONFIG
- SELECT LicenseKeyV5RTM FROM ConfigSettings
