I needed a list of all servers listed in AD. There are many scripts out there that do this, but they didn’t quite fit my […]
Continue readingSQL Server CPU Utilization
Some helpful SQL stats from this article. — From the SQL Server Performance Dashboard (sys.dm_os_ring_buffers) — Query CPU utilization for each four minute intervals declare […]
Continue readingList all Documents in SharePoint
I’ve used these queries for years, they come in handy when planning growth or a migration. A quick Google search will find many more queries […]
Continue readingSetup SSH Keys Between Two Linux Servers
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 readingUsing 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 reading