Find duplicate user email (or anything else) - Blogs - Blog - ServiceNow Community
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
Comments