Hi mattyb,
I logged into the demo instance you linked. I suspect the duplicate finder script didn't work for you because the field name in my instance is different from the field name in the Demo instance.
The code was looking for this field (in bold):
| while(users.next()) { | ||
| arr.push(users.name.toString()); | ||
| } |
In the demo instance, name is undefined. The field is actually user_name. I attached a screenshot highlighting the demo field name:
So to make it work you'd have to adjust the field in the script:
| while(users.next()) { | ||
| arr.push(users.user_name.toString()); | ||
| } |
Of course to make it show results you will have to have some existing duplicate user_name's in the instance.
The whole thing:
//highlight duplicate users
var arr = [];
var users = new GlideRecord('sys_user');
| users.addActiveQuery(); | |
| users.query(); | |
| while(users.next()) { | |
| arr.push(users.user_name.toString()); | |
| } |
//sort:
| arr.sort(function(a, b) { | |
| if (a<b) { return 1 } | |
| if (a>b) { return -1 } | |
| return 0; | |
| }); | |
//remove duplicates:
for(var j=0, len = arr.length, count=0, dupes=[]; j != len; j+=1) {
| if ( arr[j] == arr[j+1] ) {//if the name is the same as the name in the next arr index | |
| ++count; | |
| dupes.push(arr[j]); | |
| } |
}
//Output:
gs.log("There are " + count + " duplicate users detected.\nUsers found: ")
for (var k=0; k!=dupes.length;k+=1) {
gs.log(dupes[k]);
}
I went to the Demo instance and tried creating some duplicates but I ran into a DB error:
So instead of creating user's with duplicate user_name's, we can just point the script at first_name instead to show first name duplicates. The concept is the same.
Here I created 2 users with the first_name of 'TEST':
Next I edited the script to push the first_name field (instead of user_name):
| while(users.next()) { | ||
| arr.push(users.first_name.toString()); | ||
| } |
Finally I ran the background script (TEST is in the list):
