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