Windows Server 2003 User Account Query 1

[Currivan]

I have written a VB script to query the server database for user account information to be output into a CSV file. It works fine, except for one hitch: the output is limited to only 1000 records, exactly, of which I have some 5,800+ in one OU. How can I code the script to overcome such limitation to get a full listing of the OU in question. Your help on this matter will be greatly appreciated!

 

[tsuji]

Hello Currivan,

Could you not use the adocommand object and set the page size property?
[tt] adocommand.properties("page size")=8000[/tt]
And open the record set with
[tt] adorecordset.open adocommand, adoconnection[/tt]
or those many variations to get the same thing done.

regards - tsuji

 

[RabidDawg]

I'm not sure if this will help you out, but we use the csvde utility that is on Win2k server, I would think it would be on 2003 server too. We output our entire domain, about 6000 users, and it does it very quickly, alot quicker than what I was trying to do in VB.

 

[Currivan]

Thanks tsuji! That's the kind of information I was looking for. You really came through! I'll be giving it a try as soon as I can. As for RabidDawg, I appreciate the input, you're right about 2003; however, if I'm not mistaken, I chose not to use CSVDE because there was a lack of an ability to format the information the way I need it to be for my program. I'll have to look at that again, the output has to be in a final format, not raw data. Thanks.