SSH Keys will allow data to move between two Linux servers without first prompting for a login. This is useful if you want to automate […]
Continue readingAuthor: kevin
Using VBScript to Kill a Process in Windows
After listing a process, you may want to kill or terminate a process: strComputer = “.” strProcess = “‘iexplore.exe'” Set objWMIService = GetObject(“winmgmts:” _ & […]
Continue readingUsing VBScript to List Processes in Windows
Just like ps, this VBScript will return the running processes. Just like using Task Manager. Very simple. strComputer = “.” Set objWMIService = GetObject(“winmgmts:” _ […]
Continue readingList Scheduled Tasks from a Windows Server
This script will query a server and output a list of scheduled tasks as a csv (Excel) file. This file is useful when auditing servers. […]
Continue readingInside Microsoft’s Data Centers
Check out this great Gizmodo article about Microsoft’s Cloud computing data warehouses. Microsoft racks servers in shipping containers and can ship and install the containers […]
Continue readingDisplay Process List Using VBScript
This great VBScript script will display running processes on a Windows workstation. The script queries the Win32_Process from a WMI Object using ExecQuery then loops […]
Continue readingMove Your Mouse Using VBScript and Excel
This script uses the GetMessagePos and SetCursorPos Windows API functions to move your mouse. The script will first get the current position of the mouse […]
Continue readingHow to Run a Script within VBScript
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 reading