SAPIEN Resources

Welcome to the ScriptVault, where ScriptingAnswers.com users share their administrative scripts.

Have you written a script that accomplishes some administrative task? Please share it! Just navigate to the appropriate category and click the "Contribute to this category" link!

You are here: Top > ActiveX Data Objects

Contribute to this category

Sub-Categories

(no categories are available)

Scripts

AD Last Login Contributed by James Vierra
Retrieves the last login time from all DCs in the default domain into a dictionary. Outputs dictionary as a sorted list. Output format can be easily modified for your needs. Contain trace capability so you can see what is happening. Uses ADO LDAP, Scripting Dictionary and sorted array. Can be used as template for bigger projects
Add User Demo Contributed by Jeffery Hicks
You can get the demo Excel spreadsheet at http://www.jdhitsolutions.com/scripts.htm
Add Users from Access Database Contributed by Don Jones
Uses a database to provide usernames and descriptions; creates either local or domain users. Modify to specify additional user properties when creating users.
Convert CSV to XML Contributed by Jeff Hicks
Notes: You will be prompted to find the CSV file to convert and a name of an xml file to create. This script requires Windows XP. The script assumes the first line of the csv file is for headings. Using ADODB, the script parses out the headings and creates an tag for each line of the csv file. Within each tag are child tags for each heading. If no value is found for a heading in a particular line, then the XML text for that heading is set to '.'. Otherwise, the tag doesn't get closed properly. The OpenFile dialog box doesn't have a csv filter, but if you type in *.csv and click Open, the dialog box will refresh And present a filtered view. Keywords: XML,ADODB,CSV,FileSystemObject,XMLDOM
Get Users Demo Contributed by Jeffery Hicks
You can get the sample Excel spreadsheet from http://www.jdhitsolutions.com/scripts.htm
GetOSInfo.vbs Contributed by Jeffery Hicks
This script will update an Access database. You can get the database from http://www.jdhitsolutions.com/scriptts.htm.
Query MDB Contributed by Jeffery Hicks
You can get an empty mdb file to play with from http://www.jdhitsolutions.com/scripts.htm
Service Pack Inventory - SQL Server Contributed by Don Jones
A good example of how databases are used in script.

Expects: A SQL Server named Server1 (which you can change), containing a database named Databs (which you can change), which contains a table named Data. Data should contain columns named Client and ServicePack; populate Client with computer names and the script will fill in the service pack version for each.

Compare to the Access-based version of the script (under Computer Management category) to see how few changes you need to make to your scripts when switching database engines.
Update DB Contributed by Jeffery Hicks
You can get the Access DB from from http://www.jdhitsolutions.com/scripts.htm. You will have to populate it with computernames before you try to run this.

AD Last Login	Contributed by James Vierra Retrieves the last login time from all DCs in the default domain into a dictionary. Outputs dictionary as a sorted list. Output format can be easily modified for your needs. Contain trace capability so you can see what is happening. Uses ADO LDAP, Scripting Dictionary and sorted array. Can be used as template for bigger projects
Add User Demo	Contributed by Jeffery Hicks You can get the demo Excel spreadsheet at http://www.jdhitsolutions.com/scripts.htm
Add Users from Access Database	Contributed by Don Jones Uses a database to provide usernames and descriptions; creates either local or domain users. Modify to specify additional user properties when creating users.
Convert CSV to XML	Contributed by Jeff Hicks Notes: You will be prompted to find the CSV file to convert and a name of an xml file to create. This script requires Windows XP. The script assumes the first line of the csv file is for headings. Using ADODB, the script parses out the headings and creates an tag for each line of the csv file. Within each tag are child tags for each heading. If no value is found for a heading in a particular line, then the XML text for that heading is set to '.'. Otherwise, the tag doesn't get closed properly. The OpenFile dialog box doesn't have a csv filter, but if you type in *.csv and click Open, the dialog box will refresh And present a filtered view. Keywords: XML,ADODB,CSV,FileSystemObject,XMLDOM
Get Users Demo	Contributed by Jeffery Hicks You can get the sample Excel spreadsheet from http://www.jdhitsolutions.com/scripts.htm
GetOSInfo.vbs	Contributed by Jeffery Hicks This script will update an Access database. You can get the database from http://www.jdhitsolutions.com/scriptts.htm.
Query MDB	Contributed by Jeffery Hicks You can get an empty mdb file to play with from http://www.jdhitsolutions.com/scripts.htm
Service Pack Inventory - SQL Server	Contributed by Don Jones A good example of how databases are used in script. Expects: A SQL Server named Server1 (which you can change), containing a database named Databs (which you can change), which contains a table named Data. Data should contain columns named Client and ServicePack; populate Client with computer names and the script will fill in the service pack version for each. Compare to the Access-based version of the script (under Computer Management category) to see how few changes you need to make to your scripts when switching database engines.
Update DB	Contributed by Jeffery Hicks You can get the Access DB from from http://www.jdhitsolutions.com/scripts.htm. You will have to populate it with computernames before you try to run this.