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

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.

Parents Reply Children
No Data