Automating Excel using Scheduled Tasks on Windows 2008 x64

I was recently asked to automate the process of parsing data from our Liebert UPS Administration web pages and dump it to an Excel spreadsheet so we could do some further analysis. We have a Windows 2008 x64 server with Office 2003 installed (for some legacy scripts). I tested this script on Office 2007 as well as Office 2003 and as it turns out this worked out quite well during the development stage. I create my Excel Com Object, open the spreadsheet, and select the worksheet:

VBScript to Uninstall Citrix Clients

A VBScript to uninstall older Citrix clients.

Stop, Start and Query the State of Local and Remote Windows Services with PowerShell

The following functions require you have Administrative privileges the to computers you are working with. These functions query the DisplayName property of the service, not the name. For instance, for the $DisplayName variable you would pass “Print Spooler” instead of “Spooler”.

PowerShell Script to Mount the Latest LeftHand SAN Snapshots

A PowerShell script to mount / unmount the latest LeftHand SAN snapshots of a volume for backup purposes.

PowerShell Script to Build a Custom WinPE v3.0 ISO

This script will build a custom WinPE v3.0 (Windows 7 based) environment and generate a bootable ISO. It gives you the ability to import a custom startup script (Autostart.cmd), custom wallpaper, custom drivers, registry files and custom Program Files to create a WinPE environment that works for you. You no longer have to waste the time trying to remember those pesky WinPE commands. Let the script do it for you!