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

Hi,

thats because you are trying to return an array of emails with = operator.

Could you add gs.log(answer) in Si and chck if you are getting the array of emails there or not.

Can you tell me how you are calling the script include 

I am calling the script include with the function name.find_real_file.png

Is operator means you are basically looking for 1 email. but since you are returning an array of emails from the SI, you should use one of operator. Check below i got the output.

find_real_file.png

 

Script Include

Mark the comment as a correct answer and also helpful once worked.

Hello Gopal,

I noticed that you have marked my comment as a correct answer earlier but now it is not. You can mark only 1 comment as a correct answer but can mark other comments as helpful.

Kindly check and mark the appropriate comment as a correct answer. 

Kajal Goti
Mega Guru

Hello,

 

You can refer https://hi.service-now.com/kb_view.do?sysparm_article=KB0716330,

 

 

Please mark as Correct/Helpful, If you find any solution

 

Thanks...