Exchange Server Forums

Export Email Address available Users (CSVDE)

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [Microsoft Exchange 2003] >> General >> Export Email Address available Users (CSVDE)

Page: [1]

Message

<< Older Topic Newer Topic >>

Export Email Address available Users (CSVDE) - 3.Aug.2008 8:23:23 AM

chanaka1980

Posts: 68
Joined: 6.Sep.2006
Status: offline

Hi

I want to Export All the Email Address available users, I tried but when I check the output file there I can see the Computers and email address not available yours as well, why is it? below command i used to Export the details

CSVDE -f C:\name.csv -d "dc= disasterRecovery,dc=com" -r "((objectClass=user))" -l "givenname,sn,mail"

DN Mail givenName SN
CN=Administrator,CN=Users,DC=DisasterRecovery,DC=com Administrator@DisasterRecovery.com

CN=Susan Rebello,CN=Users,DC=DisasterRecovery,DC=com SusanR@DisasterRecovery.com Susan Rebello

CN=ITN65,CN=Computers,DC=DisasterRecovery,DC=com

CN=Yati,CN=Users,DC=DisasterRecovery,DC=com Yati

why is showing the output file computer and email address not Available users also.

Pls support to me

Regards,
AUCSNA.

Post #: 1

Featured Links*

RE: Export Email Address available Users (CSVDE) - 3.Aug.2008 9:30:20 AM

bsakata

Posts: 26
Joined: 18.Jan.2008
Status: offline

that's becase a computer object in ad is part of the objectclass user as well.

Try this for your ldap filter: (objectclass=user)(mail=*)

(in reply to chanaka1980)

Post #: 2

RE: Export Email Address available Users (CSVDE) - 3.Aug.2008 1:53:52 PM

chanaka1980

Posts: 68
Joined: 6.Sep.2006
Status: offline

Hi Bsakata,

thanks for ur prompt reply, actually that query is work fine, when i go to dsa.msc and new query and custome search (objectclass=user)(mail=*) , then i can see the email address users,

but i want to know how to filter email address available users, using CSVDE command and i want to export to csv file, how can i do that?

please support to me.

(in reply to bsakata)

Post #: 3

RE: Export Email Address available Users (CSVDE) - 4.Aug.2008 8:39:08 AM