Dsget bug for more than 1,000 members ? What else can I use.

  • Thread starter Thread starter Marlon Brown
  • Start date Start date
M

Marlon Brown

Hi there,

It seems dsget (Win2003)
dsget group DNGROUP| -members}]

is able to list members of small groups I have, but it returns nothing for
groups that has more than 1,000 people.

I've seen "ADFIND" tool by Joe Richards, but if anybody can show me which
command line I can use to accomplish the same that I would
with dsget -members, please let me know.
 
This works for me, modify size limit and page size

Set objConnection = CreateObject("ADODB.Connection") ' Create a Connection
object in memory
objConnection.Open "Provider=ADsDSOObject;" ' Open the Connection
object using the ADSI OLE DB provider

Set objCommand = CreateObject("ADODB.Command") 'Create an ADO Command
object in memory, and assign the Command _
objCommand.ActiveConnection = objConnection ' object's
ActiveConnection property to the Connection object

objCommand.Properties("Page Size") = 100
objCommand.Properties("Size Limit") = 3000 <--- Will change 1000 default
to 3000 records ++++++++++++++++

objCommand.CommandText = _blah, blah, blah, blah, blah

Set objRecordSet = objCommand.Execute
 
Are you saying that this is the script that can make dsget -member work with
up to 3,000 objects ?

Paul Bergson said:
This works for me, modify size limit and page size

Set objConnection = CreateObject("ADODB.Connection") ' Create a Connection
object in memory
objConnection.Open "Provider=ADsDSOObject;" ' Open the Connection
object using the ADSI OLE DB provider

Set objCommand = CreateObject("ADODB.Command") 'Create an ADO Command
object in memory, and assign the Command _
objCommand.ActiveConnection = objConnection ' object's
ActiveConnection property to the Connection object

objCommand.Properties("Page Size") = 100
objCommand.Properties("Size Limit") = 3000 <--- Will change 1000 default
to 3000 records ++++++++++++++++

objCommand.CommandText = _blah, blah, blah, blah, blah

Set objRecordSet = objCommand.Execute

--

Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA

This posting is provided "AS IS" with no warranties, and confers no rights.



Marlon Brown said:
Hi there,

It seems dsget (Win2003)
dsget group DNGROUP| -members}]

is able to list members of small groups I have, but it returns nothing for
groups that has more than 1,000 people.

I've seen "ADFIND" tool by Joe Richards, but if anybody can show me which
command line I can use to accomplish the same that I would
with dsget -members, please let me know.
Click to expand...
Click to expand...
 
I ran the one below and get error on line 3:
"Aguments are of the wrong type, are out of acceptble range, or are in
conflict with one another"

Maxpagesize in my environment is set to 10,000 (I tried to subsitute that
value in the script below, and it failed same way).

Set objCommand = CreateObject("ADODB.Command")
objCommand.ActiveConnection = objConnection

objCommand.Properties("Page Size") = 1000
objCommand.Properties("Size Limit") = 2000

Paul Bergson said:
This works for me, modify size limit and page size

Set objConnection = CreateObject("ADODB.Connection") ' Create a Connection
object in memory
objConnection.Open "Provider=ADsDSOObject;" ' Open the Connection
object using the ADSI OLE DB provider

Set objCommand = CreateObject("ADODB.Command") 'Create an ADO Command
object in memory, and assign the Command _
objCommand.ActiveConnection = objConnection ' object's
ActiveConnection property to the Connection object

objCommand.Properties("Page Size") = 100
objCommand.Properties("Size Limit") = 3000 <--- Will change 1000 default
to 3000 records ++++++++++++++++

objCommand.CommandText = _blah, blah, blah, blah, blah

Set objRecordSet = objCommand.Execute

--

Paul Bergson MCT, MCSE, MCSA, CNE, CNA, CCA

This posting is provided "AS IS" with no warranties, and confers no rights.



Marlon Brown said:
Hi there,

It seems dsget (Win2003)
dsget group DNGROUP| -members}]

is able to list members of small groups I have, but it returns nothing for
groups that has more than 1,000 people.

I've seen "ADFIND" tool by Joe Richards, but if anybody can show me which
command line I can use to accomplish the same that I would
with dsget -members, please let me know.
Click to expand...
Click to expand...
 
Hi there,

It seems dsget (Win2003)
dsget group DNGROUP| -members}]

is able to list members of small groups I have, but it returns nothing for
groups that has more than 1,000 people.

I've seen "ADFIND" tool by Joe Richards, but if anybody can show me which
command line I can use to accomplish the same that I would
with dsget -members, please let me know.
Click to expand...

Add the -LIMIT 0 to the end of the DSGET.

Also, see tip 7728 and links in the 'Tips & Tricks' at http://www.jsiinc.com

Jerold Schulman
Windows: General MVP
JSI, Inc.
http://www.jsiinc.com
 
I input -LIMIT 0 in the end of my valid and tested dsget command, and it
returns 'invalid command'.
I thought -LIMIT was related to dsquery...

Jerold Schulman said:
Hi there,

It seems dsget (Win2003)
dsget group DNGROUP| -members}]

is able to list members of small groups I have, but it returns nothing for
groups that has more than 1,000 people.

I've seen "ADFIND" tool by Joe Richards, but if anybody can show me which
command line I can use to accomplish the same that I would
with dsget -members, please let me know.
Click to expand...

Add the -LIMIT 0 to the end of the DSGET.

Also, see tip 7728 and links in the 'Tips & Tricks' at http://www.jsiinc.com

Jerold Schulman
Windows: General MVP
JSI, Inc.
http://www.jsiinc.com
Click to expand...
 
I can't understand what I am missing then. I run the valid command below:
C:\>dsget group -members "cn=mygroup,ou=student,ou=studentall
dc=it,dc=test,dc=com"

OK

Then I run

C:\>dsget group -members "cn=mygroup,ou=student,ou=studentall
dc=it,dc=test,dc=com" -limit 0

And I get:
dsget failed:`-limit' is an unknown parameter.

What am I missing ?



dsget failed:`-limit' is an unknown parameter.
Joe Richards said:
You can use the -limit command or use adfind which is on the free win32 tools
page of www.joeware.net

joe

--
Joe Richards Microsoft MVP Windows Server Directory Services
www.joeware.net



Marlon said:
Hi there,

It seems dsget (Win2003)
dsget group DNGROUP| -members}]

is able to list members of small groups I have, but it returns nothing for
groups that has more than 1,000 people.

I've seen "ADFIND" tool by Joe Richards, but if anybody can show me which
command line I can use to accomplish the same that I would
with dsget -members, please let me know.
Click to expand...
Click to expand...
 
Back
Top