SanjivMeher
Mega Patron

I think you can just use gr.orderByAggregate('COUNT'); to achieve it.

 

getDuplicateAssetforAssignedTo: function() {
var str = [];
var gr = new GlideAggregate('cmdb_ci');
gr.addAggregate('COUNT', 'serial_Number');
gr.groupBy('serial_Number');
gr.addHaving('COUNT', '>', 1);

gr.orderByAggregate('COUNT');
gr.query();
while (gr.next()) {
str.push(gr.getValue('serial_Number') + '');
}
return str.toString();

},
});

 

Reference

https://developer.servicenow.com/dev.do#!/reference/api/quebec/server_legacy/no-namespace/c_GlideAgg...


Please mark this response as correct or helpful if it assisted you with your question.