Imanami Community

Hello,

We have a query at the AD which runs fine and present us the needed results, however when I try to use the same query at "Smart DL" I receive totally different results. How can I paste the query I'm using to the DL group that I'm trying to create? At the process of the group creation there is a filter are where I can paste the query however it do not work. I get wrong results.

Thank you.
 

Hi,

You can export the query in the query designer (in SmartDL) to a text file, paste the query, and then re-import but it is a little tricky.

 

--Robert
 

Hi Robert, thank you for your reply.

I failed to do as you suggested.Here is the query which run properly at the AD snap-in:

(&(objectCategory=user)(!objectclass=Contact)(homeMDB=*)(!description=*external*)(!displayName=*test*)(!employeeNumber=7700*)(!displayName=R-*)(!msExchHideFromAddressLists=True)(!memberOf=someDistributionList)(extensionAttribute4=DepartmentName)(|(!msExchUserAccountControl=2)(description=SomeDescription)))

 

How can I add this query to SMARTDL?

Thanks
 

 

 

 

Here is the equivelent query in SmartDL:

(&(&(|(homeMDB=*)(msExchHomeServerName=*))(objectCategory=person)(objectClass=user)(mailNickname=*)(!cn=SystemMailBox{*}))(&(!description=*external*)(!displayName=*test*)(!employeeNumber=7*)(!msExchHideFromAddressLists=true)(!memberOf=DistinuishedNameOfSomeDistributionList)(extensionAttribute4=DepartmentName)(|(!userAccountControl:1.2.840.113556.1.4.803:=2)(description=SomeDescription))))

See the attached screen shots for how to build it in the Query Designer.

Second screenshot...

This is perfectly works.

Thank you very much. 

Ok, there still an issue.

The AD query displays 1361 objects, SMARTDL's - 1300

 

The query posted had an invalid predicate: (!useraccountcontrol=2).  I believe you want to exclude disabled accounts so I modified the query to reflect that:

(!userAccountControl:1.2.840.113556.1.4.803:=2)

That might explain the difference.

I would like to exclude ONLY those disabled accounts which do not have specific description.
If the account is disable but the text in the description filed matches the one I need I want to include this account. 

Yes, the query I gave is doing that.  The original query you posted was not excluding disabled accounts which do not have the specific description.  This might account for the difference in results.

Hi Robert,

The proposed solution worked, thank you.

I have currently an LDAP query which not fitting the AD, looks like there is some limitation. It quite long, I'm pretty sure it's configured properly.

How can I import it to the SmartDL?

When I do an import at SmartDL I receive the following error:

http://img409.imageshack.us/img409/1131/64286060px5.jpg 

 

Thanks 

 

Only a portion of the SDL query is in LDAP format.  It has extra data in there.  Be careful to only replace the LDAP query portion before importing into SDL.

 I can send you the query in PM if possible, it contains only LDAP query.
 

I am not sure I totally understand what you are doing.  Are you importing a query in the query designer?  If yes, please export the existing query and post the file here.  Then post the query.  I'll take a look and post my suggestions.

I have several prerequisites for the query, as display name doesn't contain some characters, based on the previous posts in this thread. In addition to that I want to have users which works in some departments (custom attribute 2) which are about 1000 people (3 departments all together) - this part is working.

From this list of people (1000) I would like to have list of those based on location (custom attribute 6) which are 12 locations. Here is where I stuck.

Here is the query that works:

(!displayName=*test*)(!employeeNumber=7*)(!displayName=R-*)(!msExchHideFromAddressLists=True)(!userAccountControl

:1.2.840.113556.1.4.803:=2)(|(extensionAttribute2=department1)(extensionAttribute2=department2)(extensionAttribute2=department3)

 

From this list I want to extract only those that  "extensionAttribute6" is something. There is 12 locations.

12 x "extensionAttribute6" = all the people that working at those 12 locations.

 

I hope it more clear now.