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

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

Hi Mykola Bulava,

Thanks you for your reply - I have implemented this and now I can find all my duplicate serial numbers - THANK YOU for the point in the right direction ;-)
I did need some help from my colleague on the SQL syntax though.

If it helps anybody else here is what we did in Advanced Reports to find duplicate records based off 'Name':

I had previously, a long time ago when new to Sugar, been a bit confused by advanced reports so I hope this helps.. once you know the sql to include they do make sense to folk like me who are not programmers or developers:

To be honest for what i needed just creating the SQL Query was enough, but I did go ahead and do the rest of the advanced report more out of curiosity.

In your Normal Report

In your normal report (Report Module) to get the SQL build a report close to what you need, tick the Show Query tick box and then click PREVIEW...  I don't know if this is correct but in ours clicking save and run with show sql ticked does not show the sql.  Only preview shows the sql.

Then after it has ran scroll right down the bottom and the sql is displayed - query 1 and query 2.   Copy Query 1.

Create the Custom Query

  > > > 

Then add your SQL...  may need to tweak it a bit to get exactly what you need - I can't help you there!

This was mine:

The main addition is:  HAVING COUNT(s_serialnumber.name) > 1

Create an Advanced Report - (which when you select it is titled 'Enterprise' reports?)
This bit just needs a data format to be created - not as daunting as it initially sounds and easy when you see it.
Then add the query you just made to the advanced report.

Hope that helps :-)

Hi Romney Lai, great question!  Once identified - here in lies the dull part: I need to merge each one!  maybe a job for the new year.  Each record could be related to other tables like contact, case, etc...  So I am unable to just delete.  1474 dupes found! 

Thanks Jeff Bickart for the link!  DeDupit looks great...  but not at that price. Especially in the current climate when so much is uncertain - and I bet I am cheaper to do it manually ;-)  hehe....   Mind you it for one year it would work out at about 66 cents a dupe..  so its not bad.  Plus I bet we have dupes elsewhere too.  Thank you for the info though...  

...as always the Sugar Club is a great resource!  Thanks everyone.

Thanks for the write up and sharing it. All things considered, 1474 dupes are not too bad  Good luck.

Thanks for the write up and sharing it. All things considered, 1474 dupes are not too bad  Good luck.