Here is a background script for finding duplicate asset tags in hardware asset table.
var gaDupCheck = new GlideAggregate('alm_hardware');
gaDupCheck.addActiveQuery();
gaDupCheck.addAggregate('COUNT', 'asset_tag');
gaDupCheck.addNotNullQuery('asset_tag');
gaDupCheck.groupBy('asset_tag');
gaDupCheck.addHaving('COUNT', '>', 1);
gaDupCheck.query();
while (gaDupCheck.next()) {
gs.log(gaDupCheck.asset_tag);
}

Leave a comment