Not receiving an error. Its just not joining my the two together properly for me. If I try putting in a left join the i don't get any group info. If I leave the join out then I get all user and group info but not linked any any way. What I want to be able to do is click on a user and see the groups that he is a member of.
users:
load
distinguishedName
as KEY_User,
cn
as Userid,
displayName,
givenName,
sn,
mail,
userAccountControl;
sql
select distinguishedName,cn,displayName,givenName,sn, mail,userAccountControl
FROM 'LDAP://my domain is entered here';
groups:
left join (users)
load
distinguishedName
as GroupKey,
cn
as "Group Name",
subfield (member,'|')
as KEY_User;
sql select distinguishedName,cn,member
FROM 'LDAP://my domain is entered here';
