LDAP query Active Directory for field 'description' array

[#1]

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

[qlikviewforum]

Hi,

The QVW which tries to load the data from LDAP loads only the partial data frequently. We are unable to find the root cause of the issue as the QVW doesn't fails but it loads only the partial data.Can someone please help us to identify the root cause of the issue. It has been happening from quite a long time but we didn't succeed in finding the root cause of the issue. Hope someone can help us for the same.

Regards,

qvforum

[GeoFev]

Is there a solution to this problem since 2013? Thx

[ursaloff]

I'm from 2024 - is there solution anywhere? 

[mikaelsc]

there's not. something about multi value fields. 

use powershell instead (adapt for your needs) :

Get-ADUser -Filter * -SearchBase "DC=xxxxx,DC=xxxxx" -Properties name,department,title,description,o,sAMAccountName,distinguishedName,proxyaddresses,comment,uid ` | Select-Object name,department,title,description,@{name="o";expression={$_.o -join ";"}},sAMAccountName,distinguishedName,@{L = "ProxyAddresses"; E = { ($_.ProxyAddresses -like 'smtp:*') -join ";"}},comment,@{name="uid";expression={$_.uid -join ";"}} | Export-csv -Encoding UTF8 -Path '\\exportPATH\export_AD_with_descriptions.csv' -NoTypeInformation|Format-Table

[GeoFev]

Hi mikaelsc,

Thanks, I use powershell too (How to create an external program task in Qlik Sen... - Qlik Community - 1713044)

[ursaloff]

Thank you both actually already started to think about same solution use PowerShell instead 🙂