Here is a script to easily find users with the same name in the system. Useful for proactively detecting and fixing duplicates.
var gaDupCheck = new GlideAggregate('sys_user');
gaDupCheck.addActiveQuery();
gaDupCheck.addAggregate('COUNT', 'name');
gaDupCheck.addNotNullQuery('name');
gaDupCheck.groupBy('name');
gaDupCheck.addHaving('COUNT', '>', 1);
gaDupCheck.query();
while (gaDupCheck.next()) {
gs.log(gaDupCheck.name);
}
mySNstuff.com 
Leave a comment