oh come on joe - you can do better than that - this should be a simple additional option in adfind ;-)
actually works nicely and I could already come up with various other use-cases. Thanks, Guido -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of joe Sent: Dienstag, 31. Mai 2005 04:10 To: [email protected] Subject: RE: [ActiveDir] Need AD Query Suggestion Please Bite me Kingslan.... In the meanwhile if you want the unique list for your entire forest adfind -gc -b "" -f "&(objectcategory=person)(department=*)" department -nodn -nolabel -q | unique You can get adfind here http://www.joeware.net/win/free/tools/adfind.htm You can unique here http://www.joeware.net/win/free/tools/unsupp/Unique.zip This combination of commands will dump a sorted unique list of departments. joe -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick Kingslan Sent: Tuesday, May 24, 2005 1:07 PM To: [email protected] Subject: RE: [ActiveDir] Need AD Query Suggestion Please Oh, Jorge! Please stop! We can barely get joe's head through most doors as it is now.... He REALLY doesn't need another cheerleader! ;op Rick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jorge de Almeida Pinto Sent: Tuesday, May 24, 2005 9:40 AM To: 'Jerry Welch '; '[EMAIL PROTECTED] '; '[email protected] ' Subject: RE: [ActiveDir] Need AD Query Suggestion Please don't thank me.. thank the guy who created the tool!. His name is Joe and he can type more in a message than you can say in one day.. ;-) #JORGE# -----Original Message----- From: [EMAIL PROTECTED] To: [email protected] Sent: 5/24/2005 4:32 PM Subject: RE: [ActiveDir] Need AD Query Suggestion Please Cool filter !! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jorge de Almeida Pinto Sent: Tuesday, May 24, 2005 9:56 AM To: 'Krenceski, William '; '[EMAIL PROTECTED] '; '[email protected] ' Subject: RE: [ActiveDir] Need AD Query Suggestion Please To get all departments (incl DUPs) try the following: ADFIND -h <your server> -nodn -nolabel -s subtree -b "<your base dn>" -f "(&(objectCategory=person)(department=*)" department > OUTPUT.TXT Load OUTPUT.TXT into excel, sort by name and list only unique values using a filter (pull down -menu data->filter->advanced filter Cheers #JORGE# PS.: you can get ADFIND from www.joeware.net -----Original Message----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [email protected] Sent: 5/24/2005 3:33 PM Subject: RE: [ActiveDir] Need AD Query Suggestion Please Every AD user and contact has a department assigned Querying by OU would not work because some departments do not fit perfectly with they're OU (Departments are payroll based, not necessarily function based). I was hoping to run something like (&(objectCategory=user)(department=*)) and only display department AND supress duplicates. -----Original Message----- From: Jorge de Almeida Pinto [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 24, 2005 8:53 AM To: Krenceski, William; '[EMAIL PROTECTED] '; '[email protected] ' Subject: RE: [ActiveDir] Need AD Query Suggestion Please How are the departments represented in AD? -> OUs, groups, something else? Cheers #JORGE# -----Original Message----- From: [EMAIL PROTECTED] To: [email protected] Sent: 5/24/2005 2:39 PM Subject: [ActiveDir] Need AD Query Suggestion Please Hello, I am looking for a query or script that will go out and query all departments in active directory (the easy part) AND I want to suppress duplicates as to get a list of unique departments. Not caring about displaying the users or anything else with the query. William Krenceski Network Administrator Olean General Hospital 515 Main Street Olean, NY 14760 Tel: 716-375-6475 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Confidentiality Notice: The information contained in this message may be legally privileged and confidential information intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any release, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error please notify the author immediately by replying to this message and deleting the original message. Thank you. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. 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/ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. 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/ This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. 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/ 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/
