how to Find duplicate user email in Users table List?

[Allu Gopal]

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.

[Ankur Bawiskar · Accepted solution]

Hi,

please use [IS ONE OF] operator

Regards
Ankur

[asifnoor]

Hi Gopal

Try group by.

In the list view, click on the email column header and select group by. It will group by email. There you can find if there are duplicates.

Alternatively you can write a script using glideaggregate and can find duplicates as well.

Example: https://docs.servicenow.com/bundle/jakarta-application-development/page/script/glide-server-apis/con...

Mark the comment as a correct answer and also helpful if this has answered your question.

[Allu Gopal]

I tried the script include and make it client callable but it is showing the null values.

script include:

and called this function in users table list view filter.

[asifnoor]

Hi,

addHaving requires only 3 operators and it should be like this

gr.addHaving('COUNT','>','1'); 

Then it will work.

Mark the comment as a correct answer and helpful if this helps to solve the problem.

[Allu Gopal]

Hi asifnoor,

I tried but it is showing undefined.