If you are not interested in retrieving a bunch of fields that you don't need, you may want to use th -L switch with CSVDE
CSVDE -f C:\Export.txt -r "(&(mailnickname=*)(objectClass=user))" -L DisplayName,name,ProxyAddresses The command above will only export each user's display name, username, and e-mail addresses. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fyodorov, Andrey FTL Sent: Wednesday, March 31, 2004 3:12 PM To: Exchange Discussions Subject: RE: SMTP Addresses CSVDE will export all the objects from AD into text files based on a query. You can shoot a query to export only mail-enabled objects. You can then process the text file to find the users that have multiple SMTP addresses. A CSVDE command would go like this: CSVDE -f C:\Export.txt -r "(&(mailnickname=*)(objectClass=user))" Then you can use FINDSTR command with regular expression switch. FINDSTR /I /R /C:".*smtp:[EMAIL PROTECTED]:[EMAIL PROTECTED]" c:\export.txt The command above will find all the records that have SMTP address twice. (.* means any character repeated zero or more times) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bowles, John (OIG/OMP) Sent: Wednesday, March 31, 2004 1:16 PM To: Exchange Discussions Subject: RE: SMTP Addresses Thanks for the suggestions. Since I'm not familiar with these utilities, do they run queries on all the mail enabled objects in AD? Rather than running through it user by user? Basically what I'm looking for is something that will run through all the objects and then show the results for users or contacts that have more than one SMTP address. __________________ John Bowles Exchange Engineer OIG/HHS W.202.690.6342 C.202.327.1377 F.202.690.7446 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Fyodorov, Andrey FTL [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 11:59 AM To: Exchange Discussions Subject: RE: SMTP Addresses CSVDE, LDIFDE -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bowles, John (OIG/OMP) Sent: Wednesday, March 31, 2004 11:48 AM To: Exchange Discussions Subject: SMTP Addresses All, Is there any utility inside of AD that allows you to check to see if users or contacts have multiple SMTP addresses? All 2000 shop. Thank you, __________________ John Bowles Exchange Engineer OIG/HHS [EMAIL PROTECTED] _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&; lang =english To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&; lang=english To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&lang =english To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&lang =english To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with. _________________________________________________________________ List posting FAQ: http://www.swinc.com/resource/exch_faq.htm Web Interface: http://intm-dl.sparklist.com/cgi-bin/lyris.pl?enter=exchange&text_mode=&lang=english To unsubscribe: mailto:[EMAIL PROTECTED] Exchange List admin: [EMAIL PROTECTED] To unsubscribe via postal mail, please contact us at: Jupitermedia Corp. Attn: Discussion List Management 475 Park Avenue South New York, NY 10016 Please include the email address which you have been contacted with.
