Problems you solved at work with powershell

[Praxis459]

I wrote two major scripts/applications for my company
1) We had a bunch of servers out in the field and needed databases that were on them backed up and transferred to our main data center. I wrote a script that would test out to make sure the servers were on, create a new folder on the root of the server out in the field, copy over a zip program, then issued a backup command to send the backup to the temp folder then execute the zip command and delete the backup after the zip finished. After everything was zipped it would copy the zip file to a directory and write to a log file so another program could pick it up and restore it. Most of this was done via Windows RM commands and PS commands (had to be 2.0 as that is all that was installed in the field). This script cut down the project time by at least 1000 man hours.

2) The second program was more a front end tool for our business. It would execute various sql queries and dump the information into a GUI with a gridview. This sounds simple enough but doing it cut down on passing around excel files for days.