• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1802
  • Last Modified:

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
0
John Darby
Asked:
John Darby
  • 3
  • 2
1 Solution
 
markpalinuxCommented:

You need to use "publicDelegatesB"

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


Mark
0
 
markpalinuxCommented:


Thats "publicDelegatesBL", the attribute name you need to add.
0
 
John DarbyPMAuthor Commented:
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
0
 
markpalinuxCommented:


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
0
 
John DarbyPMAuthor Commented:
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
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.

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