Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
Dear all,
I'm trying to get some informational data out of active directory via LDAP connection.
UserTable:
LOAD
name,
type,
description;
SQL select
name, type, description
FROM 'LDAP://$(RootDse)' WHERE objectCategory='Computer'
This is an example with just 3 fields. name, type, description,
while name and type will load correctly. but 'description' will always be empty in qlikview (but not NULL), although there is definitely a value into this AD-field.
May it be that this field is an array and if yes, how would it be possible to get the value into my query?
Any help is very appreciated.
Regards,
Oliver