Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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...