Okay, I have been working on getting this query right for an hour now, tried several combinations but I believe it is not all that easy to build an LDAP query, things like parentheses and ampersands...they are driving me mad right now ;-)
I have now created 2 seperated address lists in Exchange because I cannot seem to create one query to output the complete result I want. I have now composed 2 seperate queries which give me exactly the output that want, BUT only seperately. When I join these queries together I get a query which doesnt work or doesnt give me the output that I want. These are the queries: query 1: (&(&(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(! (homeMDB=*))(!(msExchHomeServerName=*)))(&(objectCategory=person) (objectClass=user)(msExchHomeServerName=*/cn=AA*))(& (objectCategory=person)(objectClass=contact)) )))) query 2: (&(objectCategory=group)(proxyAddresses=*a.mydomain.com)) - "AA" are the first letters of the servernames for that child domain. - "a" in "a.mydomain.com" is the name of my child domain. Both these queries are working but I cannot seem to make one query out of them. I guess the query I want to create should have some sort of AND in it because I want the results of both queries together in one query. Does anybody have any idea how to create one working query out of these two? ----- Oorspronkelijk bericht ----- Van: [EMAIL PROTECTED] Datum: woensdag, mei 31, 2006 11:27 am Onderwerp: Re: RE: [ActiveDir] LDAP query to create Exchange address list - organisation with child domains > Emm, it seems I just found it, might be usefull for anybody who > didnt > already know it, (probably just me): > > http://support.microsoft.com/default.aspx?scid=kb;en-us;312299 > > ----- Oorspronkelijk bericht ----- > Van: [EMAIL PROTECTED] > Datum: woensdag, mei 31, 2006 10:33 am > Onderwerp: Re: RE: [ActiveDir] LDAP query to create Exchange > address > list - organisation with child domains > > > I have made some progress and I think that this query should work: > > > > (&(&(& (mailnickname=*) (| > > (&(objectCategory=person)(objectClass=user)(!(homeMDB=*))(! > (msExchHomeServerName=*)))(&(objectCategory=person) > > (objectClass=user)(msExchHomeServerName=*/cn=AA*))(& > > (objectCategory=person)(objectClass=contact)) > > (objectCategory=publicFolder))(&(objectCategory=group) > > ([EMAIL PROTECTED] email address)))) > > > > Unfortunately I cannot paste this query in the LDAP query field > on > > the > > Advanced tab of the screen I get in when I click properties of > the > > address list. It seems I can only put a certain number of > > characters in > > there. > > > > > > ----- Oorspronkelijk bericht ----- > > Van: [EMAIL PROTECTED] > > Datum: woensdag, mei 31, 2006 9:55 am > > Onderwerp: Re: RE: [ActiveDir] LDAP query to create Exchange > > address > > list - organisation with child domains > > > > > Good idea, but I think I am doing something wrong. It is not a > > > matter > > > of the AL being displayed differently by the RUS on the hand > or > > > the AL > > > previeuw button on the other hand (at least in case of this > > > company it > > > isnt:-). > > > > > > The only thing I am looking at is the list which is displayed > > when > > > clicking the AL preview button. When I put the query described > > > beneath, > > > in the address list in ESM and I click the preview button, a > > list > > > is > > > displayed which also contains mail enabled groups from the > other > > > child > > > domains. I cannot seem to get the query right to not display > > those > > > groups. It looks like this problem is more difficult than I > > > thought it > > > would be. > > > > > > Still working on it. > > > > > > ----- Oorspronkelijk bericht ----- > > > Van: joe <[EMAIL PROTECTED]> > > > Datum: woensdag, mei 31, 2006 1:59 am > > > Onderwerp: RE: [ActiveDir] LDAP query to create Exchange > address > > > list - > > > organisation with child domains > > > > > > > First off, the test AL button in the ESM doesn't build the > AL > > > the > > > > same way > > > > that the RUS does. The RUS does not issue an LDAP query to > > build > > > > the AL, it > > > > looks at every object that is detected as changed (or at > every > > > > object if > > > > forced to rebuild) via USN change tracking and manually > > compares > > > > it to the > > > > AL LDAP filter. This means that bugs in either mechanism > could > > > > result in > > > > different lists being built, so basically, don't trust what > > ESM > > > > says the AL > > > > will have as members, it is pretty worthless. Set the filter > > and > > > > let the AL > > > > build the list. > > > > > > > > Because of how this is all implemented, there is no domain > > > > affinity for the > > > > building of the ALs. This means you need to focus on > something > > > > else. I would > > > > not focus on the email addresses since those are also being > > > > set/modified by > > > > the RUS, you want to use something else. This could be a > > > specific > > > > specialattribute you set on the objects that allow you to > > > > categorize them or add > > > > the users/groups to special groups that indicate what domain > > > they > > > > are in and > > > > add a memberof=somegroupdn component to the filter. > > > > > > > > > > > > > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED] On Behalf Of > > victor- > > > > [EMAIL PROTECTED]: Tuesday, May 30, 2006 3:53 PM > > > > To: ActiveDir@mail.activedir.org > > > > Subject: [ActiveDir] LDAP query to create Exchange address > > list - > > > > organisation with child domains > > > > > > > > I am in an organisation of which the Active Directory exists > > of > > > a > > > > parent root domain and 4 child domains. > > > > > > > > Each child domain has its own address list in Exchange. It > is > > > one > > > > Exchange organisation with 1 Administrative Group. > > > > > > > > Let's call these domains A, B, C, and D. > > > > > > > > When looking at each of these lists I see the following: > > > > > > > > - Users with Exchange mailbox > > > > - Users with an External e-mail address > > > > - Groups > > > > - Contacts > > > > - Public Folders > > > > > > > > The thing I dont want to see but what I cannot seem to get > rid > > > of > > > > is > > > > the fact that I see (mail enabled) groups from other child > > > domains > > > > in > > > > the address lists. > > > > > > > > Each child domain has several Exchange servers which names > > start > > > > with > > > > AA or BB or CC or DD, depending on the child domain for > which > > > they > > > > are > > > > serving. For instance the Exchange servers in child domain > A, > > > all > > > > start with AA. That is why I based the query on AA* for the > A > > > > child > > > > domain. > > > > > > > > For child domain A the query looks like this: > > > > > > > > (&(&(& (mailnickname=*) (| > > > (&(objectCategory=person)(objectClass=user)> > > > > > > (!(homeMDB=*))(!(msExchHomeServerName=*)))(&(objectCategory=person)> > > (objectClass=user)(msExchHomeServerName=*/cn=AA*))(& > > > > > > > (objectCategory=person)(objectClass=contact))(objectCategory=group)> > > (objectCategory=publicFolder) )))) > > > > > > > > What I would like to do is create an Exchange address list > > > without > > > > groups from other child domains in it. > > > > > > > > The strange thing is that when I build a query which > consists > > of > > > > groups based on the emailaddress/proxyaddress of that > specific > > > > child > > > > domain, the query gives an output of exactly those groups > > which > > > > are in > > > > that child domain, so far soo good. When I then add all > users > > > with > > > > an > > > > emailaddress/proxyaddress to that same query (I do this all > > from > > > > with > > > > ESM, right click address list etcetera), I get the message > > that > > > no > > > > items can be found by this criteria. > > > > > > > > Any help is greatly appreciated. > > > > > > > > > > > > > > > > > > > > > > > > > > > > List info : http://www.activedir.org/List.aspx > > > > List FAQ : http://www.activedir.org/ListFAQ.aspx > > > > List archive: http://www.activedir.org/ml/threads.aspx > > > > > > > > List info : http://www.activedir.org/List.aspx > > > > List FAQ : http://www.activedir.org/ListFAQ.aspx > > > > List archive: http://www.activedir.org/ml/threads.aspx > > > > > > > List info : http://www.activedir.org/List.aspx > > > List FAQ : http://www.activedir.org/ListFAQ.aspx > > > List archive: http://www.activedir.org/ml/threads.aspx > > > > > List info : http://www.activedir.org/List.aspx > > List FAQ : http://www.activedir.org/ListFAQ.aspx > > List archive: http://www.activedir.org/ml/threads.aspx > > > List info : http://www.activedir.org/List.aspx > List FAQ : http://www.activedir.org/ListFAQ.aspx > List archive: http://www.activedir.org/ml/threads.aspx > List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.activedir.org/ml/threads.aspx