[asgt]

Hi Guys,

I don't know to much about LDAP queries so I hope someone can help me out!

I have an LDAP filter which I can use in ADUC to see which users have Outlook Web Access enabled. If it helps, the filter is " (& (objectClass=user)(homeMDB=*)(!protocolSettings=HTTP§0§1§§§§§§)) ".

If I want to export the users who show when the filter is applied to a .csv file, I have to go to each OU individually and export each to a separate file. We have separate OUs for Branch staff and Head Office staff. The Head Office OU is further divided by department.

I have found a website explaining the use of CSVDE (here). It explains the use of the -f and -r switches (eg CSVDE -f export.csv -r "(&(objectClass=user)(sn=Thomas))" ).

I was wondering if it was possible use CSVDE with the LDAP filter to only export the filtered sample?


If it doesn't make sense, let me know and I'll try to clarify!
Thanks for any help.

Andy

[Kirok]

Yeah that should work no problem sometimes theres is an issue with wildcards but the query looks okay.

You could also use LDIFDE, heres a couple of articles talking you through it if you need more

http://searchwindowsserver.techtarge...191071,00.html
http://searchwindowsserver.techtarge...192536,00.html

More info on CSVDE also, rather than me paraphrasing http://exchangeis.com/blogs/exchange...d-example.aspx

[asgt]

Thanks for the links - they look very promising.

I'll give it a try in the morning and report back.

Andy

[asgt]

Using the links Kirok supplied proved helpful although maybe a little above my level!!

I have composed the following query = csvde -f c:\owa_on.csv -r (& (objectClass=user)(homeMDB=*)(!protocolSettings=HTTP§0§1§§§§§§))

When I try to run this, I get the following message "(homeMDB was unexpected at this time". Could this be because I haven't told it which domain or OU to look in?

My limited knowledge suggests something like "DC=mydomainhere DC=net" would need to go somewhere but I'm not sure on the correct syntax (I think thats the right word!). Would anyone be able to help me out?


Also, I can see a lot of benefit to using this tool (and LDIFDE) so if anyone could recommend a good training course (in the UK) or a good book or website I'd much appreciate it!!


Many thanks

Andy

[Kirok]

Yeah probably because it doesn't know where to look. I know of no training for this specifically. I think O'Reilly has an an active directory cookbook though.

Anyway just try this.

Who has OWA disabled

dsquery * -filter "&(objectcategory=person)(objectclass=user)(mailnickname=*)(protocolsettings=HTTP?0*)"

Who has OWA enabled

dsquery * -filter "&(objectcategory=person)(objectclass=user)(mailnickname=*)(homemdb=*)(!protocolsettings=HTTP?0*)"

Then pipe the output to a file if needed. Those other tools can be used for this but I prefer this one.

The protocol setting could change based on version I think for Exchange 2003 its (protocolsettings=HTTP?0*) and for 2007 its (protocolsettings=*OWA?0*) yours could be different though.

[asgt]

Managed to get it working by opening ADUC going into Saved Queries and creating a Custom Query with (& (objectClass=user)(homeMDB=*)(!protocolSettings=HTTP§0§1§§§§§§)) in the LDAP filter.

Works a charm! Now to sort Outlook Mobile Access (check the new thread)!!!