Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Question to Rob Wunderlich about extracting data AD

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

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Re: Question to Rob Wunderlich about extracting data AD

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.

View solution in original post

1 Reply
Highlighted
Contributor III
Contributor III

Re: Question to Rob Wunderlich about extracting data AD

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.

View solution in original post