Active directory in QV

nicolai_moller — Thu, 26 Nov 2015 10:03:40 GMT

I have created an app that connects to our Active Directory an retrives employee information. The QMC is also connected

via LDAP and when I lookup myself in th QMC I can also see which Groups I am a member of.

Is it possible to retrieve this Group information in a load script? I have tried the following fields, some of them return values and some don't.

SQL SELECT
displayName,
distinguishedName ,
SAMAccountName,
mail,
userPrincipalName,
SN,
givenName,
memberOf,
title,
systemFlags,
servicePrincipalName,
ou,
o,
department,
manager,
description,
co,
company,
directReports,
objectCategory,
profilePath ,
objectClass,
objectGUID,
legacyExchangeDN,
physicalDeliveryOfficeName,
userAccountControl
FROM 'LDAP://local.host'

Re: Active directory in QV

rwunderlich — Thu, 26 Nov 2015 18:55:43 GMT

"memberOf" is a multi-valued attribute. The AdsDSO connector does not return multi-valued attributes. See this recipe for a workaround:

Qlikview Cookbook: Load Users and Groups from Active Directory http://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

topic Re: Active directory in QV in QlikView

Active directory in QV

Re: Active directory in QV