crm 2011 creating a view of merged contacts

Question

Can I create a view of the contacts that have been merged? I want to include active and inactive (sub ordinate) contacts as well in the view. I can search inactive contacts with the status 'Merged duplicates'. How do I find the master record in which it has been merged? Help is appreciated! :)

Answer 1

CRM has two fields called "merged" and "masterid" which indicate if the record was merged and the master record id. Unfortunately, CRM doesn't expose these fields so you won't be able to create a view but you can create a SSRS report to display merged records if you want.

The following is an example about how to retrieve this information using fetchXML:

<fetch>
  <entity name="contact" >
    <attribute name="fullname" />
    <attribute name="merged" />
    <attribute name="masterid" />
    <filter>
      <condition attribute="merged" operator="eq" value="1" />
    </filter>
  </entity>
</fetch>