Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
nicolai_moller
New Contributor

Active directory in QV

Hi

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'

1 Reply
MVP & Luminary
MVP & Luminary

Re: Active directory in QV

"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