asked on

CSVDE syntax on a specific query

I am trying to construct a CSVDE query to pull usernames, paired with the people they've delegated Mailbox authority through thier Outlook Delegation tab. I have a query constructed, but am not meeting with success. Could you help me correct the statement below...

csvde -d RootDN -r "(objectClass=user)(name=*)(PUBLICDELEGATES=*)) -l (user,publicdelegates) -f c:\distname.csv

Thanks you,
John

markpalinux

You need to use "publicDelegatesB"

Take a look here
http://hellomate.typepad.com/exchange/2004/09/listing_which_e.html

Mark

ASKER CERTIFIED SOLUTION

markpalinux

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

John Darby

ASKER

Mark,

for some reason the command is not ourputting. Is this syntax correct?

PS H:\> csvde -d RootDN -r "(objectClass=user)(name=*)(publicDelegatesBL=*)) -l (user,publicdelegates) -f c:\distname.c

Thanks man!
John

markpalinux

John,

rather then:
H:\> csvde -d RootDN -r "(objectClass=user)(name=*)(publicDelegatesBL=*)) -l (user,publicdelegates) -f c:\distname.c

Try
H:\> csvde -d RootDN -r "(&(objectClass=user)(name=*)(publicDelegatesBL=*))" -l (user,publicdelegates) -f c:\distname.c

and be sure the RootDN is the "dc=some,dc=domain,dc=com" or like that if you do a sample output of one user then you can look at the correct AD domain name.

to export single user:
ldifde -s domaincontroller -f out1.txt -d dc=some,dc=domain,dc=com -r "(sn=yourlastname)"

Mark

John Darby

ASKER

Mark,

thats for the link to the great Exchnage Blod, the ldifde and csvde sommands.

I appreciate your assist and am stoked to get to work tomorrow to see how the exports run!

BTW, what kind of work do ya do? Where is home?

Take care,
John