How to export user information from AD to Excel 1

[whoisthat]

I have a few thousand contacts in Win2K AD and would like to export them into excel file. How do I accomplish this?

Thanks!
Henry

 

[wallst32]

Use CSVDE.EXE to export the information in CSV format, and open in Excel.

 

[whoisthat]

Does this also export just the names or also email addresses?

Thanks,

 

[xmsre]

For groups:

csvde -f c:\dls.txt -r "(&(objectCategory=group)(proxyAddresses=*))"



For users:

csvde -f c:\users.txt -r "(&(objectCategory=user)(proxyAddresses=*))"



Run those off the DC itself and the export files will be in the root of the C: drive as specified above. Note that this will export ALL mail enabled objects (groups and users) and not just some that are associated with a specific SERVER (which is impossible in case of groups anyway as their membership does not have server boundary).



The CSV export file can then be opened in your spreadsheet program and you can get rid of data columns that are not needed for what you are trying to do.



To specify which attributes to export (so you can not have to customize the output):



-l list - List of attributes (comma separated) to look for in an LDAP search

the attribute you want is proxyaddresses.

csvde -f c:\users.txt -r "(&(objectCategory=user)(proxyAddresses=*))" -l proxyaddresses

create a list of all users that have email addresses that contains the cn and proxyaddresses.

or, if you'd rather use the GUI, use admodify:

ftp://ftp.microsoft.com/PSS/Tools/Exchange%20Support%20Tools/ADModify/