You need to set the base DN for your search. I've never used Pentaho so I can't tell you how to do this. Try searching the documentation for search base DN or search base distinguished name
Joined: Aug 28, 2006
Thanks for the quick reply Joanne,
When I set Search base attribute in Pentaho = "ou=groups, dc=test,dc=comp,dc=net"
It returns ALL the groups hierarchy from LDAP
When I set it to one of the group, it returns all the direct members
Now our requirement is to fetch group/user hierarchy of given group, "MY_GROUP_NAME"
Joined: Aug 05, 2005
You need to set the scope of your search. It appears that your first search id set to a subtree scope (which will return the entire hierarchy) whilst your second is set to One (which will only return immediate sub items).