Hey...just FYI...a bunch of posts came through a couple of days ago about KDC event 11, which reminded me that I've got some myself. I've been using Dean's nifty little script here to identify the objects with duplicate serviceprincipalname attrs. Working great.
Thanks Dean! -DaveC Reuters IS&T Service Delivery -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean Wells Sent: Wednesday, April 06, 2005 6:18 PM To: Send - AD mailing list Cc: [EMAIL PROTECTED] Subject: RE: [ActiveDir] GroupBy type queries in LDAP Since a solution hasn't manifested itself to date, I got intrigued and tried to put this together in a simple and relatively fast shell script ... which I've enclosed as a text file (if memory serves I am able to enclose small text files). The script requires two args; a QUOTED "DN" and the LDAP name of the attribute to look at. Hope this serves your purpose, if not, I'm certain it will serve me at some point in the future :) Dean -- Dean Wells MSEtechnology * Email: [EMAIL PROTECTED] http://msetechnology.com -----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/ ----------------------------------------------------------------- Visit our Internet site at http://www.reuters.com To find out more about Reuters Products and Services visit http://www.reuters.com/productinfo Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd. 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/