ASDK Tool a Day #6 - Phase Collections Report

This tool is an add on to an article I wrote previously. Every time I setup a patch task that went corporate wide, I had to notify all managers of each department ahead of time. Not only that, but I had to notify them of exactly which machines were getting hit and when. First few times, no problem. But it soon became a chore to go into 6 different consoles, to pull up phase collections, and then to copy and paste each phase, on each server to one spreadsheet.

That time sink started adding up. I needed a way to click a script and have an Excel spreadsheet, separated by sheets, labeled by day that the phase is to be deployed. This is the result.

In the script, replace the following with your server list:

svrName(0) = "servername1"
svrName(1) = "servername2"

Also, replace the following lines with the guids of your phase collections:
 

phaseGuid(0) = "6bff8864-10ef-492f-8201-f139fbfedf38"
phaseGuid(1) = "589f7865-454d-4a9a-bd59-185d667b5fd1"
phaseGuid(2) = "07b10950-e742-4fec-bf1e-836481a2cf0d"
phaseGuid(3) = "0a13c10a-5254-43b2-b5c7-09b210ea4bc3"
phaseGuid(4) = "def62865-ed36-4fd1-9893-6655e11a6afc"

Match the number of phase collections with your environment.

#6 down. 24 to go! I can do this, I can do this, I can do this....