LDAP-SQL - How to search multiple objects

General Discussion about LDAP Administrator

Moderator: Support

LDAP-SQL - How to search multiple objects

Postby RichB » Fri Feb 05, 2016 10:27 am

Hello!

I want to use the following SQL Query:

SELECT $distinguishedName, $mail FROM "... my company ..." WHERE $sAMAccountName IN ('user1', 'user2', 'user3')

Can you tell me how to achieve this using LDAP-SQL?

brg,
Richard
RichB
 
Posts: 2
Joined: Fri Feb 05, 2016 9:15 am

Re: LDAP-SQL - How to search multiple objects

Postby Support » Mon Feb 08, 2016 11:15 am

Hello,

Please, try the following query:
Code: Select all
SELECT $distinguishedName, $mail FROM "... my company ..." WHERE $sAMAccountName='user1' OR $sAMAccountName='user2' OR $sAMAccountName='user3';
Support
 
Posts: 887
Joined: Sun Aug 12, 2001 12:00 am

Re: LDAP-SQL - How to search multiple objects

Postby RichB » Mon Feb 08, 2016 11:31 am

Hello!

Not that short but okay ;-)

Thank you!

brg,
Richard
RichB
 
Posts: 2
Joined: Fri Feb 05, 2016 9:15 am


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron