Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nicolai_moller
Contributor
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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

"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