Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Windows Server 2003 User Account Query

Status
Not open for further replies.

Currivan

MIS
May 12, 2004
25
US
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!
 
I've never heard of such a limitation. Is a limitation of the script or the CSV file? If the CSV, then I would suggest dumping your results into a SQL database.

I hope you find this post helpful. Please let me know if it was.

Regards,

Mark
 
Apparently, the limitation is in the script command that opens the database. (My goal is to get a properly formatted resultant file in one simple step.) Look in the VBScript forum for the same thread name. tsuji had an interesting approach to resolving the issue by setting the page size property. Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top