I am trying to find out all the member belonging to specific group but no success.
I tried this query
after connecting to LDAP
Trim(Upper(''&sAMAccountName)) as NTNAME,
DistinguishedName as KEY_User,
Name as USER,
department as [Division Function],
displayName as DisplayName,
mid(subfield(DistinguishedName,',',2),4) as [User Country],
company as [Legal Company],
mail as [E-Mail];
WHERE objectCategory='Person' AND objectClass='user' ;
distinguishedName as GroupKey,
cn as "Group Name",
subfield(member,'|') as KEY_User;
where objectCategory = 'GROUP' and objectClass='group'
and sAMAccountName='groupname1' or sAMAccountName='groupname2' or sAMAccountName='groupname3' or sAMAccountName='groupname4' or sAMAccountName='groupname5'
or sAMAccountName='groupname6' ;
This query gives me all the users & all the groups but nt user belonging to specific group.
Result as below