CRM 2011 – Getting the CRM License from the database

A customer was moving their CRM installation to a brand new server and wanted to know his license key.

obviously 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, although I usually find it oddly difficult to navigate the website, which seems about 10 years out of date (WHY?).

but I wondered if I could retrieve it from the MSCRM_CONFIG database, it must be in there.

After sniffing around for  a while I finally found it was held here

USE MSCRM_CONFIG

SELECT LicenseKeyV5RTM FROM ConfigSettings

This may be useful if you have inherited a CRM installation and want to update your records or maybe the customer is going to move servers etc.