ServiceNow - Get Dublicates
Tue Dec 14 2021 16:36:51 GMT+0000 (Coordinated Universal Time)
Saved by
@vedo
gs.info(getDuplicates('cmdb_ci_service','u_service_id'));
function getDuplicates(tablename,val) {
var dupRecords = [];
var gaDupCheck = new GlideAggregate(tablename);
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[val].toString());
}
return dupRecords;
}
content_copyCOPY
Comments