/* 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