Remove duplicate names in script includes

[shivaadapa]

Hi
I want to get all the duplicate names (same name for two or more records) for script includes ? How do i check?

[Amit Verma]

Hi @shivaadapa 

Please try the below script logic :

var dupRecords = [];
var gaDupCheck = new GlideAggregate('sys_script_include');
gaDupCheck.addAggregate('COUNT','name');
gaDupCheck.addNotNullQuery('name');
gaDupCheck.groupBy('name');
gaDupCheck.addHaving('COUNT', '>', 1);
gaDupCheck.query();
while (gaDupCheck.next()) {
dupRecords.push(gaDupCheck['name'].toString());
}
gs.print(dupRecords);

Thanks & Regards

Amit Verma