How to find existing duplicate records on 'Name' but with different ID's

Question

Hello, 
 A brief history is that over the years we moved systems a couple of times. Now we are in Sugar CRM Ent Cloud v10.2 and have automated our serial number module import. So going forwards this should not be an issue... 
 But, duplicate serial numbers have been created in the past ( Serial Number = Custom Module). 
 I have struggled to find a way to find duplicate records that already exist? I hoped reports would be the answer but I had no luck there, maybe an API endpoint could get me and dupes in an array? 
 Has anybody had to do similar that may be a solution for this case? 
 I have began exporting via reports and to then try in Excel, but there is over 283,000 records in there!! I really need them all in one sheet to check for dupes too... I think however it is done will not be much fun :-0 
 Thank you in advance, Luke.

Luke Ridgway · Accepted Answer

Hello, Luke. You could try to use Advanced Reports to select only necessary data or another option: create a regular Summation report with "count" by "Name" and sorted descending to select names with qty > 1 quickly. After that, use the regular filter by this module in the separate browser's window to filter data name-by-name and use merge functionality. 
 I hope this helps you. Regards, Mykola