Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
user filter in ldap integration  XML
Forum Index » SysAid Integration
 
Author Message
kert
SysAider

SysAider from release 5.1 Russian Federation
Joined: 23/06/2008
Messages: 4
Offline

Hello,

I'm trying to set up ldap filter for users in ldap intergation. I have 300 users in AD domain but i want only 80 of them to use SysAid
I've set up a special group SysAid for those users.
My user filter (&(sAMAccountName={1})(memberOf=CN=SysAid,OU=SysAid,DC=domain,DC=local)(mail=*))

but if i'm trying to update users from ldap - i'm recieving all 300 users insead of 80...

what's wrong?
Thank you



andrewl94133
Super SysAider

SysAider from release 5.1 Ireland
Joined: 18/06/2008
Messages: 72
Offline

Try the query: (&(sAMAccountName={1})(memberOf=*SysAid*)(mail=*))
kert
SysAider

SysAider from release 5.1 Russian Federation
Joined: 23/06/2008
Messages: 4
Offline

no difference, all 300 users in sysaid.

but if i use ldapsearch with the same filter - the result is 80 users...
andrewl94133
Super SysAider

SysAider from release 5.1 Ireland
Joined: 18/06/2008
Messages: 72
Offline

Did you delete all 300 users from the database BEFORE re-running the ldap import?
Haim
SysAid Wiz

Joined: 15/04/2008
Messages: 2449
Offline

Hello kert,
Where exactly did you placed the filter? you should put the filter under "user class filters"
The correct syntax for the filter should be:

(&(sAMAccountName=user)(memberOf=CN=SysAid,OU=SysAid,DC=domain,DC=local)

Also, can you please tell us why did you added the "(mail=*)" syntax? as the syntax dows not add anything to the filter.

Please try the above filter, and then delete all end users from your users list and then refresh the user list from LDAP and tell us if this is working.

Best regards.
Haim

Pushing IT forward
kert
SysAider

SysAider from release 5.1 Russian Federation
Joined: 23/06/2008
Messages: 4
Offline

Hello, Haim

I've put (mail=*) to exclude users who doesn't have an email address

Now my ldap config is:

user class filter: (&(sAMAccountName=user)(memberOf=CN=SysAid,OU=SysAid,DC=domain,DC=local))
user filter: sAMAccountName={1}

I also tried without user filter...

And when I delete all end users from database and refresh users from ldap - SysAid says "No users found"
andrewl94133
Super SysAider

SysAider from release 5.1 Ireland
Joined: 18/06/2008
Messages: 72
Offline

The user class filter should be (&(objectCategory=user)(memberOf=CN=SysAid,OU=SysAid,DC=domain,DC=local))

This of course assumes that the group's common name is SysAid, in the OU called SysAid off the domain root.
Haim
SysAid Wiz

Joined: 15/04/2008
Messages: 2449
Offline

kert wrote:Hello, Haim

I've put (mail=*) to exclude users who doesn't have an email address

Now my ldap config is:

user class filter: (&(sAMAccountName=user)(memberOf=CN=SysAid,OU=SysAid,DC=domain,DC=local))
user filter: sAMAccountName={1}

I also tried without user filter...

And when I delete all end users from database and refresh users from ldap - SysAid says "No users found"


Please open this case as a service request on our helpdesk by sending an email to helpdesk@ilient.com with sending screenshots of your LDAP configurations (the entire screen) and a copy of the SysAid log folder (zipped) for our review.

This information will assist us in resolving this issue on the best possible way.

best regards.
Haim

Pushing IT forward
kert
SysAider

SysAider from release 5.1 Russian Federation
Joined: 23/06/2008
Messages: 4
Offline

i've solved this problem by setting up these values:

user class filter: (&(objectCategory=user)(memberOf=CN=SysAid,OU=SysAid,DC=domain,DC=local)(mail=*))
user filter: sAMAccountName={1}

now it's working.
thanks for your attention
KieranCork
SysAider


SysAider from release 7 Ireland
Joined: 11/10/2010
Messages: 24
Offline

Hi guys - we want to do this too, but as a newbie, I've no idea where to enter this information. Can anyone give me a quick step-by-step?

Thanks.
WeZ
Super SysAider

SysAider from release 5.5 South Africa
Joined: 25/06/2008
Messages: 55
Offline

go to your integration section under your helpdesk settings. . . if you're still lost, check the documentation for your release . . .
JaneFrasier
Super SysAider


SysAider from release 6.5 United States Pathfinder
Joined: 25/03/2010
Messages: 93
Offline

This is the same thing I am trying to do.

I understand the part about the filters, but I don't know what I need to enter for User root and group root. Also do I enter something in Group Class Filter?

Thanks.
Forum Index » SysAid Integration
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
   SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011
   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use