5,005
Hi,we need to find an duplicates in Account entity
sandeep this account name has 61 duplicates with same email address how to find same duplicates in MSCRM how?
Any suggestions will be marked as verified as it is imp
*This post is locked for comments
Try this:
SELECT name, emailaddress, COUNT(emailaddress)
FROM account
GROUP BY name, emailaddress
HAVING COUNT(emailaddress) > 1
If my answer helped to resolve your issue, kindly verify it by clicking 'Yes'. It would be helpful to the other community members seeking to resolve a similar issue.
Cheers
Arpit
https://arpitmscrmhunt.blogspot.in
Hi Sandeep,
try below :
SELECT name, COUNT(email)
FROM account
GROUP BY email
HAVING COUNT(email) > 1
this will give you list of all the accounts. Just change the column names you need and table name as necessary.
Hi Sandeep,
You can make use of duplicate detection rule in CRM , have a look on the below :
docs.microsoft.com/.../set-up-duplicate-detection-rules-keep-data-clean
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (