Discussion Board for collaboration related to QlikView App Development.
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'
"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/