LDAP limit 1000 records

[#1]

Hello @ all,

does anybody knows how I can get more than 1000 records by using an active directory (LDAP source)?

As I know this limit is used in all LDAP queries.

I have no access to the directory so if it is possible, I want to set a parameter.

Thanks

[#2]

hi

Use this query

First 1000 Load * from table name;

Regards

Ashish

[#3]

Wrong way. I don't want to limit the records I want to unlimit them because the LDAP returns only 1000 records.

Regards

[#4]

Your table contain only 1000 record that why load return only 1000

please count no of record in your table.

Regards

Ashish

[biester]

The reason is obviously the default AD settings, see http://support.microsoft.com/default.aspx?scid=kb;en-us;315071&sd=tech

If you don't have access to the AD, I wonder how you should set the desired parameters.
Perhaps you could try to export AD to csv with csvde (http://www.computerperformance.co.uk/Logon/Logon_CSVDE_switches.htm), but I'm afraid also with this you will have the limitation.

Rgds,
Joachim

[#6]

I couldn't change the settings in the AD, so I am looking for a parameter in the LDAP-statement.

The csv-download isn't a option for a periodical download.

Thanks anyway

[biester]

I can't test it here, but try adding e.g. PageSize=5000.

Rgds,
Joachim

[#8]

no success,

the datas are still limited to 1000 records

[biester]

OK, you obviously can't use PageSize in the connection string. So you have to query with a trick/loop (see examples http://qcstagingweb.typo3konsult.se/index.php?id=575&tx_mmforum_pi1%5Baction%5D=list_post&tx_mmforum...), or you do it as already suggested (also in the mentioned post) by reading AD with an external tool/program/script which you can also execute in the first line of the reload script, so I don't see why it should not be apt for a periodical download.

Rgds,
Joachim

[#10]

good idea

but......

I tried this

let

do

LOAD

SQL

'LDAP://AD-definition'

where

upper(left(samAccountName,1))=chr(64+$(x)) and memberOf

= AD-definition';

let

loop

but I didn't get a record. x=x+1; select name, samAccountName, mail, objectGUID, displayname, l from *, 'default' as Gruppe,upper(samAccountName) as %USERID ; while x<27 x=1;

Trying to set the where upper(left(samAccountName,1))=chr(64+$(x)) statement into the load-statement gives only 1000 records, too, because the sql-statement recieves only them.

Any idea abot the sql-statement?

Regards