topic LDAP query Active Directory for field 'description' array in QlikView

LDAP query Active Directory for field 'description' array

Tue, 07 May 2013 09:49:47 GMT

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

Re: LDAP query Active Directory for field 'description' array

qlikviewforum — Tue, 23 Jul 2013 12:17:36 GMT

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

Re: LDAP query Active Directory for field 'description' array

GeoFev — Wed, 17 May 2023 15:10:33 GMT

Is there a solution to this problem since 2013? Thx

Re: LDAP query Active Directory for field 'description' array

ursaloff — Fri, 11 Oct 2024 17:48:20 GMT

I'm from 2024 - is there solution anywhere?

Re: LDAP query Active Directory for field 'description' array

mikaelsc — Fri, 11 Oct 2024 20:03:36 GMT

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

Re: LDAP query Active Directory for field 'description' array

GeoFev — Mon, 14 Oct 2024 07:19:12 GMT

Hi mikaelsc,

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

Re: LDAP query Active Directory for field 'description' array

ursaloff — Mon, 14 Oct 2024 07:51:57 GMT

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