This is a useful script to call another script within VBScript. Using the Run method within the WshShell object allows you to call any script […]
Continue readingReset the auto increment number in a MySQL table
To reset the auto increment number in a MySQL table, simply run the following command: ALTER TABLE table AUTO_INCREMENT=1 Replace the number 1 with the […]
Continue readingFinding Duplicate Rows in SQL
I used this to solve a problem today. // Finding duplicates in a table SELECT email, COUNT(email) AS NumOccurrences FROM users GROUP BY email HAVING […]
Continue readingEnable Remote Desktop Remotely
For Windows XP: 1. Go to Start, Run and type: regedit 2. In regedit, click File, Connect Network Registry 3. Enter the name or IP […]
Continue readingSend an Email with VBScript
Another really easy script. This script will send an email. As I automate tasks, I like to build an html log file and email the […]
Continue readingSend Ctrl-Alt-Delete in a remote desktop session
Ctrl + Alt + End will send Ctrl + Alt + Del to a remote PC. Alt + Page Up will Switch between programs (Alt […]
Continue readingHow to Write to the Windows Application Log Using VBScript
This script helped me configure an enterprise monitoring system. I created little events in the Windows event log and monitored the events using the syslog […]
Continue readingT-SQL Stored Procedure Research
Whenever I am researching stored procs, I try to remember the following queries: Search within a stored proc. Useful when trying to understand what stored […]
Continue readingRetrieve Model and Serial Number with VBScript
Simple script to retrieve information about a workstation or hardware. strComputer = “.” Set objWMIService = GetObject(“winmgmts:” _ & “{impersonationLevel=impersonate}!\\” & strComputer & “\root\cimv2”) Set […]
Continue readingPass Parameters from a Windows Batch Script to VBScript
It can be very useful to pass parameters from a Windows Batch Script to VBScript. For this to work, a user will pass parameters to […]
Continue reading