How to Build a Search Filter in LDAP Query

All, I would like to know how to build a search filter in ldap query in order to search for the users from a particular group for a given DN and OU. Please note that I am making use of LDAP Tools plugin.

Here's the information of the LDAP environment:

Full LDAP Server URL: ldap://myhostname:389
Service Manager Username: CN=Administrator
Service Manager Password: Welcome@123
Base DN: dc=appian
OU: hr (heirarchically falls under dc=appian)
scsExternalSystemKey: ldap.local

And here's how I have tried configuring the search filter in various ways, but I am unable to retrieve any results:

1. ldapsearch(
config:{
scsExternalSystemKey:"ldap.local",
usePerUserCredentials:false,
url:"ldap://myhostname:389",
baseDN: "dc=appian,ou=hr"
},
searchFilter:"(&(ObjectClass=inetOrgPerson)(uid=user.1)(memberof=CN=development,OU=hr,DC=appian))",
attributes:{},
pagingInfo:a!pagingInfo(
startIndex:1,
...

OriginalPostID-214261

OriginalPostID-214261

  Discussion posts and replies are publicly visible

Parents
  • ...batchSize:-1
    )
    )

    2. ldapsearch(
    config:{
    scsExternalSystemKey:"ldap.local",
    usePerUserCredentials:false,
    url:"ldap://myhostname:389",
    baseDN: "dc=appian"
    },
    searchFilter:"(&(ObjectClass=inetOrgPerson)(uid=user.1)(memberof=CN=development,OU=hr,DC=appian))",
    attributes:{},
    pagingInfo:a!pagingInfo(
    startIndex:1,
    batchSize:-1
    )
    )

    3. ldapsearch(
    config:{
    scsExternalSystemKey:"ldap.local",
    usePerUserCredentials:false,
    url:"ldap://myhostname:389",
    baseDN: "dc=appian,ou=hr"
    },
    searchFilter:"(&(ObjectClass=inetOrgPerson)(uid=user.1)(memberof=CN=development,DC=appian))",
    attributes:{},
    pagingInfo:a!pagingInfo(
    startIndex:1,
    batchSize:-1
    )
    )

    Note:
    1. I know that 'LDAP' under 'Authentication' section in Admin Console might be an option but my prime intention is to make fn!ldapsearch() (of LDAP Tools plugin) work.
    2. Appian is able to talk to LDAP server successfully as I can see results when the search fil...
Reply
  • ...batchSize:-1
    )
    )

    2. ldapsearch(
    config:{
    scsExternalSystemKey:"ldap.local",
    usePerUserCredentials:false,
    url:"ldap://myhostname:389",
    baseDN: "dc=appian"
    },
    searchFilter:"(&(ObjectClass=inetOrgPerson)(uid=user.1)(memberof=CN=development,OU=hr,DC=appian))",
    attributes:{},
    pagingInfo:a!pagingInfo(
    startIndex:1,
    batchSize:-1
    )
    )

    3. ldapsearch(
    config:{
    scsExternalSystemKey:"ldap.local",
    usePerUserCredentials:false,
    url:"ldap://myhostname:389",
    baseDN: "dc=appian,ou=hr"
    },
    searchFilter:"(&(ObjectClass=inetOrgPerson)(uid=user.1)(memberof=CN=development,DC=appian))",
    attributes:{},
    pagingInfo:a!pagingInfo(
    startIndex:1,
    batchSize:-1
    )
    )

    Note:
    1. I know that 'LDAP' under 'Authentication' section in Admin Console might be an option but my prime intention is to make fn!ldapsearch() (of LDAP Tools plugin) work.
    2. Appian is able to talk to LDAP server successfully as I can see results when the search fil...
Children
No Data