Find Duplicate record of incident

[ABC6]

Hi All,

i need to get the Duplicate incident record which has been created accidently , i need to find out those record among 6lakh record for this purpose i have run the background script which did not help me to expedite the issue.

 var count = new GlideAggregate('incident');
count.addAggregate('COUNT','number');
count.query();
while(count.next()){
var category = count.number;
var categoryCount = count.getAggregate('COUNT','number');
gs.print("there are currently "+ categoryCount +" incidents with a category of "+ category);}
}

Please suggest me

[AbdulAzeez]

Show me the screenshot how are you doing.

It is working for me when i test now.

When i search with the first Inc number

[ABC6]

After executing this i got this

[AbdulAzeez]

It should work. Can you please check if you are in any of Scoped Application or in Global ?

Goto Toggle bar as shown below and see if you are in Scope App or Global, make sure you are in Global Applicatino

Try with below script:

gs.print(getDuplicates('incident','number'));
function getDuplicates(incident,number) {
var dupRecords = [];
var gaDupCheck = new GlideAggregate(incident);
gaDupCheck.addQuery('active','true');
gaDupCheck.addAggregate('COUNT',number);
gaDupCheck.addNotNullQuery(number);
gaDupCheck.groupBy(number);
gaDupCheck.addHaving('COUNT', '>', 1);
gaDupCheck.query();
while (gaDupCheck.next()) {
dupRecords.push(gaDupCheck[number].toString());
}
return dupRecords;
}

[ABC6]

gs.print(getDuplicates('incident','number'));
function getDuplicates("incident,number) {
var dupRecords = [];
var gaDupCheck = new GlideAggregate("incident);
gaDupCheck.addQuery('active','true');
gaDupCheck.addAggregate('COUNT',val);
gaDupCheck.addNotNullQuery(val);
gaDupCheck.groupBy(val);
gaDupCheck.addHaving('COUNT', '>', 1);
gaDupCheck.query();
while (gaDupCheck.next()) {
dupRecords.push(gaDupCheck[number].toString());
}
return dupRecords;
}

i have tried with this code it shows me an error 

[ABC6]

i got the same error again with copy paste