The Multifunctioning DBA

May 27 2010   10:00AM GMT

Powershell Gui



Posted by: Colin Smith
Tags:
DBA
Monitoring
Powershell

A while back, about a year ago, I wrote some custom scripts to monitor all of our SQL Server instances for errors. I have a driver file that has all the information that the script needs in order to find errors on the SQL Servers and it just walks thru them and checks for any errors that I might care about. If it finds an error it sends out a page to the on-call DBA and also sends emails out to the DBA team about the error found. I also wrote a script called workit, because we are working the issue, that when run, will output the errors found on all servers that have errors. This script has many functions to aid in resolving any issues that are found and also stops the emails and paging about the error. Everything really works well, but I was watching a training video done by Buck Woody(blog | twitter) and he had an example of using the .net windows.forms assembly. That got me thinking that I could wrap my workit script into a GUI. I went out and found a quick basic tutorial on using the forms assembly and now I am hard at work building a gui around my scripts. This will allow me to let others, that are not so savvy with command line, to run this script and help us to resolve issues. This should be a fun project so I will keep you up to date on my progress. I love powershell because I can always find something useful and fun to do with it.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: