LDAP - AD group data extraction issue

Tue, 28 Jul 2015 19:38:54 GMT

Extracting data from ADgroups

groupnames:
load * inline [
Groupname
GRP-EXT-Customers-500
GRP-EXT-Customers-301
GRP-EXT-Customers-402

];

for i = 0 to NoOfRows('groupnames') - 1
let group = peek('Groupname', i, 'groupnames');
let groups = chr(39)& 'CN=' & group & ',OU=Groups,OU=Other,OU=Customers,DC=ext,DC=companyname,DC=com' & chr(39);

     LET arg=chr(01); //
     DO
AD:
LOAD distinct
*,
'$(group)' as Groupname, //
                samAccountName as Name1
;
SQL Select
displayName,
mail,
givenname,
sn,
samAccountName,
lockoutTime

from 'LDAP://servername.companyname.com/OU=Users,OU=Accounts,OU=Other,OU=Customers,DC=ext,DC= companyname,DC=com' where memberOf = $(groups) and samAccountName >'$(arg)';

EXIT DO WHEN ScriptError > 1    //
           EXIT DO WHEN NoOfRows('AD') = 0 // Stop loop if SELECT returns nothing
           EXIT DO WHEN peek('samAccountName') = '$(arg)'; // --> no more entries

LET arg=peek('samAccountName'); //

LOOP

next

It is not extracting more than 1000 records.OLEDB read failed and QVX_UNEXPECTED_END_OF_DATA errors.I am getting this issues after QV11 version.

Re: LDAP - AD group data extraction issue

prabhu0505 — Tue, 28 Jul 2015 19:51:51 GMT

QVX_UNEXPECTED_END_OF_DATA

check this..

Re: LDAP - AD group data extraction issue

MarcoWedel — Tue, 28 Jul 2015 20:03:20 GMT

Hi,

maybe this helps:

Re: Active Directory load

http://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/

regards

Marco

topic Re: LDAP - AD group data extraction issue in QlikView

LDAP - AD group data extraction issue

Re: LDAP - AD group data extraction issue

Re: LDAP - AD group data extraction issue