Find duplicate user email (or anything else) - Blogs - Blog - ServiceNow Community

PHOTO EMBED

Tue Jan 26 2021 15:41:52 GMT+0000 (Coordinated Universal Time)

Saved by @nhord2007@yahoo.com #servicenow #javascript #duplicate


/*
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;
}
content_copyCOPY

https://community.servicenow.com/community?id