LDAP query inner join

Discussion in 'Scripts' started by CodeCutter, Jan 5, 2009.

  1. #1
    I'm trying to get all members of all groups that begin with "X_", "Y_" or "Z_"

    So the members can be ANY value - but the groups must begin with "X_", "Y_" or "Z_"

    To do this I need an inner join on the LDAP query (to avoid looping through the returned recordset, then creating a group object and extracting members to get their properties)

    So my group query would be:
    "<LDAP://" & strDNSinfo & ">;(&(objectCategory=group)(|(name=X_*)(name=Y_*)(name=Z_*));distinguishedName;subtree"

    ...and I want all the members of that result to be included in the output recordset

    That means I need an inner join, surely? To get everything all at once in the one output recordset?

    Thanks anyone that can help!! CodeCutter
     
    CodeCutter, Jan 5, 2009 IP