Find Duplicate Records

[SNOW Learner1]

Hi,

In my user table, I'm seeing multiple records with duplicated. Per existing info, the following fields is going to help to identify the duplicate records. 1. Name, 2. sys_id 3.email.

Can you help the script with the help of  same Name, Same Email, Different sys_id and Active is True to find the duplicate records. Per understanding these are the key factor to identify the duplicate records in sys_user table.

I tested with below and helping based on email address.

var gaDupCheck1 = new GlideAggregate('sys_user'); 
     gaDupCheck1.addQuery('active','true'); 
     gaDupCheck1.addAggregate('COUNT', 'email'); 
     gaDupCheck1.groupBy('email'); 
     gaDupCheck1.addHaving('COUNT', '>', 1); 
     gaDupCheck1.query(); 
     while (gaDupCheck1.next()) { 
            gs.print(gaDupCheck1.email); 
     } 

Regards,

LS

[Voona Rohila]

Hi 

The code you wrote also works, what is the issue you are facing?

You can also try below logic too

var gaDupCheck1 = new GlideAggregate('sys_user'); 
gaDupCheck1.addQuery('active','true'); 
gaDupCheck1.addAggregate('COUNT'); 
gaDupCheck1.groupBy('email'); 
gaDupCheck1.groupBy('name');
gaDupCheck1.addHaving('COUNT', '>', 1); 
gaDupCheck1.query(); 
while (gaDupCheck1.next()) { 
         gs.print(gaDupCheck1.email); 
}