Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Exporting email list and addresses in Exchnage 2003

I am tying to export a list of email addresses with email forwarding (if any) for all AD users and contacts created in my organization.  I would like to export to an xls or csv file.  Is this possible?
0
rbarwig
Asked:
rbarwig
  • 2
  • 2
  • 2
1 Solution
 
Mike KlineCommented:
I don't have exchange installed right now but try this
use adfind from Joe Richards
http://www.joeware.net/freetools/tools/adfind/index.htm
adfind -default  "&(objectcategory=person)(altrecipient=*)" name
 I can't fully test right now without exchange but please let me know how that works. (should get contacts and users)
Thanks
Mike
0
 
rbarwigAuthor Commented:
Mike,

Trying to use the advanced help, I do not see how this is piped into a file, thoughts?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
rbarwigAuthor Commented:
x-sam
Running on the exchange server, it does not export email addresses and forwarders
0
 
Mike KlineCommented:
I'll pipe it into a csv here:
adfind -default  "&(objectcategory=person)(altrecipient=*)" name -csv > c:\forwarders.csv
See if that does it for you
Thanks
Mike
0
 
SurajCommented:
csvde -f output.txt would export all the objects in the AD and you can more precisely put this as

csvde -f output.txt -r objectcategory=person would yeild all the user objects.

You would need to check the attribute proxyaddresses which would yeild the email addresses and forwarders mentioned in the user property.

Thanks,
x-sam
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now