locked
QBDL LDAP script syntax RRS feed

  • 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 Matheisen
    MCSE+I, Exchange MVP
     

    --- Rich Matheisen MCSE+I, Exchange MVP
    Wednesday, May 25, 2011 1:57 AM