how to export username and email address using cdvde

[BwiseIT]

I can't seem to get the syntax correct for exporting the user name and email
address from my LDAP db. I don't have organizational units. I would like to
export the entire global address list getting only the display name and the
smtp address. This is what i have tried.

csvde -r "(objectClass=user)" -d "dc=domain,dc=com" -l
displayName,proxyAddresses -f c:\users.csv

What if there is more than one smtp addess? Can i specify only the 1st one?

Thanks
Bobby

 

[Richard Mueller]

I can't seem to get the syntax correct for exporting the user name and
email address from my LDAP db. I don't have organizational units. I would
like to export the entire global address list getting only the display name
and the smtp address. This is what i have tried.

csvde -r "(objectClass=user)" -d "dc=domain,dc=com" -l
displayName,proxyAddresses -f c:\users.csv

What if there is more than one smtp addess? Can i specify only the 1st
one?

Hi,

Don't enclose the filter or search base in quotes. Use:

csvde -r (objectClass=user) -d dc=domain,dc=com -l
displayName,proxyAddresses -f c:\users.csv

For multi-valued attributes you get all values, you can't just ask for the
first.

 

[BwiseIT]

Perfecto! I'll get the hang of this ActiveDirectory stuff one of these days.

Thanks a bunch!
Bob