|
I use this script to track hard disk usage on the servers that I administer.
|
|
This script connects to all the logical disks on a computer, gathers information from the DeviceID and FreeSpace properties, and then writes that information to a text file. The
|
|
This script sends an email whenever your drives fall below a certain size (measured in megabytes). In this case, I get an alert email whenever my servers have less than 300MB. Use
|
|
The script determines the first available drive letter on a computer.
|
|
Given a list of computers, this script alerts you when free disk space falls below a specified limit.
|
|
Tests letters E-Z (skipping common floppy, system and CD-ROM drive letters) to see if a drive is mapped to that letter. If not, the script sets a variable, MapLtr, to the availab
|
|
Finds the hard disk drives on a system and runs the command line tool Defrag.exe on each drive. Should be run as a scheduled task each night to keep the drives defragmented
|
|
Defragments all local hard disks.
|
|
Retrieves available drive space information from a set of computers and -- if available space is less than 80 gigabytes -- writes the information to an Excel spreadsheet. As writt
|
|
Script that defragments the hard drives on a computer. The script captures errors and saves its output to a text file.
|
|
Reports free drive space (in percentages and in gigabytes) of all the drives on a computer.
|
|
Checks the event logs for disk errors that have occurred within the past week. The script outputs the results to an Excel spreadsheet as well as emailing those results.
|
|
Displays the amount of disk used on a user's home drive.
|
|
Defragments the hard drives on a Windows Server 2003 computer.
|
|
Verifies the existence of a drive.
|
|
Retrieves disk information from a computer and stores that data in a database. Useful for historical reporting.
|
|
Defragments all local hard drives using the Defrag.exe command-line utility included with Windows Server 2003.
|
|
Identifies the currently logged-on user and then retrieves information about the user's mapped drives from the registry.
|
|
Displays disk usage (the used, free and total space) for all fixed disks on a computer.
|
|
Retrieves disk information for a computer and then logs that information into an Excel spreadsheet.
|
|
Determines the free disk space on a computer, and sends an email notification if disk space is low.
|
|
Creates a Microsoft Access database.
|
|
Lists all the tables (both system- and user-created) in an Access database.
|
|
Sample script demonstrating how to insert a row into Microsoft Access table.
|
|
Counts the number of rows in a table in a Microsoft Access database.
|
|
Uses the SQL ALTER TABLE statement to add a column to a Microsoft Access table.
|
|
Sample script showing how to update a row in a Microsoft Access table.
|
|
Allows you to compact and repair a Microsoft Access database; a backup of the database is also made in the event of an error. Change the objAccess to match the Access version you
|
|
Uses the SQL ALTER TABLE statement to add a column to a Microsoft Access table.
|
|
Exports an Access report to a snapshot file. Includes constant values for other file formats.
|
|
Prints a Microsoft Access report to the default printer.
|
|
Adds an index to a Microsoft Access table.
|
|
Uses the GetRows method to copy a Microsoft Access recordset into a two-dimensional array.
|
|
Sample script that retrieves a Microsoft Access Recordset and then assigns that recordset to a string variable.
|
|
Saves an Access Recordset as an XML file.
|
|
Selects the top N items from a Microsoft Access table.
|
|
Finds a record (with an Index equal to DeviceIDIndex) in a Microsoft Access recordset.
|
|
Uses the Clone method to make a duplicate of a Microsoft Access recordset.
|
|
Performs an inner join on tables from two Access databases.
|
|
Imports a spreadsheet into an Access database, creating a new table in the database.
|
|
Performs a union query in Microsoft Access using the database tables Hardware and Hardware_Copy.
|
|
Performs a Where In query to select Microsoft access records meeting one of three possible criteria.
|
|
Creates a stored procedure named ChangeDate in a Microsoft Access database.
|
|
Adds a view named AllHardware to an Access database.
|
|
Sample script demonstrating how to use ADO to retrieve data from a SQL Server database.
|
|
Sample script that demonstrates the use of the CompareBookmarks method in an ADO database script.
|
|
Uses Windows PowerShell and ADO.NET to add a record to a database.
|
|
Displays field and value properties for a table in an ADO database.
|
|
Uses the GetRows method to retrieve a specified number of rows from a recordset, then stores that information in an array.
|
|
Sample script that loads the new server with users across all of the storage groups/databases on the new server (round robin).
|
|
Reads and prints an NT Backup log.
|
|
Performs a complete computer backup.
|
|
Copies files that are new or changed from a folder (and its subfolders) to a backup folder.
|
|
Automates a system state backup of a desktop/server and prompts you as to where you would like the backup file stored. I utilize this script in my server environment for DR purpos
|
|
VBScript script to extract Error and Warning level messages from a Backup Exec log.
|
|
Perl script to extract Error and Warning messages from a Backup Exec log file.
|
|
Runs NTBackup and overwrites an existing backup tape.
|
|
Performs a system state backup. This is useful for getting a flat file backup of a domain controller.
|
|
Runs NTBackup and appends the data to an existing backup tape. Requires Sleep.exe.
|
|
Creates a backup settings file.
|
|
Performs a system state backup on all the computers in an OU.
|
|
Deletes backup files and then runs the specified type of backup.
|
|
Backs up files using Windows PowerShell.
|
|
Ejects tape media based on the media name.
|
|
Modifies event log registry keys that control AutoBackupLogFiles.
|
|
Backs up system state on a computer. This script can be easily scheduled to run nightly typing the following command at the command line: at TIME /every:m,t,w,th,f,s,su Script Fil
|
|
Queries backup logs on a remote server, compiling the total number of bytes that were written to a specified backup tape.
|
|
Identifies the CPU type on a computer.
|
|
Simple script that queries a computer for BIOS information. Useful when you call the support desk and they want the computer's serial number and BIOS version.
|
|
Uses WMI to query a remote server for its serial number.
|
|
Resets the chassis intrusion on a Dell computer. Requires the Dell OMCI (Open Manage Client Instrumentation) WMI provider.
|
|
Uses WMI to retrieve the DeviceID and Name for the Win32_Battery object from a local or remote laptop computer.
|
|
Modifies power options so that a laptop computer takes no action when the lid is closed.
|
|
Takes an MSCS resource offline or brings it back online.
|
|
Moves cluster resources between cluster nodes. "Drain" moves all resources off a cluster node so maintenance can be performed. "Balance" moves resources back to their preferred o
|
|
Returns a list of your installed software.
|
|
Script for getting installed software infomation and storing that information in a text file named C:\Software.txt.
|
|
Lists installed software using the registry key HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall.
|
|
Retrieves software information from the registry, regardless of where that information is stored in the registry (XP 64 bit saves this data in two different places). The script ca
|
|
Script that lists the software installed on a computer. Credit to Bill James for providing the functions in this script.
|
|
Inventories installed software for every computer listed in the text file Servers.txt. The script also creates a text file for each computer it inventories.
|
|
Displays version, definition dates, product version, and virus definition version for McAfee VirusScan. Known to work on 7.1 Enterprise and 8.0 Enterprise.
|
|
Queries the registry for installed applications on either 32-bit or 64-bit Windows XP and Windows 2003. Information is output to a .txt file, using a ¿ as a delimiter for easy imp
|
|
Finds and lists the 8.3 file path for the most-recently installed version of Microsoft Office on a computer.
|
|
Searches for specified software and appends to a CSV file the file names and file versions that it finds. I use Excel macros to process the CSV files, filter old data and generate
|
|
Installs the Java Runtime and Windows XP Service Pack 2 on a computer.
|
|
Reports any changes to the Uninstall Key in the Registry. If a Program is added or Removed. The script exports the Uninstall key and then waits for a change. Once a change occu
|
|
Uninstalls an application on a remote computer.
|
|
Lists software installed on the local computer.
|
|
Uninstalls WinZip.exe without the need for user intervention.
|
|
Retrieves a list of software installed on domain computers and then writes that information to an Excel spreadsheet.
|
|
Lists installed applications in a Microsoft Excel spreadsheet.
|
|
Connects to all the computers in a domain and queries the Application event log for event ID 301, which indicates successful software installations via Group Policy.
|
|
Lists software installed on the specified computer.
|
|
Retrieves information about the software installed on a computer and then saves that information to a text file.
|
|
Uses PSExec to deploy software to remote computers. The HTA requires a batch file similar to this, along with an Excel spreadsheet listing software that can be removed:
|
|
This two-line script runs the IPCONFIG /ALL command.
|
|
Successively pings all interfaces between the local area network and the Internet; also checks connectivity with the gateway, primary and secondary DNS servers, and a known good I
|
|
This file gathers network information about the computer it is run on. This includes such information as hostname, network adapters, and active network connections.
|
|
For frequent travelers who move from in-house to hotel Internet connections and back. Place in C:\ root directory and put a shortcut on your desktop.
|
|
Lists network information for a computer.
|
|
Reads a list of target machines and updates their WINS settings.
|
|
Lists the primary and secondary DNS server entries for a computer.
|
|
Lists network adapter information for a computer.
|
|
Gathers network interface information and stores it in a text file.
|
|
Reports back the IP address on a computer. This script can be placed on the desktop, enabling users to easily determine their IP address.
|
|
Changes the primary and secondary DNS servers on a set of computers.
|
|
Lists the subnet your computer is in.
|
|
Queries the user for a computer name, then returns network configuration information.
|
|
Repairs network connections.
|
|
Uses Netstat.exe to gather network statistics and save them to a log file.
|
|
Retrieves network adapter information and MAC address for a computer.
|
|
Sets or changes the DNS Server of the named Ethernet connection (for example, Local Area Connection). Script can be run using PSTools PSEXEC ("\psexec.exe @DNSServers.txt -c -s c
|
|
Resets TCP/IP settings using Netsh.exe, similar to doing a Repair on a network connection.
|
|
Gathers network configuration information and saves it to a text file.
|
|
Retrieves the MAC address for a computer.
|
|
Lists Information Returned by Ipconfig.exe.
|
|
Lists Ipconfig.exe information for a computer.
|
|
Releases and renews your computer's IP address.
|
|
Configures the Local Area Connection to use DHCP.
|
|
Lists current DNS serves on a set of computers and, upon confirmation, changes those settings.
|
|
Disables any wireless network cards and then sends an email notification.
|
|
Modifies the DNS servers assigned to client machines.
|
|
Opens the HOSTS file on a specified computer.
|
|
Modifies TCP/IP settings for a network adapter.
|
|
Sample function that takes an IP address and returns the next address in the sequence.
|
|
Sets a static IP address, subnet mask, default gateway and, optionally, a default DNS server for a specified network connection.
|
|
Enables DHCP and assign DNS servers to a computer.
|
|
Looks up a computer in a database and assigns that computer the specified IP address.
|
|
Copies a master host file to all the computers listed in a file named Computers.txt. A master host file must exist in the directory you are running this script from.
|
|
Configures all the settings typically required to enable DHCP on a computer.
|
|
Modifies TCP/IP settings for the first IP-enabled network card in the network adapter binding order.
|
|
Enables a computer to use either DHCP or a static IP address.
|
|
HTA that quizzes you on subnetting and subnet configurations.
|
|
Changes IP addresses for all the computers on a subnet.
|
|
Pings and traces network devices.
|
|
Verify that a computer is connected to the network and, if it is, return various properties.
|
|
Retrieves and displays network configuration settings for a remote server.
|
|
Moves multiple Virtual Machines to a new subnet by changing the static IP address of each machine. There are actually two scripts here: Salmon.vbs and Spawn.vbs. Salmon.vbs reads
|
|
Removes a pair of printers.
|
|
Prints a PDF file to the specified printer.
|
|
Deletes all the print jobs on the local computer.
|
|
Displays the Name and Synopsis for all Windows PowerShell cmdlets. The output is in Excel format.
|
|
Uses Makecab.exe to store the contents of a folder in a CAB file.
|
|
Lists all the computer accounts in a specified OU.
|
|
Moves a computer to a new container in Active Directory. This script is the answer to a recurring problem with students computers being added to the wrong location.
|
|
Lists all computer objects contained within an OU. You can modify the script to perform an action against the computers, if needed.
|
|
Lists the current domain.
|
|
Retrieves the ADsPath of the specified computer.
|
|
Retrieves computer accounts from an OU and adds those accounts to a disconnected recordset.
|
|
Lists all the domain controllers in current domain.
|
|
Lists all Active Directory FSMO role holders.
|
|
Lists computer accounts in Active Directory.
|
|
Lists computers that have not had their passwords changed in last 60 days.
|
|
Creates a disconnected dataset that holds the names of all the computers in an OU or set of OUs (just add more OUs to the array). A disconnected recordset is easier to sort than a
|
|
Lists Active Directory computer accounts. Useful for populating lists for software deployment, patch deployment, etc.
|
|
Lists the free drive space on domain controllers.
|
|
Uses a pair of text files to select and update computer descriptions.
|
|
Finds inactive computer accounts and moves them to a specified OU.
|
|
Disables computer accounts that have not been used in the past 60 days, and deletes computer accounts that have not been used in the past 90 days.
|
|
Uses information stored in a Microsoft Excel spreadsheet to create a series of Active Directory computer accounts.
|
|
Lists, creates, and deletes Active Directory objects such as Organizational Units and computer accounts. Type the LDAP query in the first text box; for example, OU=HR,DC=Hello,DC=
|
|
Reads in computer names from a text file and then disables each of the corresponding computer accounts.
|
|
Retrieves a list of all the computers in an OU and writes the computer names to a text file.
|
|
Retrieves the value of the dnsHostName attribute for the local computer.
|
|
Lists all the computers in Active Directory and the date and time their passwords were last changed.
|
|
Moves all the computers listed in a text file to a new OU. The script also creates and/or updates a log file with the original distinguished name of each computer.
|
|
Remaps user drive mappings from \\server\sharename to \\root\dfspath\sharename.
|
|
Searches for orphaned DFS Links and writes results to a log file. Syntax: cscript.exe checkdfs.vbs \\DFSROOT$ c:\temp\dfs_log.txt
|
|
Retrieves Active Directory configuration information and saves the data to a text file.
|
|
Displays Active Directory naming contexts.
|
|
Displays Active Directory Application Directory Partitions.
|
|
Uses a series of Dsquery commands to determine the FSMO role holders for a domain.
|
|
Checks the health of your Active Directory and exports the results to a text file. You should run the script from a domain controller that has the Windows Support Tools installed.
|
|
Checks trust relationships and trust status for a domain.
|
|
Uses ADODB.Stream to download a file from the Internet and save it to the local hard drive.
|
|
Downloads a .csv file from the NASDAQ Web site and parses it to get the ticker symbols. After the script finds each symbol it then requests the current quote from Yahoo Finance a
|
|
Downloads a program from a We site and then executes that program with or without user intervention. I usually use Windows Script Encoder before I send this to any of my customers
|
|
Queries backup logs on a remote server, compiling the total number of bytes that were written to a specified backup tape.
|
|
Retrieves information from an Excel spreadsheet and then echoes that data to the screen.
|
|
Starts a new instance of Excel, but only if Excel is not already running. Avoids multiple instances of Excel from running.
|
|
Exports Microsoft Access tables to a Microsoft Excel spreadsheet.
|
|
VBA macro that searches a spreadsheet by rows and by values.
|
|
Uses ActiveX Data Objects (ADO) to query an Excel workbook.
|
|
Programmatically adds a macro module and associated VBA code to an existing Excel spreadsheet.
|
|
Uses SQL commands to query an Excel workbook.
|
|
Verifies that an Excel worksheet exists.
|
|
Verifies that a worksheet exists in a Microsoft Excel spreadsheet.
|
|
Converts a tilde-delimited file to a format that can be directly opened by Microsoft Excel.
|
|
Copies a worksheet from an existing .XLS file to a new spreadsheet.
|
|
Formats a range in a Microsoft Excel spreadsheet so that numbers in that range are displayed using 3 leading zeroes.
|
|
Saves an Excel spreadsheet as both a .XLS and .HTM file.
|
|
Creates a custom date format (YYYYMMDD) in an Excel spreadsheet.
|
|
Copies a worksheet from an existing spreadsheet to a new spreadsheet.
|
|
Parses a text file and writes the data to a Microsoft Excel spreadsheet.
|
|
Prevents the Microsoft Excel window from updating during execution of a script.
|
|
Lists all the worksheets found in the file C:\Scripts\Test.xls.
|
|
Centers the text in a spreadsheet cell.
|
|
Inserts a column into a worksheet.
|
|
Puts the current date, current time, and the current page and total pages into an Excel spreadsheet.
|
|
Opens an existing Excel spreadsheet, makes some changes, and then re-saves the file.
|
|
Adds new worksheets to an Excel workbook.
|
|
Writes data to a cell in a Microsoft Excel spreadsheet.
|
|
Adds data to a spreadsheet, then changes the font size, style, and color of that data.
|
|
Auto-sizes columns in a Microsoft Excel spreadsheet.
|
|
Lists Microsoft Excel colors and their corresponding integer values.
|
|
Opens the existing Excel spreadsheet C:\Scripts\New_users.xls.
|
|
Opens and reads the spreadsheet C:\Scripts\New_users.cls, then echoes back the data.
|
|
Adds a comment to different cells in an Excel spreadsheet.
|
|
Copies data from a column in an Excel spreadsheet and puts that data into an array.
|
|
Copies column C from one worksheet to column A of a second worksheet.
|
|
Compares a list of names found in column B of a spreadsheet to a list of names found in column A. For each name in column B the script reports back whether or not the name appears
|
|
Collects data from an Excel spreadsheet and then saves that data to a text file.
|
|
Sorts all the worksheets in an Excel spreadsheet by name.
|
|
Determines the last row in a spreadsheet and then adds data to the next available row.
|
|
Changes the font color of a cell based on the value of that cell.
|
|
Assigns values to cells based on background color, and then sums these assigned values.
|
|
Saves an Excel spreadsheet as an XML file.
|
|
Changes the background color of a cell in an Excel spreadsheet.
|
|
Adds a COUNTIF formula to column A in an Excel spreadsheet.
|
|
Conditionally changes the background color of a cell in an Excel spreadsheet based on the date-time value entered in that cell.
|
|
Renames Sheet 2 in an Excel spreadsheet to March 2005 Inventory Report.
|
|
Sorts worksheet data on column A.
|
|
Configures word-wrapping for a worksheet cell.
|
|
Adds data to an Excel spreadsheet and then creates a line chart based on that data.
|
|
Adds data to an Excel spreadsheet and then creates a pie chart based on that data.
|
|
Changes the background color of a spreadsheet row if a date appears in a specified cell in that row.
|
|
Uses Microsoft Excel to search all the files in a folder for a specified text string.
|
|
Uses Microsoft Excel to search for all the .sys files in a specified folder.
|
|
Appends data to an Excel spreadsheet.
|
|
Creates a spreadsheet and then places borders around specified cells.
|
|
Creates a calendar by using Microsoft Excel's AutoFill capability.
|
|
Creates and then saves a chart using Microsoft Excel.
|
|
Creates and then formats a basic column chart in Microsoft Excel.
|
|
Creates a basic column chart using Microsoft Excel.
|
|
Colors ever other row in an Excel spreadsheet. Rows alternate in color between a light blue and a light yellow.
|
|
Formats cells in a spreadsheet to display three decimal places.
|
|
Deletes any row in a spreadsheet where the word delete appears in column A.
|
|
Copies specified columns from a coma-separated values file to an Excel spreadsheet.
|
|
Makes the first character in a spreadsheet cell uppercase and any subsequent characters in that cell lowercase.
|
|
Adds a password (%reTG54w) to a Microsoft Excel spreadsheet.
|
|
Imports a fixed-width text file (C:\Scripts\Test01.txt) into a Microsoft Excel spreadsheet.
|
|
Saves a worksheet as a comma-separated values file named C:\Scripts\Test.csv.
|
|
Creates a new spreadsheet featuring a file name based on the current date. Designed to be run each night as a scheduled task.
|
|
Checks to see if the workbook Inventory.xls is open. If it is not, the script then opens that workbook.
|
|
Sorts data in a Microsoft Excel spreadsheet.
|
|
Inserts blank rows in spreadsheets in order to group data by person.
|
|
Sets the print area in a Microsoft Excel spreadsheet.
|
|
Adds a hyperlink to a Microsoft Excel spreadsheet.
|
|
Parses comma-separated values in a spreadsheet column into multiple columns (for example, the value Olympia, WA becomes two separate values: Olympia and WA).
|
|
Configures to default file path in Microsoft Excel so that it points to the user's home directory.
|
|
Removes the password when opening an Excel spreadsheet. You must know (and supply) the correct password for this script to work.
|
|
Adds a total row to the bottom of an Excel worksheet.
|
|
Replaces a specified text string within an Excel spreadsheet.
|
|
Copies a worksheet from one location to another.
|
|
Copies data from one Excel spreadsheet to another.
|
|
Deletes every other row in a Microsoft Excel worksheet.
|
|
Adds a background picture to a Microsoft Excel worksheet.
|
|
Opens all the spreadsheets in a folder and runs a macro found in each of those spreadsheets.
|
|
Opens an Excel spreadsheet, updates all the Excel type links, and then breaks each of those links.
|
|
Adds a scenario name Typical to a worksheet.
|
|
Retrieves the sender email address for all the messages in Outlook's Sent Items folder, and then writes those addresses to an Excel spreadsheet.
|
|
Writes the contents of an array into a range of spreadsheet cells.
|
|
Selects all the formula cells found in the used range of a worksheet.
|
|
Imports a text file into Excel even if the number of lines in that file exceeds Excel's total number of rows limitation.
|
|
Adds a validation rule to a Microsoft Excel worksheet.
|
|
Sets the center header of every worksheet in a workbook to the worksheet name.
|
|
Deletes all files in the system and user TEMP folders.
|
|
Purges old files from a specified folder based upon the modification date of those files. All files older than a specified number of days will be deleted.
|
|
Renames all files in a folder to a specified prefix plus a sequential number. This is very handy after obtaining pre-named images from a digital camera.
|
|
This script deletes files (for example IIS log files) older than specific number of days. The number of days is contained in a variable named intOlderThan, and the default value i
|
|
Delete disposable log files that you don't need to keep after a specified number of days. The script also generates an email with a list of them. You might want to periodically ru
|
|
Renames a file, prepending a customized date to the name. The customized date can include the month, day, year, quarter, day of week, hours, minutes, seconds, or week of year. Ru
|
|
This script deletes all the files of a specified directory and emails a list of the deleted files. Run it as a sScheduled Task to periodically clean up folders from applocationss
|
|
I schedule this script to run just before I come in each morning.When I arrive an Excel spreadsheet is open on my desktop and I can quickly review disk backup across a range of se
|
|
Renames any file passed as a command-line argument to ~YYYYMMDDhhmmss.ext, where the file extension (.ext) is retained from the original file name. Good for archiving log files.
|
|
Here is a simple script that scans a directory for files older then 7 days and then removes them.
|
|
This scripts allows you to retrieve the file names within a specified folder. I use this with an automated FTP task and DTS to generate parameter files dynamically.
|
|
Checks the version of a particular .DLL or other file across a range of servers. In this case I'm searching for Ntfrs.exe, but you can change that as needed.
|
|
This script contains a function that compares the version numbers of two different files and determines which version is newer. The script returns 0 if the file versions are the s
|
|
Searches all of the directories in your PATH statement for a file.
|
|
Moves files from a floppy disk to a specified location. If you have libraries of floppy diskettes, this is the quickest and easier way to get them to a network share.
|
|
Deletes all files in a folder that are older than 7 days.
|
|
Deletes files that are older than the number of days specified by the variable RetentionPeriod.
|
|
Searches a set of computers for files with a specified extension.
|
|
Deletes files 10 days old or older.
|
|
Lists all files of a specified file extension found in a selected folder and its subfolders.
|
|
Retrieves a list of files using the same format and wildcards as the DIR command. Run the script in the same fashion you would the DIR command; for example, cscript dir.vbs c:\fil
|
|
Copies all the files in the source directory to the location directory. To perform this task automatically, save the file as a .bat file and then add it to the Task Scheduler. Si
|
|
Checks the timestamp of files in any directory on the default drive (PestPatrol's quarantine directory, in this example) and deletes those files if they were last modified more th
|
|
Copies a file name and path to the clipboard. This script should reside in the user's SendTo folder under documents and settings, and requires JSSys3.dll.from www.jsware.net.
|
|
A vastly improved version of "Save File Statistics for a Folder," which I submitted the week the Community-Submitted Scripts Center opened for business back when dinosaurs roamed
|
|
Reports any files in a specified folder that are Older than 10 minutes.
|
|
Deletes all the files in a folder that have not been modified in the last 90 days.
|
|
Deletes old log files from log folders
|
|
Copies all the files from drive X to drive Z. If the script finds the same file on the destination, it will only that file only if the source file is newer. The script will also c
|
|
Monitors a specified Excel spreadsheet and, when the file is changed, opens the spreadsheet and displays an updated chart.
|
|
Copies files to the logged-on user's desktop folder.
|
|
Emails log files recorded on the previous day.
|
|
Filters the output of a RoboCopy operation so that only the items which are different are echoed to the screen. This is handy when you want to synchronize lots of files and need t
|
|
Changes the archive attribute for all the files in a directory. Syntax: change.vbs /P:[directory] /d:true/false [display on script] /a:(n) [number of days to evaluate from today].
|
|
Lists the five most-recently modified files in a folder.
|
|
Deletes files older than 14 days. To specify a different time interval, change the value of the variable RetentionPeriod.
|
|
Summarizes information found in RoboCopy log files.
|
|
Uses Robocopy.exe to copy the contents of a folder and its access permissions to another location.
|
|
Copies a file from one remote computer to another remote computer.
|
|
Lists the executable files found in the system path. The retrieved information is written to a text file named ExecutablesList.txt, which is stored in the user's Desktop folder.
|
|
Sends a file to the Recycle Bin instead of permanently deleting that file.
|
|
Enumerates folders and find the largest file in each of those folders.
|
|
Copies files from Recycle Bin folder even if those files do not appear in Windows Explorer because of a damaged INFO2 file.
|
|
Verifies the existence of a file on a remote computer.
|
|
Uses Windows PowerShell to determine whether the file C:\Scripts\Heysguy.exe exists.
|
|
Uses Windows PowerShell to list the files in a folder.
|
|
Uses Windows PowerShell to count the number of files in a folder.
|
|
Copies a file using Windows PowerShell.
|
|
Checks for .ERR files in a specified folder.
|
|
Deletes files of a specified type (based on file extension) from a directory until free disk space rises above a pre-determined number of bytes. Files are deleted in chronological
|
|
Incrementally deletes the oldest files in a folder until a specified amount of free disk space has been reached.
|
|
Deletes all the files with a specified file extension from a folder and its subfolders.
|
|
Adds summary information to a file. A modified version of the DLL can be found at http://jeolmeun.googlepages.com/dsofile_dll.zip For more information pleas see http://jeolmeun.b
|
|
Adds additional capabilities found in the DIR command to the Get-ChildItem cmdlet.
|
|
Removes non-English file characters from the names of all the files in a specified folder.
|
|
Lists the unique file extensions found in a specified folder.
|
|
Removes commas that appear within double quotation marks in a CSV file.
|
|
Searches the computer for files with the name plock.exe and displays path and version of the files.
|
|
Enumerate folders and folder sizes.
|
|
This script takes the specified folder and lists its contents (including file sizes) in Microsoft Excel. The script is useful for creating listings and for rapidly locating large
|
|
This script will create a set of folders based on folder names listed in the first column of an Excel spreadsheet.
|
|
This script creates a folder in the current directory.
|
|
Two-part command shell script that emulates the output of the Unix du command. You must copy the code for sizeof.cmd and dirsize.cmd into two files with those names, and both file
|
|
Copies a folder to a new location.
|
|
Creates archive folders for script output: 2006/January/results01.txt etc. The script creates new folders for the month and year as needed. Nice for housekeeping tasks use it as a
|
|
Deletes all the content of a specified folder, including all files and subfolders. Designed for administrators who wants to clean out a shared folder.
|
|
Deletes all the subfolders in a given folder.
|
|
Retrieves the size of a folder, writes the information to a file, then emails that file.
|
|
Deletes the oldest subfolder in a folder. Must be run from within the parent folder.
|
|
Writes folder contents to text file.
|
|
Lists the largest and smallest files as well as the average file size for the subfolders of a specified folder. The log file used in the script must exist before the script is run
|
|
Lists access permissions for a folder and its subfolders.
|
|
Lists folders and subfolders for a drive or network drive.
|
|
Windows PowerShell script that deletes all the subfolders in a specified folder.
|
|
Verifies the existence of a folder.
|
|
Copies a folder from one computer to another. The script requires the Resource Kit’s Robocopy tool.
|
|
Takes folder names listed in a text file and deletes all the subfolders older than 10 days.
|
|
Uses Windows PowerShell to verify that a folder exists.
|
|
Uses the .NET Frameworks and Windows PowerShell to create a new folder on a computer.
|
|
Generates a tab-delimited report on the file age, file extension and directory depth of a directory and its child members. The file age is based on the last modified date and the
|
|
Deletes empty folders on a computer.
|
|
Modifies folder permissions based on the size of that folder. Permissions are revoked if the folder exceeds 10 megabytes in size and restored if the folder falls below the 10-mega
|
|
Uses information in an Excel spreadsheet to rename a specified set of folders.
|
|
Retrieves a list of shared folders from two separate computers and then displays that information side-by-side in an Excel spreadsheet.
|
|
Scans a document (from any attached scanner) and saves the document as a .bmp file.
|
|
Creates a temporary HTA file that functions as picture frame for .GIF, .JPG, or .BMP files.
|
|
Lists all the members of an Active Directory group, including members from any nested groups.
|
|
Lists all the members of an Active Directory group.
|
|
Retrieves the membership of a specified group (including the members of any nested groups), and then writes that information to a text file.
|
|
Copies the group membership from one group to another.
|
|
Imports/exports members to a group. Usage: cscript ADGrpExIm.vbs -g groupname [-f C:\group_in.txt ] or [-o C:\group_out.txt ] . Note that: 1) Options are necessary; 2) -g is a req
|
|
This is a simple one-line script used to add a domain user or group to the local Administrators group. I use this all the time to update lab environments via a login script.
|
|
Adds a domain group or user to the local Administrators group.
|
|
Adds domain users or domain groups to the local Administrators group.
|
|
Adds domain users (including users from Windows NT 4.0 domains) to the local Administrators group.
|
|
Reads in information from a text file and then adds specified users to the Local Administrators group on a set of computers. Scripts results are logged to an Excel spreadsheet.
|
|
Changes the local Administrator password for all the computers in a specified OU.
|
|
Lists all the members of the local Administrators group on a computer.
|
|
Adds a user or domain group to a local group by referencing the SID of the object being added. Note that there is no validation of the SID at runtime.
|
|
Removes all domain users from the Local Administrators group on a computer, then adds those users to the Power Users group on that same machine.
|
|
Copies and archives IIS logs.
|
|
Recycles specific IIS applications on specific IIS servers. Also provides assurance that a site is working again by connecting to the URL to verify functionality and content.
|
|
Backs up and restores the IIS metabase.
|
|
Function for retrieving a Web site service number. Input is the IIS RootPath and the website name to search for. The return value is either the service number of the site or -1 if
|
|
Deletes IIS log files older than 60 days. Syntax: /d -60 = days old. /p = logs reside here.
|
|
Function to retrieve a Web site name. Input is the IIS path for a service number. The returned value is the site name or -1 if the service number does not exist.
|
|
Enables/disables the extended logging options for the W3C Extended Log File Format provider.
|
|
Checks the status of all IIS application pools, and restarts any applications that have stopped.
|
|
Deletes IIS log files that are more than 90 days old.
|
|
Enumerates all the Web sites on the specified server.
|
|
Opens Internet Explorer and navigates to a specific Web site.
|
|
Displays the Web sites listed under "Do not use proxy server for addresses beginning with" box in Internet Explorer (on the Connections tab).
|
|
HTA that tells you whether the Internet Explorer proxy server is enabled or disabled. The HTA then gives you the option to change the setting.
|
|
Lists Internet Explorer Security Zone settings.
|
|
Opens the Dell OMSA web page on a remote server.
|
|
Disables Internet Explorer browser extensions.
|
|
Provides the ability to only type in the host name and the rest of the URL will automagically be filled in.
|
|
Configures the Internet Explorer home page.
|
|
Retrieves a list of network adapters and their IP addresses, then uses those addresses to determine whether or not it should disable proxy settings. I have this set up as a logon
|
|
Toggles the Use a Proxy Server setting in Internet Explorer.
|
|
Configures Internet Explorer proxy server settings based on the user location (on-campus or off-campus).
|
|
GUI utility for modifying Internet Explorer proxy server settings.
|
|
Configures Internet Explorer settings (such as cache size) and deletes IE cookies.
|
|
Prompts you for a 6-digit Microsoft Knowledge Base article number and then launches your default Web browser directly to that article.
|
|
Adds the specified URL to the Internet Explorer Favorites of the logged-on user.
|
|
Perl script that launches Internet Explorer, open to the Web page specified in the variable $URL.
|
|
Creates a table of links that can be imported into an HTML or ASP file.
|
|
Single script that opens three different Web sites, each in its own browser window.
|
|
Disables Passive FTP in Internet Explorer.
|
|
Enables you to start a Google Internet Search from the command-line. Usage: cscript.exe google.js Search_Criteria.
|
|
Provides a graphical user interface for searching the Microsoft Knowledge Base.
|
|
Reports the total size (in megabytes) of the C:\Program Files\iTunes folder and its subfolders.
|
|
Enables Remote Desktop on any computer (including a remote computer).
|
|
Creates a remote desktop connection to another computer. Just change "computername" to the name of the computer you want to connect to or to an IP address.
|
|
Changes the listening port for Remote Desktop (RDP).
|
|
Enables remote desktop connections on the target computer.
|
|
Provides a graphical user interface for connecting to a remote Desktop server.
|
|
Enables or disables Remote Desktop on a specified computer.
|
|
FTPs files to a particular folder. We use this for batch jobs for IBM mainframes running under z/VM. Jobs to be submitted are to be copied to p:\flex\rdr, and have an extension o
|
|
Starts or stops the PC Anywhere service. Just enter server name and start or stop.
|
|
Enables Terminal Services on a group of computers. The file Computers.txt should contain the names of the computers on which to enable remote desktop connections.
|
|
Sets both the profile path and home directory for Terminal Services user.
|
|
Determines whether a server is in Application or Terminal Services mode. Pass the name of the computer as a command-line argument when starting the batch file.
|
|
Enables RDP remote access on all the computers in a domain.
|
|
Template script for adding Terminal Server accounts to a multiple computers.
|
|
Installs the UtlraVNC client on computers. You will need to configure the INF, UUExport and ACL files according to UltraVNC's Web site instructions.
|
|
Adds a route after a VPN is connected. The VPN connection is configured to not use the default gateway on the remote network.
|
|
Starts a VNC service on the remote computer. I keep the VNC service set to manual for security; this script lets me launch it when I need to.
|
|
This script uses WMI to get the amount of memory in the specified machine. The script then does some simple comparisons to simplify the output.
|
|
HTA that monitors available memory.
|
|
Creates an instance of the default Microsoft Agent character. Demonstrates several methods for controlling the agent.
|
|
Sample script that enables you to interact with a Microsoft Agent character.
|
|
Backs up the Storage Group on a Microsoft Exchange 2003 Server.
|
|
Automatically modifies Exchange user quota settings if those users are not exempt from quotas.
|
|
Displays all Exchange recipients whose mailbox size is greater than specified amount (in KB).
|
|
Defragments the Exchange information store.
|
|
Disables user accounts and Exchange mailboxes.
|
|
Purges all mailboxes that have no associated user account.
|
|
Returns the total size of all mailboxes on an Exchange server.
|
|
Searches all the mailbox stores on a server to find a specific mailbox.
|
|
Enables the Automatically update e-mail addresses based on recipient policy option for all users in an OU or all of Active Directory. This is done by clearing the msExchPoliciesEx
|
|
Sets the Sending Message Size and Receiving Message Size value for all users of a specific Exchange server.
|
|
Restarts the Microsoft Exchange service. By mistake we made our Exchange server a domain controller and ever since it takes 20-plus minutes to restart. By stopping all mail-relate
|
|
Queries an array of Microsoft Exchange servers and returns mailbox information.
|
|
Changes user profiles that include a .prf file to reflect a new mail server. Executes only once per user, based on a registry setting.
|
|
Enumerates all the disconnected mailboxes on the target server, lists the individual and total size of each mailbox, and then gives the user the option of deleting those mailboxes
|
|
Displays SMTP Queue information for Microsoft Exchange Server 2007.
|
|
Lists all the Exchange Servers in the your Active Directory forest.
|
|
Outputs the name and number of objects in every Exchange store in the organization. Useful for load balancing mailboxes across stores.
|
|
Reports which users have access to Microsoft Exchange mailboxes.
|
|
For all the users in a specified OU, lists mailboxes that do not have a default storage size quota.
|
|
Creates mail-enabled distribution lists based on information read from a text file.
|
|
Adds a replica server to the replica list of all of the public folders on a Microsoft Exchange 2003 server.
|
|
Lists all the Microsoft Exchange servers in a forest.
|
|
Summarizes Microsoft Exchange 2003 appserver.log files by various criteria, including IP address, sender, and recipient.
|
|
Searches mailbox server application logs and reports available database space.
|
|
Moves all the Exchange mailboxes to a new database.
|
|
Retrieves all mailbox databases whose name include the string "Exchange".
|
|
Adds an SMTP address (based on first name and last name) to all Exchange mailboxes.
|
|
Retries all Exchange message queues that have 100 or more messages.
|
|
Enables all the mailboxes in the organizational unit named OU.
|
|
Disables the mailbox kenmyer@fabrikam.com.
|
|
Enables the mailbox kenmyer@fabrikam.com.
|
|
Locates the smallest mailbox database (in terms of size) for automatic provisioning process. The script retrieves a collection of mailbox databases, finds the size of each databas
|
|
Creates a new mailbox database named Finance Mailbox Database.
|
|
Enables circular logic on the storage group IT-database.
|
|
Disables Outlook Web Access for kenmyer@fabrikam.com.
|
|
Moves the mailbox kenmyer@fabrikam.com from one database to a "IT-Database" database.
|
|
Exports mailbox information to a comma-separated values (CSV) file named C:\Test.csv.
|
|
Determines whether or not all the Exchange mailbox databases are mounted.
|
|
Moves the mailbox kenmyer@fabrikam.com to a new database.
|
|
Retrieves the number of mailboxes in a database.
|
|
Sets the Send Storage quota for all the users in the Admins group to 500KB.
|
|
Lists all the mailboxes in a database.
|
|
Lists all the Application event log events that have the event code 1018.
|
|
Lists all Exchange-specific Windows PowerShell commands.
|
|
Exports both mailbox and user information to a single comma-separated values (CSV) file.
|
|
Limits the size of messages that can be sent or received from a database.
|
|
Creates a mailbox for all the users in the specified OU.
|
|
Configures the Mailbox database maintenance period for a Microsoft Exchange 2007 server.
|
|
Saves basic mailbox information, including display name, store, storage group, and mailbox size, to a comma-separated values file.
|
|
Finds the Microsoft Exchange 2007 database with the fewest mailboxes, then uses information retrieved from a text file to enable mailboxes in that database. Thanks to Nick Smith (
|
|
Moves mailboxes from Exchange 2003 to Exchange Server 2007 by reading user aliases from a text file.
|
|
Verifies public folder migration between Exchange 2000 and Exchange 2007.
|
|
Delivers a big-mailboxes report for Exchange Server 2007. The following script is very useful for almost every Exchange Administrator. It exports to a .csv file some important inf
|
|
Pings a range of IP addresses (within one octet) and will display Up or Down for each address. Passing Up or Down for the 4th parameter will only list addresses that match that c
|
|
Pings all the computers listed in the file Sservers.txt , and outputs errors to a second text file.
|
|
Shows the time your computer has been running for since its last reboot.
|
|
Monitors a folder until a specified file has been created.
|
|
Tests to see if a computer is on and if connectivity is reliable.
|
|
Uses Ping.exe to verify network connectivity.
|
|
Logs timed-out events to a text file. Requires Now.exe from the Resource Kit.
|
|
Uses the tool Portqry.exe to monitor local ports.
|
|
Monitors your Web site's availability. The script will alert you via email if the site is unavailable.
|
|
Pings a server and emails an alert if the computer is not available. GBMail is a popular freeware command-line emailer utility, but any other email utility can be used.
|
|
Sends HTTP or HTTPS requests to a list of URLs. The script logs all of its results and sends an alert if any of the URLs do not respond.
|
|
Monitors computer availability and sends email if a computer does not respond.
|
|
Monitors computer availability using a modified version of Ping.
|
|
Periodically checks to see if your Windows server is available on the network.
|
|
Uses the Net View utility to return a list of domain computers.
|
|
Retrieves health status markers (such as low disk space or printers that are offline) for a set of computers.
|
|
Reports the availability of two Web sites.
|
|
Pings the set of computers specified as command-line parameters.
|
|
Lists computer uptime (in hours).
|
|
Leverages Netstat.exe to determine the executable files using the ports on a computer. Requires Windows XP or later.
|
|
Monitors for a registry value change event and notifies you if your Internet Explorer home page choice is changed.
|
|
Repeatedly pings a target device to test network connectivity. On ping failure, the script can either case the computer to beep (useful for running in the background), or can writ
|
|
HTA that accepts an IP address or a host name, pings that computer, and then displays the results.
|
|
Monitors web pages and sends an e-mail if a page should become unavailable.
|
|
Sample function that pings a device on the network and then returns a value of True or False indicating whether the ping succeeded.
|
|
Sends a ping packet to a remote IP address, varying the size of the packet and recording the returned values in Microsoft Excel.
|
|
Runs in the background and sends an email any time a USB storage device is plugged into a computer.
|
|
Batch file that both pings computers and performs name resolution.
|
|
Uses the Windows Resource Kit utility Uptime.exe to query a list of servers and retrieve information about abnormal shutdowns, blue screens, and other events. Also requires a Wind
|
|
Verifies the status and availability of a Web page. The script returns the appropriate status code and a formatted message, and can be used before opening/logging into a web site
|
|
Verifies network connectivity for all the servers in Active Directory.
|
|
Retrieves information from a MySQL database. Make sure you install the MySQL ODBC driver first.
|
|
Creates a graphical user interface for the Net Send command.
|
|
Lists all Microsoft MOM computer groups. Dependencies include: 1) A system DSN named MOMDB to access the database; and, 2) D:\Scripts\ComputerGroups\Groups must exist.
|
|
Scans for instances of a specified process. The script will raise a MOM event if the process count equals, is greater than, or is less than a given value, based on the variables i
|
|
Lists all computers in a MOM computer group.
|
|
Checks for locked-out user accounts in a specified Active Directory OU (and any sub-OUs). If a locked account is found the script creates an event that can be identified by a MOM
|
|
Internal MOM script that auto-resolves all alerts.
|
|
Internal MOM script that loops through the alerts generated by an alert rule and auto-resolve those alerts.
|
|
Creates an alert in response to a MOM event.
|
|
Microsoft Operations Manager response script that deletes a folder.
|
|
Microsoft Operations Manager response script that deletes a file.
|
|
Executes a simple SQL query to verify that records can be returned from an Oracle database.
|
|
Opens Outlook's Secure Temporary Files Folder in Windows Explorer.
|
|
Scans the local hard drive for .PST files and copies them to the specified location. Note: If a non-existent path is entered, you can type Ctrl+C in the command window to end scri
|
|
Lists all the .PST files associated with the logged-on user.
|
|
Drafts and sends an email using Microsoft Outlook.
|
|
Saves all the attachments in an Outlook message, then updates the message with the location of the saved attachment. Designed to run as a macro within Outlook.
|
|
Searches email messages in the Inbox, comparing each sender's email address to the addresses of existing contacts.
|
|
Performs the same task as /resetfoldernames command switch. The script requires an ExIFS drive (see http://support.microsoft.com/kb/821836) as well as full access to all mailboxe
|
|
Locates all the Microsoft Outlook .PST files for the logged-on user.
|
|
Creates a Microsoft Outlook email signature based on Active Directory information for the logged-on user.
|
|
Adds a folder named Inbox2 as a subfolder of the Microsoft Outlook Inbox.
|
|
Creates an Outlook contact for Ken Myer.
|
|
Creates an Outlook task named Script Center Master Plan.
|
|
Retrieves the total size of and the number of items in the Microsoft Outlook contacts folder.
|
|
Lists the full name and business telephone number for all the contacts in the Microsoft Outlook Contacts folder.
|
|
Creates a new appointment (Scripting Guys Planning Session) in Microsoft Outlook.
|
|
Adds a number of holidays to the Microsoft Outlook calendar.
|
|
Sends an email using Microsoft Outlook.
|
|
Creates a new contact (for kenmyer@fabrikam.com) in Microsoft Outlook.
|
|
Retrieves contact information from Microsoft Outlook and then writes that data to a Microsoft Excel spreadsheet.
|
|
Retrieves the first email message in the Outlook Inbox and saves that message as a text file.
|
|
Retrieves the sender's email address for each message in the Outlook Inbox folder.
|
|
List all of the appointments in the Outlook Calendar.
|
|
Accesses a mail folder that isn't a subfolder of the Outlook Inbox
|
|
List email messages from the Outlook Inbox with specified text in the Subject line.
|
|
Randomly select an email message from an Outlook mail folder.
|
|
Start Outlook if it's not already running.
|
|
List all the members of an Outlook distribution list.
|
|
Save all email messages from the Outlook Inbox that are more than one month old to a specific folder.
|
|
List the dates email messages in the Outlook Inbox were sent, and how many messages were sent on each of those dates.
|
|
Retrieve email from the Outlook Inbox that was sent from a specified address
|
|
Delete email from the Inbox that was sent from a specific person.
|
|
Creates a new email message, adds a recipient, and then displays the message onscreen.
|
|
Retrieves the name of each folder and subfolder found in a Microsoft Outlook Inbox.
|
|
Locates the first item in a Microsoft Outlook collection, then uses the GetNext method to access the next item in that collection.
|
|
Deletes all the email messages found in the Junk Mail folder in Microsoft Outlook.
|
|
Lists all Microsoft Outlook appointments scheduled in December, 2007.
|
|
Creates a recurring task in Microsoft Outlook.
|
|
Creates a new note in Microsoft Outlook.
|
|
Creates a folder named Scripts Received as a subfolder of the Outlook Mailbox folder.
|
|
Creates a new Outlook folder named Scripts Received.
|
|
Adds a picture to the Jean Ross contact in Microsoft Outlook.
|
|
Displays a dialog box that enables the user to select a Microsoft Outlook folder.
|
|
Locates a specified personal folder in Microsoft Outlook.
|
|
Creates a new Outlook Explorer and then displays the Inbox in that folder.
|
|
Exports all the mail items in a Microsoft Outlook mail box to .MSG files. The script also allows you to specify a different output format.
|
|
Creates an e-mail signature with a logo when using Office Word as e-mail editor.
|
|
Decodes an Outlook MSG file by reading the Compound Binary File format directly. Note that most of the details on the compound binary file format were derived from www.openoffice.
|
|
Disables mouse acceleration on a computer. As written, the script disables acceleration; however, if you want to enable acceleration, just change the strValue variable to = "1".
|
|
Disables USB storage devices, but does not affect other USB devices.
|
|
Uses the Microsoft Office object model to open a PowerPoint presentation from a script.
|
|
Opens an existing Microsoft PowerPoint presentation and then saves the file in HTML format.
|
|
Creates a Microsoft PowerPoint presentation, creates a new slide, then adds a text box to that slide.
|
|
Inserts an Excel chart into a PowerPoint presentation.
|
|
This script finds all the printer connections on your computer and then allows you to choose a new default printer.
|
|
Installs a TCP/IP printer port, installs a printer, and then sets the printer to be default. As written the script installs a Brother printer, but you can substitute any printer
|
|
Builds an Excel spreadsheet with information about all the printers in a print server.
|
|
Exports printer information to a Web page.
|
|
Reinstalls a client printer, reflecting changes made to a network print server.
|
|
KiXtart script that modifies a print connection on a Windows XP computer. Jens Meyer wrote the function used in this script.
|
|
Deletes a printer connection on logoff.
|
|
Adds a TCP/IP printer port and printer.
|
|
Stops and then restarts the Print Spooler service.
|
|
Lists information about the printers installed on a print server.
|
|
Determines the computer's location in Active Directory and then connects to all the printers found in that location.
|
|
Creates a TCP/IP printer port and installs a network printer.
|
|
Lists all printers on a given print server (or the entire domain), connects to those print servers, and then removes the printer connection. Handy when you do not allow Terminal S
|
|
Installs a network printer on a workstation and makes that printer the default printer.
|
|
Installs a network printer. Use the /y parameter (rather than /n) to set the new printer as the default printer.
|
|
Adds a network printer and sets it as the default printer.
|
|
Installs a network printer at logon. The script determines if the user has this printer installed already; if they do, then the script exits. If the printer is not installed th
|
|
Checks for the existence of a network printer on a computer, and adds that printer if it cannot be found.
|
|
Deletes existing printer connections and creates new connections to different print servers.
|
|
Assigns printer resources based on group membership.
|
|
Adds a printer and a TCP/IP printer port using information found in an INF file.
|
|
Moves networked printers on a local computer from one print server to another. The script also identifies the default printer and maintains that setting after remapping the printe
|
|
Maps printers according to the OU of the computer the user has logged on to. The script also logs the user name, computer name, IP address, logon time, and computer OU into an Ac
|
|
Removes old printer connections and installs new printers on all the PCs on the network. Run this as a logon script.
|
|
At logon, connects users to a specified print server. Each location has an allocated print server, and he administrator does need to know the actual name of the server, just the l
|
|
Moves mapped printers from one print server to another.
|
|
Removes existing printer connections and remaps those connections to a new print server. This script can be executed at login to change the printer connections on the workstation
|
|
Changes a client printer connection to point to a different print server.
|
|
Remaps printers to a new print server.
|
|
Logon script that changes the printer connections on workstations.
|
|
Points an existing printer on a client computer to a new print server.
|
|
Remaps print printers from one print server to another and logs the results.
|
|
Logon script that installs new printers and deletes old printers.
|
|
Moves network printers on a local computer from one print server to another. Identifies the default printer and restores the default printer after all the printers have been moved
|
|
Logon script that connects users to assigned\available print servers. Each location has an allocated print server and the script provides resilience in case one the remote\central
|
|
Manages a user's network printers.
|
|
Logon script that maps printers based on Active Directory group membership.
|
|
Retrieves print server information and then writes the returned data to an Excel spreadsheet.
|
|
Replaces local printer connections with Active Directory printer connections.
|
|
Deletes connections to any network printers that are currently paused.
|
|
Manages printer drivers and printer ports.
|
|
HTA that retrieves duplex printing settings. These settings are kept in a binary key of the registry; the key is to discover which must be to changed to set duplex printing, becau
|
|
Creates a printer exclusion list which specified printers not to be affected by the community script Apply Printer Settings to Network Printers.
|
|
This script terminates a specified process on a remote computer.
|
|
This script determines whether or not a specified process is running and, if so, kills it.
|
|
Terminates a process on a computer.
|
|
Displays the processes running on a computer. The script accepts a computer name as an argument and displays help if an incorrect argument is used.
|
|
Takes a computer and process name from input boxes and then terminates the process.
|
|
Terminates a process on a remote computer. Accepts a computer name and process ID as arguments
|
|
Terminates a specified process on a specified computer.
|
|
Checks to see if a specific program is running. If it is, a message box apprises you of this fact; if not, the script starts the program. You must set the process name with the na
|
|
Verifies whether or not a specified process is running. If the process is not running (possibly due to a crash), the script will restart the program. Add this script to your sched
|
|
Monitors a computer for the creation of new processes.
|
|
Checks to see if the Cmd.exe, Omreport.exe, and Dfrgntfs.exe processes are running on remote computer. Retrieved data is exported to Microsoft Excel.
|
|
Runs a command on a remote computer. Start the script using syntax similar to this: remotecommand.vbs Computer1 "GPUPDATE /force ".
|
|
Lists processes running on a computer. Output is displayed in an Internet Explorer window.
|
|
Terminates and restarts Explorer.exe.
|
|
Lists all the processes running on a set of computers that are running under a specified user account.
|
|
Starts a command-line utility (in this case, Ntbackup.exe) from within a PowerShell script.
|
|
Counts processes and, in this example, triggers an alert if less than 4 instances of Notepad.exe are running.
|
|
Retrieves information about the processes running on the local computer or on a remote computer. The parent process PID enables you to determine whether the process is the parent
|
|
Lists all workstations on a domain and terminates a specified process on the selected workstation.
|
|
Monitors a running process and then generates a Microsoft Operations Manager (MOM) event based on the status of that process.
|
|
Sample script that installs a .REG file.
|
|
Reads information from a registry key, writes that same information to a new key, and then deletes the original key.
|
|
Toggles the Get-Credential prompting method between console and CredUI.
|
|
Adds a scheduled task to a computer. The script uses a command window to display the time one remote computer (in case times are different).
|
|
Sample scripts that demonstrates how to create and delete scheduled tasks.
|
|
Schedules an automatic reboot of a computer at a specific day and time.
|
|
Creates a Crontab-like function for running scripts at regularly-scheduled interval.
|
|
Lists all the scheduled tasks on a set of servers that failed to execute in the past three days.
|
|
Starts or stops services based on service number.
|
|
Takes a given service and restarts it. The script uses the checkpoint flag to make sure it continues to run until the service has restarted.
|
|
Starts or stops a service running on a machine and then writes an event to the Application log.
|
|
Lists all services whose startup mode is set to Manual.
|
|
Lists all services whose startup mode is set to Disabled.
|
|
Retrieves a list of all the services running on a computer, then writes the values of the display name, service name, service state, start mode and process ID properties to a text
|
|
Displays all services whose startup mode is set to Automatic.
|
|
Lists all services that are set to run under the Local System account.
|
|
Lists all services that can interact with Windows on the desktop.
|
|
Scans a set of computers for the Microsoft FTP service. If the service is found on a computer, the script reports the value of the AllowAnonymous property for each FTP site hoste
|
|
Determines service status and asks if you want to change this status. The script will also ask if you want the service disabled.
|
|
Determines whether a particular service is installed and if it is running or stopped. Results are written to a user-designated file.
|
|
Retrieves all services running on a computer and then writes the display name, service name, service state, start mode and process ID properties to C:\RunningServicesList.csv. If
|
|
Starts or stops a specified service on a specified computer.
|
|
Lists services running under domain accounts, and does this for all the computers in a domain.
|
|
Checks the State of SCardSvr (Smart Card) service. If the service is stopped, the script deletes a file and then restarts the service.
|
|
Stops and disables a service on one or more computers.
|
|
Retrieves service data and then displays that information on an Excel spreadsheet.
|
|
Connects to all the servers in an OU and looks for services running under a specified account.
|
|
Checks to see if the Messenger service is installed on a computer and, if it is, indicates whether or not the service is currently running.
|
|
Creates a file share for an existing folder.
|
|
Deletes the C$ administrative share from a computer.
|
|
Creates a shared folder, giving full control to a specified user.
|
|
Lists the all network shares on a computer as well as the size of those shares.
|
|
Creates a series of shared folders (as specified in a text file), creates four security groups per share, and then assigns the appropriate access permissions to those groups.
|
|
Determines the currently logged-on user and then retrieves mapped drive information from the registry.
|
|
Batch file that removes and assigns network shares in an environment that includes multiple versions of Microsoft Windows. Requires the command-line tool Gettype.exe, which must b
|
|
Deletes all the shares on a computer except the Print$ share.
|
|
Enumerates and backs up SharePoint Sites to a specified backup directory.
|
|
Defines SharePoint Web paths by configuring URLs as managed (inclusion) or unmanaged (exclusion). Requires Stsadm.exe , found in C:\Program Files\Common Files\Microsoft Shared\Web
|
|
Creates a new Active Directory site.
|
|
Creates a new Active Directory subnet and links it to a current AD site.
|
|
Creates a new Active Directory site link and connects it to a pair of existing sites.
|
|
Backs up and restores subnets to and from text files. This script developed to replicate production sites and services. Usage: cscript SubnetsExpImp.vbs [-i C:\subnets_in.txt ] or
|
|
Backs up and restores sites and site links to and from text files. The script was developed to replicate production sites and services. Usage: cscript SitesExpImp.vbs [-i C:\sites
|
|
Notifies you by e-mail whenever someone leaves you a Skype voice-mail message. To use this script, you need to download and copy the freeware mail utility Blat.exe (http://www.bla
|
|
Sends an email, complete with read and delivery receipts, using CDO (Configuration Data Objects).
|
|
Sends email using a remote SMTP server.
|
|
Sends email using a remote SMTP server.
|
|
Email an attachment in VB.NET, using settings found in the Web.config file.
|
|
Sends email using a remote SMTP server; an alternate SMTP server is used if the primary server is unavailable. The SendTo field is required, while the From, Subject, text, text fr
|
|
Sends email and attaches all the files in the designated folder.
|
|
Sample subroutine that sends email via SMTP. Coupled with the GetMail and GetADsPath functions this subroutine can also look up email addresses in Active Directory as required.
|
|
Connects to a Sybase Database by using ODBC.
|
|
This sample script shows how to read a specified attribute for every user account in an organizational unit.
|
|
This script enumerates and records in a text file all the expired accounts found in the User container.
|
|
Displays every group that a user is a member of.
|
|
Indicates whether or not the logged-on user is a member of the specified group.
|
|
Script that performs three functions for all the users in organizational unit: 1) Ensures that all passwords will expire; 2) Requires users to change their password; 3) Assigns an
|
|
Lists group memberships for the logged-on user. It is best to run this with CScript from within a command window.
|
|
Tests whether a user belongs to a specified group or not.
|
|
Updates all the user accounts in an OU with the same address information. Useful when changing physical office locations.
|
|
Script that disables an AD user account. At the same time the group saves the user's group memberships in a file, removes the user from all groups, and moves the user's home direc
|
|
Takes a set of organizational units and returns a list of all the users those OUs.
|
|
Sets the Display Name for each user in an OU to the user's first name plus their last name.
|
|
Unlocks a locked user account.
|
|
Enables or disables a user account in Active Directory.
|
|
Exports a list of users and their email addresses to a text file.
|
|
Displays detailed information on a user account and then writes that information to a text file. This batch file takes one parameter: the name of a user (for example, netuser.bat
|
|
Reports security group membership for the logged-on user. The output is sorted and filtered to remove duplicate entries.
|
|
Lists all the user accounts found in an OU and any sub-OUs.
|
|
Retrieves information for a specified user account. Allows you to change the password of the user or require the user to change their password the next time they log on.
|
|
Retrieves OU membership for Active Directory users and saves that information to a text file.
|
|
Verifies whether or not an email address is already being used in a domain.
|
|
Searches Active Directory for a specified Employee ID.
|
|
Lists the universal distribution groups a user belongs to.
|
|
Searches Active Directory for a specified user account.
|
|
Returns information on all users in the Active Directory and displays that data in an Excel spreadsheet. Very useful in maintaining the user base in Active Directory.
|
|
Sends email to users whose password will expire between 1 and 15 days. If the password expires and remains expired for more than 30 days, the user account is then moved to a diff
|
|
Reads a comma-separated values file and creates user accounts based on the information found in that file.
|
|
Retrieves user account information and stores the data in a spreadsheet.
|
|
Determines the sAMAccount Name for a specified user.
|
|
Creates user accounts based on information found in a tab-delimited text file. If Exchmbx.exe ibis n the current working directory you can remove the REM comment from the Exchmbx.
|
|
Changes the password for all the users in an OU.
|
|
Disables user accounts and then moves those disabled accounts to a specified OU.
|
|
Creates a mail-enabled contact in Active Directory.
|
|
Reports status information for Active Directory migrations.
|
|
Searches for -- and provides an option to modify - Active Directory users accounts.
|
|
Moves all the user and group accounts in the source OU to the specified target OU.
|
|
Creates a home directory and assigns access permissions for all the user accounts included in a text file. The script can generate this text file (retrieving a list of all the use
|
|
Reads user names from a text file, then modifies the corresponding accounts to require the users to change their password the next time they log on.
|
|
Assigns home drives to domain users.
|
|
Lists, creates, and deletes Active Directory objects like users and groups. Type the LDAP query in the first text box; for example, OU=HR,DC=Hello,DC=COM. Then type the object nam
|
|
Creates Active Directory user accounts based on information found in an Excel spreadsheet.
|
|
Returns the distinguished name of an Active Directory object.
|
|
Returns the distinguished name of an Active Directory object. This is useful if you don't know the location of a user, group or computer.
|
|
Sample script for modifying Active Directory user account information. This allows a novice scripter to easily customize input, while automatically formatting output. The script a
|
|
Searches Active Directory to see if a proposed sAMAccountName already exists. Useful when creating accounts that must follow a specific naming convention.
|
|
Function that converts a distinguished name into a fully-qualified domain name.
|
|
Provides a graphical user interface enabling users who have the appropriate permissions to edit selected personal details of employees (in this case, job title, department, and ma
|
|
Retrieves the value of the defaultNamingContext for the domain of the logged-on user.
|
|
Retrieves the domain name for the logged-on user.
|
|
Retrieves the value of the ADsPath attribute for the user currently logged-on to a computer.
|
|
Converts all the user accounts in an OU to inetOrgPerson accounts.
|
|
Retrieves (and then enables you to remove) inactive Active Directory user accounts.
|
|
Retrieves a list of all Active Directory users who have the AllowDialin attribute enabled.
|
|
Compares the Active Directory group memberships for two users.
|
|
Loads selected user attributes to a SQL Server database. This script requires Powersmo (PowerShell Community Extension 1.1.1) and a SQL Server database with SMO locally installed.
|
|
Deactivates an Active Directory user account. Among other tasks, the script disables the account; hides the account from the Global Address List; removes all group memberships;
|
|
Replaces the specified attribute value (e.g., Department=Accounting) with a new value (e.g., Department=Fiscal Affairs).
|
|
Checks the Password Never Expires attribute for the specified user.
|
|
Determines the last logon date and time for the specified user.
|
|
Moves home directories to a new server.
|
|
Creates an Active Directory user account, including mailbox, home directory ( and permissions), and profile directory (and permissions), as well as several other attributes. The
|
|
Lists all the groups that a user belongs to, include nested groups.
|
|
Exports Active Directory user information to a coma-separated values file.
|
|
Imports data from a comma-separated values file and then creates new Active Directory user accounts based on that data.
|
|
Uses VBScript in an .asp Web page to enumerate the user's DisplayName and EmailAddress values back to the Web page.
|
|
Given a list of workstations, this creates a local user account on each machine and then adds that account to the local Administrators group.
|
|
Lists the local user accounts found on a specified set of computers.
|
|
Adds a user to the local Administrators group on a computer.
|
|
Changes the local Administrator password. The script should be deployed using Group Policy or through a logon script.
|
|
Resets the local Administrator password and writes the results to the Application event log. This script was designed to be encoded using the Microsoft Script Encoder.
|
|
Generates and assigns a random ASCII password to the local Administrator account on one or more computers.
|
|
Changes the password for a specified user account. Can perform this task on multiple computers.
|
|
Deletes one or more local user accounts.
|
|
Changes the local Administrator password. Designed for computers running the Spanish-language version of Microsoft Windows.
|
|
Retrieves the local or Windows NT 4.0 groups a user belongs to and then displays those group names in an Excel spreadsheet.
|
|
Displays the operating system name, version and path.
|
|
Returns the installation date of the operating system, as well as the number of days that have passed since that installation.
|
|
Retrieves operating system and service pack information for a set of computers and writes that data to an Excel spreadsheet.
|
|
Automates the process of creating new virtual servers from a template .vhd file.
|
|
Converts a dynamically-expanding virtual hard drive to a fixed disk.
|
|
Displays uptime for all the virtual machines currently running on a computer.
|
|
Attaches floppy drives to an instance of Microsoft Virtual Server. This script is great for those who release all the drives for ASR, then need to re-attach them .
|
|
Sample script that uses Windows PowerShell to retrieve and display weather data from Yahoo! Weather.
|
|
Turns off Firewall monitoring in the Windows Security Center. We use this when rolling out new computers and we have to turn off the Firewall and the Security Center monitoring of
|
|
Enables the Windows Firewall, opening ports for the file and print service and for remote desktop.
|
|
Opens port 445 on the Windows Firewall.
|
|
Determines whether or not the Windows Firewall is enabled on a computer, and gives the user the option to turn the Firewall on or off. This scripts works only on the local compute
|
|
This script creates a playlist and plays all the .MP3 files in a folder. The script should be run from the folder where the MP3 files are stored.
|
|
Processes a folder of WMA files, copying the first stream (usually the only stream in an audio stream) to a new file, and indexes it. This is useful if you have archives of live
|
|
Generates a playlist consisting of all the .AVI, .WMV, and .MPG files found in a folder.
|
|
Enables you to select a Windows Media Player playlist and then output that list to Microsoft Excel.
|
|
Lists properties and values for any WMI class within the root\cimv2 namespace. The output is in Excel format.
|
|
Sample script that provides a GUI WMI Explorer and WMI Method Help Generator.
|
|
Converts specified paragraph style settings in a Microsoft Word document. The document must contain a table in order for the script to run correctly.
|
|
Counts the instances of a word, phrase, or text string in a Microsoft Word document.
|
|
Toggles startup templates in Word's startup folder by changing their extension to .dot_off or .dot. This helps you start Word with only the startup templates you need. Word must n
|
|
Creates a new Normal.dot template by backing up the current one. The old template gets a timestamp for future reference. Word must be closed for the script to run.
|
|
Modifies the Microsoft Word Workgroup Templates path.
|
|
VBA function for getting and setting a custom document property.
|
|
Sample script that shows how you can use Microsoft Word to print a text file to any printer, even if that printer is not set as the default.
|
|
Creates a new Word document based on a template, then launches a VBA subroutine contained in the template.
|
|
Creates an HTML table using Microsoft Word.
|
|
Starts Microsoft Word, adds a new document and then creates sample text using each available font.
|
|
Inserts a date two weeks from the current date into a Microsoft Word document.
|
|
Adds a hyperlink to a Microsoft Word document.
|
|
Opens a Microsoft Word document with the cursor positioned at the beginning of line 31.
|
|
Sets the Revision View mode in a Microsoft Word document to Final.
|
|
Adds centered page numbers to the footer of a Microsoft Word document.
|
|
Adds a new item (Fabirkam/Fabrikam) to the AutoCorrect list in Microsoft Word.
|
|
Removes all paragraphs that do not use the Heading 1 style from a Microsoft Word document.
|
|
Adds two tables to a Microsoft Word document.
|
|
Right-aligns a single column in a Microsoft Word table.
|
|
Retrieves all the .rtf files in a folder, opens those files in Microsoft Word, and then saves each file in Word format.
|
|
Retrieves all the .doc files in a folder and adds up the total page count for all those files.
|
|
Adds two tables to a Microsoft Word document.
|
|
Adds formatted text to a Microsoft Word document.
|
|
Opens an existing Microsoft Word document and adds text to the end.
|
|
Searches a Microsoft Word document for specified text and replaces that text with atl-ws-01.
|
|
Lists statistics such as number of lines and number of words for a Microsoft Word document.
|
|
Puts a border around a paragraph in a Microsoft Word document.
|
|
Appends text to an existing Microsoft Word document.
|
|
Numbers each line in a Microsoft Word document.
|
|
Adds information to a Microsoft Word table and then inserts a formula to sum the values.
|
|
Opens and prints a document without Microsoft Word ever appearing onscreen.
|
|
Modifies a pair of bookmarks (NameBookmark and AddressBookmark) in a Microsoft Word document.
|
|
Searches a document for the word Contoso and deletes each instance of the word.
|
|
Adds a picture (C:\Scripts\Welder-small.jpg) to a Microsoft Word document.
|
|
Adds a table to a Microsoft Word document and then formats the text in column 1.
|
|
Lists property values for Microsoft Word.
|
|
Uses Microsoft Word to grammar check a sentence.
|
|
Retrieves the value of the LastSavedBy field from a Microsoft Word document.
|
|
Sample function that searches Active Directory based on three parameters: ObjectCategory, Attribute and Query. The function returns the complete ADsPath, thus making it easy to co
|
|
Finds objects in Active Directory based on a specified criteria and then returns the attributes you request. A pipe-delimited array is returned with the attributes requested. This
|
|
HTA for creating/deleting multiple Active Directory accounts. Includes a function that enables you select to an OU when creating accounts.
|
|
Loads Active Directory computer, group and person attributes into a database. This script requires Powersmo (PowerShell Community Extension 1.1.1) and a SQL Server database with S
|
|
Reads the security descriptor on CA templates; requires Ssacls.exe in current directory or in path. Note that there is a limitation with Dsacls: it will not report the right for a
|
|
Returns an object's GUID after you have connected to the userObject.
|
|
Creates a CSV report of junctions on a computer. Requires Linkd.exe and a ScanFolders.txt file. Script is documented via inline comments. Linkd.exe is part of the <a href="http://
|
|
Enumerates all authorized DHCP Servers in Active Directory. Will list IP address, hostname, and if system pings successfully by hostname, all based on the data found in the Config
|
|
Modifies the operating system source path. Whenever I build a PC I copy the i386 folder to the local drive. This script modifies the source path, thus preventing Windows from havi
|
|
Installs software on remote computers (computer names are obtained from a text file).
|
|
This script searches a list of computers to see if they have a specific patch installed.
|
|
This script retrieves the operating system hot fix information and writes that data to a text file.
|
|
Configures Windows Update settings.
|
|
Returns a list of all the installed applications on the computer. The script runs through the list, removing any programs that do not have the letters KB in the application name,
|
|
Retrieves a list of software updates applied to a computer. Place the script in the folderC:\Scripts\Patchlist and place the list of computers in a text file called Ws.txt (in the
|
|
Checks the registry to see if Q823353 and KB897715 have been installed.
|
|
Installs Service Pack 2 silently after checking for Sp2.txt, specific computer names, the installed operating system, and group membership.
|
|
Queries the Win32_Product class, echoing the installed applications and their respective version numbers.
|
|
Verifies the installation of updates specified in an Excel spreadsheet.
|
|
Forces a Windows update detect cycle (equivalent to wuauclt.exe /detectnow) using the AutoUpdate object.
|
|
Deletes any duplicate SUS client IDs found on a computer. These IDs are often found on computers where the operating system was installed using an image-based setup.
|
|
Forces update detection from an Automatic Update Client or Windows Update Agent when using Windows Server Update Services or Software Update Services.
|
|
Lists installed Service Packs and hot fixes. Result are written to %temp%\UpdateList.txt and then displayed in Notepad.
|
|
Lists Automatic Update Client and/or Windows Update Agent settings. Results are written to %temp%\WUASettings.txt and then displayed in Notepad.
|
|
Installs Windows XP Service Pack 2.
|
|
Retrieves computers names from an Active Directory OU and then lists the updates installed on each of those computers.
|
|
Determines whether a specified update (in this case, 899588) as been installed on a computer.
|
|
Forces Windows Server Update Services to perform detection and report operations.
|
|
Lists all the security updates required on the local computer.
|
|
Locks the desktop, as if you had pressed the keyboard sequence Windows Key+L.
|
|
Creates a shortcut for locking a workstation.
|
|
Prevents user from saving files to the desktop. The script can be easily modified to set other NTFS access permissions.
|
|
Lists the mapped drives and installed printers for the currently logged-on user. The script then creates a text file named C:\ Info.txt, with the computer name at the bottom of th
|
|
Changes the My Computer label so it shows the computer name and user name. Runs only on Microsoft Windows XP.
|
|
Lists the mapped drives and installed printers for the logged-on user. The script then creates a text file named C:\Info.txt, with the computer name at the end of the file.
|
|
Adds the Tweak UI utility to the Windows Control Panel.
|
|
Minimizes all open windows.
|
|
Maps a network drive. You must provide an available drive letter and network share.
|
|
Uses the Subst command to assign a drive letter to a user-selected folder.
|
|
Checks links and prepares a text report identifying shortcuts that may no longer work.
|
|
Hides the screen saver tab when the user opens the Display Properties dialog box.
|
|
Adjusts the contents of the Path statement. When the operating system needs to search for an executable, it searches the Path statement in order. Because of that it is sometimes n
|
|
Reads the PendingFileRenameOperations registry value to determine rename operations that must be carried out next time the workstation is rebooted. This value is usually set durin
|
|
Maps a drive to the C$ administrative share.
|
|
Configures Windows 2000/Windows 2003 server CrashOnCtrlScroll memory dump settings.
|
|
Renames the local computer.
|
|
Maps a network drive.
|
|
Unmaps a network drive. Usage: RemoveDrive P:.
|
|
Sets the home drive path for the logged-on user.
|
|
Maps several different network drives.
|
|
Checks the fonts installed on a local computer and, if there are differences between those fonts and the fonts shown on a master list, installs the missing fonts.
|
|
Maps drives and records the status to the Application event log. The script also determines the computer role and exits if the computer is a domain controller.
|
|
Deletes temporary files from the specified computer.
|
|
Maps a network drive and attaches a printer connection. Designed for use in a batch file.
|
|
Maps a network drive and gives you the opportunity to give the drive a more-meaningful drive label.
|
|
Renames a remote computer by using Netdom.exe.
|
|
Determines the current directory of a script and then opens that directory in Windows Explorer. I loved the cmdHere tool so much it made me want the opposite - something that wou
|
|
Renames the local computer.
|
|
Modifies the Daylight Savings start times for the US Central and Eastern time zones.
|
|
Uses environment variables to determine the path to the Windows folder.
|
|
Installs fonts on a computer.
|
|
Enables you to create, read, and modify environment variables.
|
|
Creates a friendly alias for applications and other files and folders.
|
|
Creates a desktop shortcut to an Intranet URL.
|
|
Changes the Description on computers to the user name (%username).
|
|
Hibernates a computer.
|
|
Enumerates all files on a share larger than the specified size. Requires Forfiles.exe.
|
|
Searches for files using Windows PowerShell and Windows Desktop Search 3.0.
|
|
Searches all the files in a folder for those files containing a specified string value.
|
|
Checks the current version of MDAC (Microsoft Data Access Components).
|
|
This script will list the logged-on user for any remote machine. It's really a cheat as it simply checks the owner of the explorer.exe process, which is only every running if a u
|
|
Determines the user logged on to a computer. I added in the Ping command so that the script wouldn't fail if the computer didn't exist or wasn't turned on.
|
|
Modifies the username and domain name of the last user to logon to a computer.
|
|
Queries a WINS server to determine the computer a user is logged on to. Change this line to reflect your environment.
|
|
KiXtart script that lists the user logged in to each computer in a domain.
|
|
Maps a network file share to a local drive letter. You can specify a credentials file that has the username and password that should be used to authenticate the connection. Synta
|
|
Lists user profiles larger than 1 gigabyte.
|
|
Lists the user logged on to a computer.
|
|
Changes the default user name shown on the Windows logon screen.
|
|
Displays the name of logged-on user using Remote Desktop on a Windows XP computer.
|
|
Configures a computer to automatically log on to the network each time it is turned on. Used in kiosk situations where a computer needs to be logged on to a specific account at al
|
|
Removes local user profiles. Useful to run as a scheduled task after the computer reboots, especially for Terminal Servers.
|
|
Retrieves user settings at logon and writes this information to a log file.
|
|
Logoff script that removes a user from a database of logged-on users.
|
|
Logon script that adds a user to a database of logged-on users.
|
|
Uses a database of logged-on users to determine the user logged on to a specified computer.
|
|
Adds 3 additional lines to the logon box.
|
|
Adds up to three lines of information (for example, additional help or support for users logging on to the network) to the logon dialog box. This script only works on computers t
|
|
Removes the name of the last logged-on user from the registry.
|
|
Maps printers according to the OU of the computer the user has logged on to. The script also logs the user name, computer name, IP address, logon time, and computer OU into an Ac
|
|
Enables active content from CDs to run in the My Computer security zone; also enables files to run in this security zone. This is needed when working with CDs that use JavaScript
|
|
Configures a command or application to run on one or more computers via the RunOnce registry key.
|
|
Removes remote desktop history settings in the registry, and deletes the file Default.rdp from the logged-on user's My Documents folder.
|
|
Uses Setx.exe (available in the Microsoft Windows Server 2003 Support Tools folder) to assign the %NetID% environment variable to a computer.
|
|
Requests a computer name (or partial name) and checks the machine for logged-on users. If a user is found the script returns the username. The * wildcard is supported.
|
|
Configures the default domain logon information for a computer.
|
|
Deletes user profiles not accessed in the past 180 days.
|
|
Uses environment variables to determine the user name and domain for the user logged on to a computer.
|
|
Lists the environment variables on a computer.
|
|
Takes a list of computer names and returns the name of the last logged-on user. Requires a list of computer names in a text file called machinelist.txt.
|
|
Adds a new folder to your Windows path.
|
|
Resets the last logon name on a computer.
|
|
Listens for the arrival of a specific drive (by label or name, not letter), and assigns it a specific drive letter when found.
|
|
Listens for the arrival of a specific drive (by label or name, not letter), and assigns it a specific drive letter when found.
|
|
Displays a popup message asking the user if he or she would like to "snooze" for one minute. A .wav file is played prior to displaying the popup, and the script loops around until
|
|
Searches for files with a specific file extension. You can narrow the search by specifying a full or partial file name.
|
|
Disables the CD-ROM drive. You may need to reboot the computer before the change takes effect.
|
|
Searches all of the computers in Active Directory for CD drives that have CDs in them. Useful for those times when your needed a CD, went to where you keep your CDs, then discover
|
|
Lists all the CD-ROM drives on a computer (or multiple computers) and then displays the volume name of any CD in the drive.
|
|
This script reads a text file that contains the names of computers on the network. It then retrieves the computer manufacturer, model, and amount of RAM. The information is outpu
|
|
This script gathers a brief hardware and software inventory from a computer, including operating system version, CPU speed, host name, PC serial number, etc.
|
|
Returns the following information for a computer: operating system version; available memory; uptime; total physical memory; maximum clock speed; user name; operating system insta
|
|
Echoes the following information for a computer: computer name; operating system version; operating system build number; service pack number; amount of free memory; and location o
|
|
Lists basic information about the processors installed in a computer.
|
|
Lists the manufacturer, BIOS settings, and disk information for a specified computer. Data is output to Microsoft Excel.
|
|
Lists the manufacturer, BIOS settings, and disk information for a specified set of computers. Data is output to Microsoft Excel.
|
|
Returns basic information about a workstation, including such things as BIOS asset tag, processors, RAM and hard drive size, and programs installed.
|
|
Returns warranty information for most Compaq/HP machines on local host or remote systems.
|
|
Takes inventory using Track-IT inventory module. The frequency of running the audit is based on information in the file c:\trackitaudit.id (written by Track-IT) and a variable whi
|
|
Retrieves system information from the computers specified an array. The script appends the data to a .csv file which can be converted to a spreadsheet, and also gives you a status
|
|
Retrieves computer hardware and inventory information.
|
|
Lists information in an HTA (HTML Application).
|
|
Retrieves the serial number for a group of computers listed in a database (a database using the DSN "local").
|
|
Retrieves inventory information from multiple computers and then writes that information to a pre-created database.
|
|
Retrieves the serial number from a Dell computer, then connects to the Internet and displays the warranty information.
|
|
Gathers hardware and software information using Windows PowerShell. The code is integrated into an HTA. NOTE: The Software installed option only works with Windows XP.
|
|
Retrieves and saves hardware information to a text file.
|
|
Retrieves basic hardware and configuration information for a computer.
|
|
Retrieves detailed hardware and software information from a set of computers and then writes that information to a database. This script requires Powersmo, Pstools (available fro
|
|
Checks the processor load on a computer. Will work on computers that have multiple processors.
|
|
Uses WMI to get the current video resolution of a computer.
|
|
Archives log files from a Windows server to a Linux-based NAS appliance running SAMBA. The script maps a network drive to a SAMBA share (because WMI won't work here), looks for l
|
|
Controls local services based on flag taken from a UNIX database server.
|
|
Shows the connection state of all the network adapters on a computer.
|
|
Returns a list of users that have a file open on a computer. Results are written to an Excel workbook.
|
|
Lists information (including Process ID) for active network connections.
|
|
Pings a series of network devices and keeps a running log of their availability.
|
|
Checks to see if files matching a specified pattern (e.g., *.AVI) are running on a computer. The script can perform such tasks as detecting users accessing Outlook OST/PST files f
|
|
Pings a list of IP addresses located in a .txt file called addresses.txt. If the ping result is positive, the script establishes a Telnet session to the device (in this case, 3Com
|
|
Queries a broadband router for a WAN IP Address and, if needed, updates the address stored in the registry.
|
|
This script searches for a specified word in the contents of all the files in a specified directory. The script then reports the file names of all files that contain the target wo
|
|
Scans a text file for lines containing a specified string. When the script finds a line containing that string it will output the line to another file. This is great for searching
|
|
Returns the last x lines from a given text file.
|
|
Reads a text file line-by-line and stores those lines in an array.
|
|
Reads a text file from the bottom up, displaying lines in inverse order.
|
|
Reads a text file in a single operation.
|
|
I use this function a lot in debugging complex scripts, and also in creating a running log of events.
|
|
Code used to add logging to scripts.
|
|
This script creates a logfile in the format [YYMMDD-HHMMSS].log. The script also includes a function that outputs everything to both the screen and the logfile. I use it in almost
|
|
Creates a fixed-with log file. Rather than having users try to count characters required for a field, the script asks users for the values, does some simple validation, then write
|
|
Writes the user name, computer name, logon time, and logon date to a text file. The code should be added to a logon script and users must be given write-access to the text file.
|
|
Searches for and replaces text in a text file.
|
|
Scripting template for writing data to a text file.
|
|
Appends text to a text file, along with the day and time and the text's source URL.
|
|
Reads a text file and matches the contents against a regular expression. Matches are replaced with a specified keyword or phrase.
|
|
Sample script demonstrating how to write information to a text file.
|
|
Replaces specified text in a text file. If changes are made the original file is backed up before the modified file is saved.
|
|
Copies specified lines from one text file to another. The lines to be copied are taken from an input file.
|
|
Numbers each line in a text file.
|
|
Sample script that appends a blank line, and then the current date and time, to a text file.
|
|
Reverses all the lines in a text file, making the first line the last line, the last line the first line, etc.
|
|
Adds a line to the beginning of a text file and simultaneously deletes the last line of that file, ensuring that the file never contains more than 20 lines.
|
|
Removes duplicate lines from a text file.
|
|
Retrieves the name of the logged-on user from Active Directory, then assigns that name to the Microsoft Office user name.
|
|
Displays installed system drivers in an HTML file.
|
|
Reports the version of DirectX installed on a computer.
|
|
Disables standby mode on the local computer.
|
|
This script logs off, shuts down, reboots, or powers off (depending on the selection) the computers listed in the Server array. The script prompts the user for the action they wan
|
|
This script reboots the local computer.
|
|
Lists the display name and path of all the programs that are set to automatically run on system startup.
|
|
Creates a shortcut in the Quick Launch bar for shutting down the computer.
|
|
Reboots a remote computer. This script only works remotely; on local machine it generates SWbemObjectEx error, which is by design.
|
|
Sends email notification when the local administrator account logs into a computer.
|
|
Logs the current user off of a computer. Warning: If you run this script without parameters, it logs you off your computer.
|
|
Shuts down four sample computers on the network. The second half of the script shows you how to abort the shutdowns.
|
|
Restarts the local computer.
|
|
Reboots the specified computer.
|
|
Logs off the user logged-on to a computer.
|
|
Reboots the remote computer specified by the user. Prompts for a user name and password to facilitate rebooting computers in untrusted domains or workgroup environments.
|
|
Displays a .JPG file at startup. The actual file displayed in based on the screen resolution of the computer.
|
|
Prompts you for a computer name or portion of a computer name (the * wildcard is supported). The script then reboots all the computers in Active Directory that match the criteria.
|
|
Uses the PSShutdown.exe command to remotely unlock a workstation. The basic code is to run PSShutdown as follows:
psshutdown.exe -accepteula -f -o \\remotehost
|
|
Determines system uptime.
|
|
Prints all the .RTF files in a folder as .PDF files. Requires Adobe Acrobat
|
|
Enables automated password entry for the RunAs command.
|
|
Demonstrates how to use an environment variable, formatted like the PATH variable to include VBScript code, and then execute scripts in an external process , all without having to
|
|
Runs multiple instances of a specified batch file.
|
|
Changes the icon of a Windows PowerShell console window.
|
|
Determines the path to the currently-running HTA.
|
|
Accepts a command-line command (such as dir c:\scripts) and then displays the output in an Internet Explorer window.
|
|
VBScript command shell that enables you to interactively run VBScript functions and command-line commands. The shell executes all VBScript statements directly with the Execute() f
|
|
Determines the path to the currently-running script and records that information to a log file.
|
|
Runs a specified command against each computer listed in a text file.
|
|
Enables a batch file to run in a hidden window. Start the script using a command similar to this: \\uncpath\invisible.vbs \\uncpath\batchscript.bat.
|
|
Types in alternate credentials whenever the Run As dialog is activated. Useful for administrators who log on to their computer as a user but need to run administrative applicatio
|
|
Launches multiple instances of a script or command-line tool.
|
|
Launches a script or batch file multiple times.
|
|
Demonstrates how to re-invoke a VBScript script if that script is called using the wrong script engine.
|
|
Configures a script to run the next time the computer restarts. The script will only run on the next restart, not on future restarts.
|
|
Retrieves and displays information about the currently-running HTA.
|
|
This is a batch file that demonstrates how to capture the current date and time in a temporary file, then redirect this value to a log file. This is a useful addition to any batch
|
|
Sample script that uses a For loop to run the Ping command against all the computers listed in a text file. You can get creative with the script by having the loop run another bat
|
|
This script generates a random password of variable length.
|
|
Converts a date-time value into a string, using a specified format.
|
|
This script generates boilerplate code used in many scripts and then copies that code to the Clipboard. Simply open your script editor and paste! This saves time from having to ty
|
|
This script generates a random password or other string.
|
|
This script allows you to generate a GUID to ensure the uniqueness of a file name. The GUID can be used whenever a file needs to be created or renamed and you need to ensure the
|
|
This script will check whether or not a specified UNC path is valid.
|
|
Sends a message to a specific IP address on the network.
|
|
Writes out the local time in the format YYYYMMDDHHMMSS for sorting purposes. Good for prepending text log entries.
|
|
Retrieves the ANSI value of a specified character.
|
|
Displays a message box asking the user if he or she wants to continue, and then takes the appropriate action.
|
|
Script snippet that returns the current folder using Wscript.Name (instead of the FileSystemObject's GetFolder method). This is useful for scripts executed remotely, as GetFolder
|
|
Script that shows how to calculate time differences between two dates.
|
|
Demonstrates how to display information in an Internet Explorer window.
|
|
Binds to Active Directory using alternate credentials. This sample script hard-codes a username and password, but it would be possible to prompt the user for his or her credentia
|
|
Splits a file path into the folder name and file name.
|
|
Script that enables a batch file to run a command X number of times (5 in this example, but you could change this).
|
|
Pauses a script for a specified amount of time.
|
|
Sample script that includes three functions that allow passing information from a script to an Internet Explorer window. This example writes 2 text lines to 2 different windows.
|
|
Creates a YYYYMMDD string offset by 1 day from the day that is passed in. If nothing is passed in or if there is a problem converting what is passed, the script will produce the
|
|
Starting point for other scripts and provides a structure for longer scripts.
|
|
Generates a random, common-character password to meet at least three of four standard complexity requirements. The default password length is 8 characters, but this can be customi
|
|
Opens a script file and, at the end of the script, sets all objects to Nothing.
|
|
Uses functions to pre-declare commonly-used scripting objects.
|
|
Toggles upper- and lowercase for any text on the Windows Clipboard.
|
|
Template for multithreading Cscript or Wscript actions (in this case connecting to multiple computers).
|
|
KiXtart script that searches for the specified string from Windows error codes and lists the found matches.
|
|
Enables question an answer responses in VBScript.
|
|
Binds to a computer using alternate credentials. The script must be run under CScript.
|
|
Runs a script against a specified range of IP addresses.
|
|
Creates a scripting template that includes common functions and procedures.
|
|
Logon script template. Included are functions for mapping to network drives, connecting to network printers, checking domain group membership, and checking environment variable s
|
|
Scripting template for reading command-line arguments.
|
|
Sample script that demonstrates how to read values from the registry.
|
|
Saves command window output to a text file and then reads that text file.
|
|
Reads the contents of a text file and then copies that information to the clipboard.
|
|
Demonstrates how to automate a simple task from within a stand-alone script using SendKeys.
|
|
Function to remove all the special characters from a string.
|
|
Template script demonstrating functions useful in a logon script.
|
|
Demonstrates how to add a sleep function to an HTA by calling a one-line VBScript script.
|
|
Enables you to review or edit a specified line from a script. This makes it easy to respond to any error message that provides a line number.
|
|
Sample script that demonstrates the use of the ArrayList object in a script.
|
|
Uses Windows PowerShell to convert a WMI date value to a .NET DateTime value.
|
|
Sample HTA that creates a digital clock. Note that the only way to dismiss the sample clock is to terminate the Mshta.exe process.
|
|
Lists the last day of the month that precedes a specified date.
|
|
Sorts a text file using the .NET Framework ArrayList.
|
|
Sample script that uses the .NET Framework Stack to reverse a string.
|
|
Generates a random number using the .NET framework.
|
|
Uses the .NET Framework to generate a random decimal value between 0 and 1.
|
|
Reformats date-time values, adding leading zeros to months and days if required.
|
|
Uses the .NET Framework to generate a random integer in a specified range (in this case, between 1 and 100).
|
|
Sample function that converts a WMI date-time value into a normal readable format.
|
|
Converts a regular date-time value into the UTC date-time format used by WMI. Useful when working with WMI and event logs.
|
|
Sample script that uses the .NET Framework and the System.Collections.ArrayList class to sort an array.
|
|
Adds a dropdown menu -- including keyboard shortcuts -- to a Web page or HTML Application.
|
|
Checks to see if a specific WMI class exists.
|
|
Creates a new Microsoft Excel spreadsheet and lists all the WMI classes found on the local computer.
|
|
Creates a calendar to similar to the type created by the Unix cal command. The script accepts a month and year and returns a string formatted as a calendar page. This code can be
|
|
Sample script that converts an image file (such as .JPG) to ASCII art. For more information, see http://ps1.soapyfrog.com/2007/01/07/convert-images-to-text-ascii-art/.
|
|
Sample script that displays a yes-no message box using Windows PowerShell.
|
|
Sample script that captures the Windows PowerShell console as a text file. For more information, see http://ps1.soapyfrog.com/2007/01/06/console-screen-grabs-in-html/.
|
|
Mimics the function of the Like operator when working with string values. Currently uses only the asterisk wildcard character.
|
|
Shows how to open a text file using the CommonDialog control.
|
|
Shows how to save a text file using the CommonDialog control.
|
|
Demonstrates a method for converting an array to an array having distinct values. Optionally sorts the array in ascending or descending order, or randomly shuffles items in the a
|
|
Tracks script progress by updating information in an Internet Explorer window.
|
|
Creates a Dictionary object and then saves that information as an XML spreadsheet.
|
|
Copies the elements found in an ArrayList to a new array.
|
|
Appends the elements of one ArrayList into a new ArrayList.
|
|
Randomly generates a three-character, all-alphabetic password.
|
|
Determines whether a specified key or value appears anywhere within a sorted list.
|
|
Verifies that a proposed password meets complexity requirements.
|
|
Sample script that converts a collection into an array.
|
|
Sample script that creates a new array from specified items in another array.
|
|
Sample script that adds a new item to an array.
|
|
Sample script that finds the intersection between two arrays.
|
|
Sample script that creates a new array from the unique items found in two other arrays.
|
|
Sample script that creates a new array using only items found in 1 of 2 starting arrays. (Items found in both arrays are not be returned.)
|
|
Sample script that writes an array to a text file.
|
|
Sample script that reads array values from a text file.
|
|
Sample script that creates an array into a dictionary (hash table).
|
|
Sample script that adds a class to an array.
|
|
Sample script that returns a specified item (based on index number) from an array.
|
|
Creates a new array by returning all but the last N items (e.g., the last 3 items) in a starting array.
|
|
Sample script that assigns a maximum value to any items in an array that exceed that value.
|
|
Sample script that checks to see if a specified item exists in an array.
|
|
Sample script that creates an array of a specified size, assigning a specified value to each item in that array.
|
|
Sample script that calculates the average (mean) of all the items in an array.
|
|
Uses a WMI query to retrieve service information, placing the retrieved information in an array.
|
|
Reads values from a comma-separated values file and then places those values in a two-dimensional array.
|
|
Saves the values in a two-dimensional array to a comma-separated values file.
|
|
Creates a two-dimensional array from information in a Dictionary object.
|
|
Displays a progress bar in an HTA.
|
|
Sample script demonstrating how variables can be passed between a batch file and a VBScript script; this enables you to work around the problem of environment variables whose valu
|
|
Creates a graphical timetable for a one day-on, three days-off schedule.
|
|
Adds the corresponding elements of two arrays in a third array.
|
|
This script creates a two-dimensional array from a comma-delimited or tab-delimited list; you can copy a group of cells from Office Excel or copy a list from a .csv file. Useful f
|
|
Backs up all Group Policy Objects. Edit YOURDOMAIN.COM as appropriate and you will have the ability to easily restore a GPO if needed using GPMC.
|
|
Cleans the Zotob from a system via the file system, registry, and service removal.
|
|
Lists SAV exclusions for LANDesk anti-virus software.
|
|
Checks the registry for viruses configured to run each time Windows starts.
|
|
Detects the current version of Microsoft Defender and installs a newer version, if needed.
|
|
Checks the status of anti-virus software as reported by the Security Center. Requires Windows XP Service Pack 2 and anti-virus software compatible with Security Center.
|
|
Monitors for the creation of the winzip_tmp.exe virus file. As soon a swinzip_tmp.exe is created the script deletes the file and all the files and registry entries associated with
|
|
Updates the anti-virus software on a computer.
|
|
Maps two drives, searches one of the drives for an anti-virus update, and then applies the most recent update.
|
|
Enumerates all the DCOM applications and their corresponding Application IDs and Default Authentication levels. Also enumerates access and launch permission for DCOM applications.
|
|
Enumerates and configures the default Authentication and Impersonation levels for DCOM.
|
|
Applies special file permissions to the Program Files folder, enabling restricted users to run applications that require full control.
|
|
Creates a shared folder and assigns share permissions to it. Please note that any existing share permissions will be removed and only those you specify will be assigned.
|
|
Lists access permissions for a folder.
|
|
Enumerates access permissions for all the subfolders in a specified folder.
|
|
Uses ADsSecurity to retrieve the security descriptor for the file C:\Testfile.text.
|
|
Grants a user full control over a file or folder. Just edit the marked field with the desired file or folder path.
|
|
Removes all the permissions to a file or folder for the specified user. Just edit the marked field with the desired file or folder path.
|
|
Creates another script that will create shares with permissions on other machines and create a CSV file that shows you the permissions.
|
|
Adds an IP address to the IPSec blocked filter list.
|
|
Creates shortcuts that enable you to be logged in as an administrator, albeit with limited rights. This script requires the DropMyRights utility available from http://msdn.microso
|
|
Uses the VBScript Encoder object to encode one or more VBScript scripts. Just drag and drop files to encode onto Encoder.vbs, and encoded copies (with a .vbe extension) will be c
|
|
Submits a single download job to BITS from the command prompt. Requires BITSADMIN.EXE, part of Windows XP Service Pack 2 Support Tools.
|
|
Creates BizTalk user accounts.
|
|
Collects latency data from Citrix WMI and Citrix COM objects.
|
|
Runs the Citrix Server Qfarm command and logs the results.
|
|
Monitors the percentage of available Citrix Server licenses currently in use.
|
|
Reports session idle information for the servers in a farm. The reports includes the following: server name; user name; session name and type; session ID; client name; session sta
|
|
Returns a list of applications published on the local Citrix Presentation Server.
|
|
Creates and activate several DHCP scopes on a Microsoft DHCP server.
|
|
Parses the DHCP audit log, looking for instances when IP addresses were assigned.
|
|
Backs up all the DHCP zones on a server, including Active Directory-integrated zones. Requires DNSCMD.exe in the current directory or path.
|
|
Creates a backup of all the DHCP scopes on a server, generating a CABS folder to use for storing the output. Note that the DHCP Service will stop and start during this operation.
|
|
Helps to trace workstations that do not belong to specific domains and gets an IP address from the DHCP server.
|
|
Scans a DNS server and gathers information in a log file for easy viewing.
|
|
Returns IP addresses for all the records on a DNS Server.
|
|
Creates a primary DNS zone named MyNewPrimaryDNSZone.
|
|
Checks an SNA connection in Host Integration Server, and writes a record to the event log if the status is not active.
|
|
Displays connection information and status.
|
|
Perl script that emails IAS Access event log entries recorded during the previous 24 hours.
|
|
Retrieves ISA Server URL sets.
|
|
Retrieves all ISA Server array rules.
|
|
Queries Active Directory for a list of Network Appliance Files and then queries each one for home folders that exceed 100MB in size, outputting the results to Excel. These server
|
|
Searches a Lotus Notes server for a specified user account and then reports back attribute values for that account.
|
|
Assigns an advanced client to a specific SMS site. Replace MACHINENAME and SITECODE with the appropriate values.
|
|
Retrieves information about an SMS client. This HTA needs to be run from the SMS primary site server.
|
|
Displays objects found in a SQL Server database.
|
|
Deletes old SQL backup files. The script is typically run using a timed DTS package, but this could be also be used for deleting any files within a VBScript script.
|
|
Checks for a SQL client connection and creates one if it does not exist.
|
|
Programmatically backs up to file all the databases on a SQL Server computer. You could do this through the SQL GUI, but scripting is way too cool to not let it handle this.
|
|
Displays information about all the databases on a specified SQL Server. Displays output in an HTML window.
|
|
Displays rows from specified table in a given database on a SQL Server. Displays output in an HTML window.
|
|
Lists the database files currently connected to a SQL Server 2000 instance.
|
|
Queries a SQL Server table and searches a column for a specific user-defined string. The script then displays the result set in message boxes (or screen if using CScript).
|
|
Sample class object used to access and manipulate SQL Server databases information.
|
|
Extracts large object (CLOB, BLOB, etc.) from a SQL Server database. Long text and image data stored in databases is not viewable with many database tools; instead, this informati
|
|
Creates a System DSN for connecting to a SQL Server database.
|
|
Creates a table in a SQL Server database.
|
|
Uses SQL 2005 SMO Objects to lists all the databases on a SQL Server computer.
|
|
Shows used space, available space, and maximum space for a SQL Server's log files and data files.
|
|
Retrieves the status of the last SQL Server job run on a set of database servers.
|
|
Traverses a VSS database, completely removing any item which has been deleted but not destroyed.
|
|
Backups to a file all VSS projects on a Visual Source Safe server. Just replace the VSS constants and paths to match your environment and off you go!
|