how to Find duplicate user email in Users table List?

Allu Gopal
Kilo Expert

Hi,

I want to see the duplicate email users in the list view of User Table without using of show matching. Help me in this.find_real_file.png

 

2 ACCEPTED SOLUTIONS

Hi,

please use [IS ONE OF] operator

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

Hi,

it worked well

For multiple emails use [IS ONE OF] operator

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

23 REPLIES 23

Jaspal Singh
Mega Patron
Mega Patron

Hi Allu,

 

Can you do below.

Change the line 4 duplicateEmail: function to duplicateEmailis: function

Call it in the filter as below

Email | is one of | javascript: new duplicateEmail().duplicateEmailis()

Hi Jaspal Singh,

It is working Thank you but it working only for one duplicate email.find_real_file.png

but it is not working for more than one duplicate records.

find_real_file.png

Hi,

please use [IS ONE OF] operator

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Strange. 

Can you confirm the exact filter & script include you using.