Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
check this..
Hi,
maybe this helps:
http://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/
regards
Marco