/*
Client callable script include used for filtering sys_user lists
to identify duplication email users
name: duplicateEmail
active: true
client callabe: true
*/
function duplicateEmail() {
var xx = new GlideAggregate('sys_user');
xx.addAggregate('COUNT', 'email');
xx.addHaving('COUNT', 'email', '>', '1');
xx.query();
var answer = new Array();
while (xx.next()) {
answer.push(xx.getValue('email'));
}
return answer;
}
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter