Imanami Community

I managed to create 2 queries:

1 - Contains exclusion as described at the previous post AND people based on the departments, here it is:

(&(objectCategory=user)(!displayName=*test*)(!employeeNumber=7*)(!displayName=R-*)(!msExchHideFromAddressLists=True)(!userAccountControl:1.2.840.113556.1.4.803:=2)(|(extensionAttribute2=department1)(extensionAttribute2=department2)(extensionAttribute2=department3)))

2 - Contains people which are distributed at 12 locations, here it is:

(|(extensionAttribute6=Location1)(extensionAttribute6=Location2)(extensionAttribute6=Location3)(extensionAttribute6=Location4)(extensionAttribute6=Location5)(extensionAttribute6=Location6)(extensionAttribute6=Location7)(extensionAttribute6=Location8)(extensionAttribute6=Location9)(extensionAttribute6=Location10)(extensionAttribute6=Location11)(extensionAttribute6=Location12)) 

The goal is to provide list of people to which all the conditions apply. Specifically those who works at the listed departments BUT those who are at these locations ONLY!!!!

Of cause to exclude - disabled, hidden e.t.c 

I'm swamped and I am falling terribly behind on my community posts.  I need to do some testing before I reply, so rather than delay my answer, I'm going to find another team member to help you.  You should see an update shortly.

Akatim, If I understand you correctly, you are looking for a AND relationship of query #1 and query #2. If that is the case, the objective can be achieved by appending query #2 to query #1, and let the '&' operator take effect, as shown in the following:

(&(objectCategory=user)(!displayName=*test*)(!employeeNumber=7*)(!displayName=R-*)(!msExchHideFromAddressLists=True)(!userAccountControl:1.2.840.113556.1.4.803:=2)(|(extensionAttribute2=department1)(extensionAttribute2=department2)(extensionAttribute2=department3))(|(extensionAttribute6=Location1)(extensionAttribute6=Location2)(extensionAttribute6=Location3)(extensionAttribute6=Location4)(extensionAttribute6=Location5)(extensionAttribute6=Location6)(extensionAttribute6=Location7)(extensionAttribute6=Location8)(extensionAttribute6=Location9)(extensionAttribute6=Location10)(extensionAttribute6=Location11)(extensionAttribute6=Location12)))

Would this work for you?

 Stephen

Stephen,

Yes, the following query probably will work, however how do I build it in SmartDL?

While trying to build the query in ADUC query designer windows I am limited by the number of character in the query. I'm not able to write the entire query there.
 

Thanks. 

I attached a screenshot of SmartDL to show how the query can be constructed. How that works for you.

  Stephen