Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Active Directory Query

I'm able to query connect and load active directory users and groups but unable to join the two together. Any help would be much appreciated.

5 Replies
Not applicable

Active Directory Query

Can you please post your script & error you are getting.

Not applicable

Active Directory Query

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';

Not applicable

Re: Active Directory Query

Hi,

I am also facing the same error.

Unable to get the user of the group.Any Help is appreciated.

Not applicable

Re: Active Directory Query

Hi,

there is Rob's QV CookBook with AD users and groups example: http://robwunderlich.com/downloads/ , maybe this can help.

ingridmerx
New Contributor III

Re: Active Directory Query

Does anyone have a plain text version of this chapter? Im using the desktop version and I cannot load more qvw files.