How to identify which Updates where applied to my CRM Deployment

The CRM Configuration database holds the build version and KB article numbers of the Updates that have been applied to the deployment.

In order to identify the KB numbers and build versions of the Updates applied, perform a SELECT query as follows:

 

For CRM 4 Deployments:

USE MSCRM_CONFIG;
GO;

SELECT * FROM InstalledUpdates

Example Output:

In this case, the Update Rollups applied were:

KB979347 - Build 2741 - Update Rollup 10 - https://support.microsoft.com/kb/979347

KB2477743 - Build 3335 - Update Rollup 16 - https://support.microsoft.com/kb/2477743

 

For CRM 2011 Deployments:

USE MSCRM_CONFIG;
GO;

SELECT * FROM InstalledUpdates_V5

Example Output:

In this case, the Update Rollups applied were:

KB2466084 - Build 1045 - Update Rollup 1 - https://support.microsoft.com/kb/2466084

KB2466086 - Build 1157 - Update Rollup 2 - https://support.microsoft.com/kb/2466086

 

The execution of the CRM Diagnostics tool and collection of the Troubleshooting file for Support will also include this piece of information.

Please note that you should not apply any direct SQL changes in the CRM Database as this is considered unsupported.

These queries are for information collection only and they do not change any data within the databases.

 

Regards

Gonçalo Antunes

EMEA Dynamics CRM Team