topic Re: Active Directory Query in QlikView

Active Directory Query

Wed, 18 Aug 2010 12:18:00 GMT

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.

Active Directory Query

Wed, 18 Aug 2010 12:21:21 GMT

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

Active Directory Query

Wed, 18 Aug 2010 13:15:34 GMT

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

Re: Active Directory Query

Mon, 17 Sep 2012 08:53:59 GMT

Hi,

I am also facing the same error.

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

Re: Active Directory Query

Mon, 17 Sep 2012 09:06:52 GMT

Hi,

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

Re: Active Directory Query

ingridmerx — Thu, 01 Dec 2016 14:03:39 GMT

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