Extract all users from AD group and facing error when I extract when there are more than 1000 users.

kishore3k — Wed, 06 Apr 2022 16:44:18 GMT

Hi All,

I have issue extracting more than 1000 users from AD group with below error message.

Is there somewhere can we edit this parameter to change to 10000? I have more than 3300+ user at the moment and it will increase over time.

20220406T134808.948+0200 EQ_QVX_SIZELIMIT_EXCEEDED: The size limit for this request was exceeded.
20220406T134808.948+0200 This query was stopped because it tried to read beyond a restricted limit. One of the tables in the query has a limit of maximum 1000 rows.

I have attached sample code below . (Code is used from Qlikview Cookbook)

//AD Members Extract from Application and respective AD groups ApplicationGroup: LOAD distinct 'ONEVIEW' as "Application Name", 'APP-GLOBAL-OneView-NationalUsers' as ADGroup //Provide AD Group name AutoGenerate (1); LIB CONNECT TO 'LDAP_DSO'; SET RootDse = 'DC=domain, DC=com';//enter domain For i = 0 to NoOfRows('ApplicationGroup') - 1 LET vGroup = peek('ADGroup', $(i), 'ApplicationGroup'); LET vAppName= peek('Application Name', $(i), 'ApplicationGroup'); LET vDomain='DOMAIN'; Group: LOAD '$(vAppName)' as [App Name], upper(trim(name)) as GROUPNAME, distinguishedName as GroupDN, upper(trim(displayname)) as GroupDisplayName ; SQL select name, distinguishedName, displayname FROM 'LDAP://$(RootDse)' WHERE objectCategory='group' AND name='$(vGroup)'; NEXT i; For i = 0 to NoOfRows('Group') - 1 LET vUserGroup = peek('GroupDN', $(i), 'Group'); LET vAppName1=peek('App Name', $(i), 'Group'); LET vGroupDisplayName=peek('GroupDisplayName', $(i), 'Group'); GroupsMembers: LOAD // '$(vAppName1)' // &'-'&applymap('TeamMapping','$(vDomain)' & '\' &upper(TextBetween(distinguishedName,'=', ',')),'Users') // &'-'&'$(vDomain)' & '\' & upper(TextBetween(distinguishedName,'=', ',')) as Key, '$(vAppName1)' as [App Name], '$(vGroupDisplayName)' as GroupDisplayName, '$(vDomain)' & '\' & upper(TextBetween(distinguishedName,'=', ',')) AS NTNAME, '$(vDomain)' & '\' & upper(TextBetween(distinguishedName,'=', ',')) AS USERID, Capitalize(givenname) &' '&Capitalize(sn) AS UserFullName, distinguishedName as UserDN, '$(vUserGroup)' as GroupDN, co as Country, title as Title, mail as Email; SELECT distinguishedName, givenname, sn, co, title, mail FROM 'LDAP://$(RootDse)' WHERE objectCategory='person' AND MemberOf='$(vUserGroup)' ; Next i; drop table Group; exit script

topic Extract all users from AD group and facing error when I extract when there are more than 1000 users. in Connectivity & Data Prep

Extract all users from AD group and facing error when I extract when there are more than 1000 users.