Find duplicate users by User Name & Background Script / Fix Script for validation.

[oldMonk]

Script Include to find duplicate users by User Name. Run this script include from Background Script / Fix Script for validation.

[Mike_R]

var gaDupCheck = new GlideAggregate('sys_user');
gaDupCheck.addActiveQuery();
gaDupCheck.addAggregate('COUNT', 'user_name');
gaDupCheck.addNotNullQuery('user_name');
gaDupCheck.groupBy('user_name');
gaDupCheck.addHaving('COUNT', '>', 1);
gaDupCheck.query();
while (gaDupCheck.next()) {
gs.log(gaDupCheck.user_name);
}

[Gunjan Kiratkar]

var gaDupCheck1 = new GlideAggregate('sys_user'); gaDupCheck1.addAggregate('COUNT', 'email');

gaDupCheck1.groupBy('email');

gaDupCheck1.addHaving('COUNT', '>', 1);

gaDupCheck1.query();

while (gaDupCheck1.next()) {

gs.print(gaDupCheck1.email);

}