Question to Rob Wunderlich about extracting data AD

ingridmerx — Thu, 10 Aug 2017 07:50:36 GMT

Hello Rob,

I am having troubles with the script to extract data from the active directory (the famous QVX_UNEXPECTED_END_OF_DATA: error).

I think something is wrong with de content of the data and I am trying to find out what and where.

I am very new at scripting (and Qlikview). Could you explain to me what is achieved with Let arg=chr(01) (in your script below)?

CONNECT TO 'Provider=ADsDSOObject';

LET arg=chr(01);     // Set search start name to a very low value
DO
ADGroups:
LOAD
name as GroupName,
distinguishedName as GroupDN,
info as GroupInfo
;
SQL select
name, distinguishedName,
info
FROM 'LDAP://$(RootDse)' WHERE objectCategory='group'
AND name>'$(arg)';   // Get rows where "name" is GT the arg

EXIT DO WHEN ScriptError > 1   // Stop loop if SELECT has error
     EXIT DO WHEN NoOfRows('nameTable') = 0; // Stop loop if SELECT returns nothing
     EXIT DO WHEN peek('GroupName') = '$(arg)'; // If the last "name" read is EQ to arg -- no more entries

LET arg=peek('GroupName');     // Set the arg to the last "name" read
LOOP

Re: Question to Rob Wunderlich about extracting data AD

ingridmerx — Fri, 11 Aug 2017 06:37:42 GMT

Hello,

I solved it myself. The trouble with the script was the limit of 1000 records. I adjusted this to FIRST 901 as suggested in another post.

topic Question to Rob Wunderlich about extracting data AD in QlikView

Question to Rob Wunderlich about extracting data AD

Re: Question to Rob Wunderlich about extracting data AD