web

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

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

PS 23,577 on at

Like (0)

Report

RE: Getting list of duplicate records?

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
Verified answer

Erry Handani 95 on at

Like (0)

Report

RE: Getting list of duplicate records?

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

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Our Community Code of Conduct has been updated!

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

Aric Levin - MVP 2 Moderator

#2

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans