Dear all,
since we migrated (no inPlace upgrade) from CRM2013 (onPremise) to CRM2015 (onPremise) we struggle with a lot of duplicated contact records in the system. It was done by backing up the database and import it again to a new Server.
They were created while trying to bring up SSS feature again in the new target environment. This was around middle of September 2015 and therefore I need to say sorry: I can´t really remember all the details why we weren´t able to directly enable the feature again.
We currently have ~80.000 contact records in the system, only ~58.000 are unique. Based on the faulty SSS setup, duplicates sometimes where created more than twice (4x, 5x..).
At least we have ~180 affected users/mailboxes in the field that have SSS in use and still claim about duplicates.
Since we produced this massive overhead I´m pushing the "clean-up" forward on my schedule, not knowing how to get rid of this chaos.
I already investigated on good tools and found out that I need to split my problem at least into min. 2 tasks:
1.) CleanUp CRM
2.) CleanUp Exchange Mailboxes
One nice tool for task 1.) would be "duplicate detection addon" by Cowia which we already tested successfully in a small szenario. It´s a managed solution which is able to merge records based on certain filters.
duplicate-detection.com
Regarding task 2.) a PowerShell Script provided by "Michel de Rooij" could be our best choice:
https://gallery.technet.microsoft.com/office/Removing-Duplicate-Items-f706e1cc
I haven´t finally clarified with Michel, if this script is able to fetch the "CrmLinkState" value to kick out orphaned contact records from each mailbox, but since today I am still confident it would do the trick ;-)
But what I am mostly afraid of is: After cleaning up both environments, I can´t exclude SSS feature pushing again data mess to our mailboxes based on any (still) existing sync-tables per each CRM-Mailbox and I am also afraid of the next migration of our CRM database to new servers.
Therefore, at the end, these are my final questions:
1.)Is there any (supported) way to reset all CRM-sync information for each CRM mailbox in the database to start over with clear conditions for all users?
2.)Can anybody provide further information to survice this data advanture?
Any help would be kindly appreciated.
Please let me know if I missed to provide any necessary information.
Best regards,
Oliver
*This post is locked for comments