How to delete duplicates based on 2 fields

[Dead Blade]

Hi,

So I've scrubbed through the forums and found many scripts to delete duplicate records, but they are all based on 1 field.  Some of which are using GlideAggregate.  So I need a script to delete records based on several field criteria.  Example

Field 1     Field 2

John        Smith

John        Doe

John        Smith

John        Johnson

Delete the Duplicate John Smiths. 

I will be using this script as a fix script running on a schedule as maintenance for an m2ms table.  The fields are reference fields if that matters.

[asifnoor]

Hi,

It means that they are not entering your loop. Can you go to u_m2m_authorize_servers.list and there add a filter and check with these sys_ids. If there are any rows matching those sys_ids.

[Dead Blade]

Hi asifnoor, yes I specify a server and group then I will get results, but I am not trying to specify a specific server/group.  I am attempting to find ALL duplicates on that table.  Thank you for chiming in.

[Dead Blade]

So, I am not looking for a specific sys_id.  I am attempting to delete ANY duplicate records.

[aashishdasari]

Hi,

You can try using the following method:

First create a script include and find the duplicates

var gr=new GlideAggregate('u_m2m_authorize_servers');
var duplicates= [];
gr.addAggregate('COUNT','u_group');
gr.addAggregate('COUNT','u_server');
gr.groupBy('u_group');
gr.groupBy('u_server');
gr.addHaving('COUNT', '>=', 2);
gr.query();
while(gr.next())
{
var array_Duplicates= {};
array_Duplicates.group= ''+gr.group;
array_Duplicates.server= ''+gr.server;
duplicates.push(array_Duplicates);
gs.info(JSON.stringify(duplicates));
}

return JSON.stringify(duplicates);

In your script you change it accordingly:

var optionsObj=ScriptIncludenmae.function();// need to edit the name and function of the script Include

for (var i = 0; i < optionsObj.length; i++) {

var gr=new GlideRecord('u_m2m_authorize_servers');
gr.addQuery('u_group',optionsObj.group);
gr.addQuery('u_server',optionsObj.server);
gr.query();
var deleteCount = 0;
while(gr.next()) {
gr.deleteRecord();
deleteCount++;
gs.print('Record: ' + gr.u_group + gr.u_server + ' Deleted');
}
gs.print('Records Deleted = ' + deleteCount);

}

Hope this solution helps

[Dead Blade]

Hello aashishdasari, I like the idea of a script include.  I received this error attempting to creat the script include "Could not save record because of a compile error: JavaScript parse error at line (18) column (7) problem = invalid return (<refname>; line 18)".  This refers to the "return JSON.stringify(duplicates);" line 18.  I am attempting to troubleshoot.