You can't really do relational-style table queries like this. You need to either know the email address first, or the uid/cn.

You likely need a script or something else to do this kind of search. First you'd get each unique mail, then you would search for each mail, what uid/cn exist.

Alternately, you could just do a single ldap query, get all entries with mail + cn + uid, then in client side do the relationship/filtering in python or something.

Hope that helps,

On 7 Oct 2021, at 07:43, Ghiurea, Isabella Isabella.Ghiurea@nrc-cnrc.gc.ca wrote:

Dear List, What ldapsearch options/ filters I need to use to find all the multiple uid /cn’s entries associated to one single email address in my DS with > 5k entries? ( I do not know the email address or uids values) Thank you _______________________________________________ 389-users mailing list -- 389-users@lists.fedoraproject.org To unsubscribe send an email to 389-users-leave@lists.fedoraproject.org Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/ List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines List Archives: https://lists.fedoraproject.org/archives/list/389-users@lists.fedoraproject.... Do not reply to spam on the list, report it: https://pagure.io/fedora-infrastructure

-- Sincerely,

William Brown

Senior Software Engineer, Identity and Access Management SUSE Labs, Australia