Answered by:
QBDL LDAP script syntax

Question
-
I have this LDAP string in a QBDL:
(&(!cn=SystemMailbox{*})(&(&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(!(homeMDB=*))(!(msExchHomeServerName=*)))(&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*)))(&(objectCategory=person)(objectClass=contact))(objectCategory=group)(objectCategory=publicFolder)(objectCategory=msExchDynamicDistributionList) )))(objectCategory=user)(!description=*service*)(!description=monster*)(!description=ground*)(!description=pool*)(!description=house*))))
In addition to the above results, I also need to include the membership of a normal distribution group whose name begins with "Floaters", located in the same OU as the referenced QBDL. I tried this syntax but the preview isn't returning results. What do I have messed up?
(&(!cn=SystemMailbox{*})(&(&(&(& (mailnickname=*) (| (&(objectCategory=group)(objectCategory=person)(objectClass=user)(!(homeMDB=*))(!(msExchHomeServerName=*)))(&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*)))(&(objectCategory=person)(objectClass=contact))(objectCategory=group)(objectCategory=publicFolder)(objectCategory=msExchDynamicDistributionList) )))(objectCategory=user)(!description=*service*)(!description=monster*)(!description=ground*)(!description=pool*)(!description=house*)(cn=Floaters*))))
Thanks!
Jim
Tuesday, May 24, 2011 2:17 PM
Answers
-
Looks like I forgot a close parenthesis at the end. So my only other question is, if I have this query applying only to the current OU, is there any need for the other 'fluff' from the original filter created by the GUI?
- Marked as answer by Alan.Gim Tuesday, May 31, 2011 1:22 AM
Tuesday, May 24, 2011 8:07 PM
All replies
-
So each of these filters work correct individually:
---
(&(objectCategory=user)(!description=*service*)(!description=monster*)(!description=ground*)(!description=pool*)(!description=house*)))
(objectCategory=group)(cn=Floaters*)
---
But when I try to combine them they return no results:
---
(|(&(objectCategory=group)(cn=Floaters*))(&(objectCategory=user)(!description=*service*)(!description=monster*)(!description=ground*)(!description=pool*)(!description=house*))
---
Do I need that other 'fluff' which the GUI added in the original filters (ignore system mailboxes, homemdb, servername, etc, etc)? What's wrong with my syntax in the combined filter above?
Tuesday, May 24, 2011 6:58 PM -
Looks like I forgot a close parenthesis at the end. So my only other question is, if I have this query applying only to the current OU, is there any need for the other 'fluff' from the original filter created by the GUI?
- Marked as answer by Alan.Gim Tuesday, May 31, 2011 1:22 AM
Tuesday, May 24, 2011 8:07 PM -
On Tue, 24 May 2011 20:07:24 +0000, JimCass wrote:>Looks like I forgot a close parenthesis at the end. So my only other question is, if I have this query applying only to the current OU, is there any need for the other 'fluff' from the original filter created by the GUI?No.---Rich MatheisenMCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVPWednesday, May 25, 2011 1:57 AM