CRM 2011 Duplicate Detection Toolkit available in Codeplex
The way CRM 2011 handles duplicates had always been a bit of a mystery to me. Detection of duplicates through matchcodes is quite straightforward, but reporting on them and understanding the effectiveness of de-duplication rules is difficult, and this is compounded by the CRM 2011 UI, which allows to check duplicates only one by one.
So I decided to do a little research, which resulted in this codeplex project: CRM 2011 Duplicate Detection Toolkit.
The project contains a set of stored procedures that allow to get a list of duplicates that can then be consolidated in a report. At a minimum, one can see how duplicates are related to each other by looking at the queries. This is not for the faint-hearted, you need to have some good understanding of the CRM 2011 data structure and, of course, of T-SQL.
Have a look at this post: CRM 2011 and Duplicate Detection for more information about duplicates.
Alberto “Taking-it-apart” Gemin