RE: [ActiveDir] GroupBy type queries in LDAP

[joe]

Depends on the size of the result set (number of rows) and the size of the attribute being returned. A small number of rows or a small size of attribute would make this most feasible.     joe     p.s. Real scripters call that an associative array or hash and it represented by %var... LOL   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, April 04, 2005 6:26 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] GroupBy type queries in LDAP Would putting the output into a dictionary set and then sorting and writing them out not be feasible? Would this not be easier (and on-the-flyish) than dumping it into SQL?     Sincerely,   D�j� Ak�m�l�f�, MCSE+M MCSA+M MCP+I Microsoft MVP - Dir. Services / Security www.readymaids.com - we know IT www.akomolafe.com Do you now realize that Today is the Tomorrow you were worried about Yesterday?  -anon -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gil Kirkpatrick Sent: Monday, April 04, 2005 2:47 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] GroupBy type queries in LDAP   Can't do that in LDAP... About the best you can do is use the LDAP sort control to get a list of entries sorted by Attribute1, but that only gets you halfway to what you want.   I suspect Al's strategy is the best way to go.   -gil   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mulnick, Al Sent: Monday, April 04, 2005 2:34 PM To: ActiveDir@mail.activedir.org Subject: RE: [ActiveDir] GroupBy type queries in LDAP   Is it just user objects?    (&(objectClass=User)(objectCategory=Person)(Attribute1=*)) Would return all user objects that have a value for Attribute1.    If you only wanted all user objects where Attribute1 was a duplicate, I would *think* you have to query based on what's filled in there. i.e. Attribute1=someduplicatevalue or something similar.    Might be more productive to bring all of the needed data into a SQL table and then do your query. LDAP isn't going to do that type of logic that I'm aware of.   I'd love to hear differently though :)   Al   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Palenchar Sent: Monday, April 04, 2005 5:23 PM To: ActiveDir@mail.activedir.org Subject: [ActiveDir] GroupBy type queries in LDAP   OK, LDAP evangelists,   I need to query our customer-facing AD for a list of all the users who share a particular attribute. Let's call that attribute "Attribute1."   So, if two people have the same value in Attribute1, I need their DN.   The trick is, that I want the results for all possible values of Attribute1.   In SQL, I would use group by Attribute1 having count(Attribute1) >1 to get a list of all Attribute1 values where more than one object had the same value. I would then join that back to the table to get a list of all the DN's with those values of Attribute1.   Is there a way to do this with an LDAP query.   Please note that the directory contains millions of objects and iterating through them will be painful.     -Jeremy List info   : http://www.activedir.org/List.aspx List FAQ    : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info   : http://www.activedir.org/List.aspx List FAQ    : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info   : http://www.activedir.org/List.aspx List FAQ    : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/