Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - LDAP Group Query Results Limitation

Reply
 
Old 04-09-2009   #1 (permalink)
Bart Perrier


 
 

LDAP Group Query Results Limitation

I was unable to find my original post so I posted it again. I apologize if
it duplicates.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Is there a known limitation to the number of results you can return when
querying an AD group? Is it 1500?

Here is the request that I am making.

Set objGroup = GetObject _
' EVERYONE_GROUP is a constant
("LDAP://" & EVERYONE_GROUP)

objGroup.GetInfo

colEveryoneMembers = objGroup.GetEx("member")
l = 0
For Each strMember In colEveryoneMembers
ReDim Preserve arrEveryoneMembers(l)
arrEveryoneMembers(l) = strMember
l = l + 1
Next


Thanks.
Bart Perrier



My System SpecsSystem Spec
Old 04-09-2009   #2 (permalink)
Richard Mueller [MVP]


 
 

Re: LDAP Group Query Results Limitation

Bart Perrier wrote:

4C004B9E3DC2@xxxxxx...
Quote:

>I was unable to find my original post so I posted it again. I apologize if
>it duplicates.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Is there a known limitation to the number of results you can return when
> querying an AD group? Is it 1500?
>
> Here is the request that I am making.
>
> Set objGroup = GetObject _
> ' EVERYONE_GROUP is a constant
> ("LDAP://" & EVERYONE_GROUP)
>
> objGroup.GetInfo
>
> colEveryoneMembers = objGroup.GetEx("member")
> l = 0
> For Each strMember In colEveryoneMembers
> ReDim Preserve arrEveryoneMembers(l)
> arrEveryoneMembers(l) = strMember
> l = l + 1
> Next
>
Yes, the limit is 1500 (1000 in Windows 2000 Server). That is the maximum
number of values AD will return for a multi-valued attribute. The solution
is to use ADO Range limits. An example VBScript program using ADO range
limits is linked here:

http://www.rlmueller.net/DocumentLargeGroup.htm

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--


My System SpecsSystem Spec
Old 04-09-2009   #3 (permalink)
Bart Perrier


 
 

Re: LDAP Group Query Results Limitation


"Richard Mueller [MVP]" <rlmueller-nospam@xxxxxx> wrote in
message news:uqaRGJSuJHA.4928@xxxxxx
Quote:

> Bart Perrier wrote:
>
> 4C004B9E3DC2@xxxxxx...
Quote:

>>I was unable to find my original post so I posted it again. I apologize if
>>it duplicates.
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>
>> Is there a known limitation to the number of results you can return when
>> querying an AD group? Is it 1500?
>>
>> Here is the request that I am making.
>>
>> Set objGroup = GetObject _
>> ' EVERYONE_GROUP is a constant
>> ("LDAP://" & EVERYONE_GROUP)
>>
>> objGroup.GetInfo
>>
>> colEveryoneMembers = objGroup.GetEx("member")
>> l = 0
>> For Each strMember In colEveryoneMembers
>> ReDim Preserve arrEveryoneMembers(l)
>> arrEveryoneMembers(l) = strMember
>> l = l + 1
>> Next
>>
>
> Yes, the limit is 1500 (1000 in Windows 2000 Server). That is the maximum
> number of values AD will return for a multi-valued attribute. The solution
> is to use ADO Range limits. An example VBScript program using ADO range
> limits is linked here:
>
> http://www.rlmueller.net/DocumentLargeGroup.htm
>
> --
> Richard Mueller
> MVP Directory Services
> Hilltop Lab - http://www.rlmueller.net
> --
>
>
Thanks Richard. It's not the collection/array but the attribute itself. Very
interesting.

The good news is: I have enjoyed this script so much that I get to run it 4
times to complete my task!

Thanks again.

Bart

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
working LDAP query, well almost.. 800A000D VB Script
Query LDAP to get user Telephone VB Script
How can I query LDAP in WLM? Live Mail
Not all users are retrieved in an LDAP query via ASP VB Script
help with LDAP query PowerShell


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46