web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Getting list of duplic...

Microsoft Dynamics CRM (Archived)

Getting list of duplicate records?

(0) Share

Report

Report

Posted on by yify

1,023

Hello team,

I have a custom entity and I am using onpremise 2015.

I would like to know is there any way I can get a list of duplicate records created in CRM?

or If I can Query the SQL database?

Any help or guidance to the SQL query or any other methods to get the list in CRM is highly appreciated.

Thanks,

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Erry Handani 95 on at

Like (0)

Report

Hi James,

You can go to Settings --> Data Management --> Duplicate Detection Rules. Here, you must setup the duplication rules based on desired fields in your custom entity.

Was this reply helpful? Yes No
Verified answer

PS 23,577 on at

Like (0)

Report

Hi James

Go to settings>>Data Management>>Duplicate Detection jobs>>New>>Enter the fields & criteria and run the job. You will get the list within CRM.

SQL query is as simple as any other query; you just have to look for ..for e.g. contacts with exact same name... like you query for list of contacts similarly, add your filter query and run.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

SA-08121319-0 4

#1

Calum MacFarlane 4

#3

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans