Identities with Same email address

[Manju22 (Manjuladevi Manickam)]

Hi, Is there any query available that can be used in IDN to find out multiple identities with the same email address.?

[neeraj99 (Neeraj Nautiyal)]

@Manju22

identities

Hi @Manju22
I don’t think this is possible via search directly. But there are indirect ways of checking this out if you are open to that.

Simply download the report of all the identities and create a vlookup to check for any duplicates on email column.

Otherwise, if you are keen on doing it through ISC then i would suggest to try this option:

I’m not 100% sure it will work but doesn’t hurts to give a try

1. Create another identity attribute and populate a flag in there maybe (0/1) if it is a duplicate populate 0, otherwise 1.
2. Then use the rule transform with Cloud Services Deployment Utility to get the username of the identity considering uid=email.
3. If it returns something that means its probably a duplicate email.

NOTE: Make sure to check that it does not return the same identity, otherwise it will be always set to 1, and put a specific check for that.

4. Afterwards you can simply create a search query:
   attributes.duplicateEmailFlag:"1"
   Which will give you all the identities.

Hope this can help in some way…