Powerful Directory Management Tool

[RichB]

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

[Support]

Hello,

Please, try the following query:

Code: Select all

SELECT $distinguishedName, $mail FROM "... my company ..." WHERE $sAMAccountName='user1' OR $sAMAccountName='user2' OR $sAMAccountName='user3';


[RichB]

Hello!

Not that short but okay

Thank you!

brg,
Richard