Posted by: Colin Smith
Database Monitoring, Monitoring, Powershell, Scripting
I am getting back into writing my monitoring application in powershell and I have made some progress over the last few days. I have figured out my issue with getting the backup dates and times inserted into my monitoring database and also not entering the information multiple times if I already have an entry for that day for the full backup if the database is using the simple recovery model.
Then I wanted to develop a new script that would allow me to add a new instance to monitoring very quick and easy. It took me about 40 lines of ode but man it really does work great. The script will ask for some simple inputs like hostname, instance name, do you want to monitor it, who is the Customer, Test or Prod Instance, so really everything in the monitor and instance tables. Then it goes and inserts the data in the appropriate tables and also gets the instance identifier from the instances table before inserting it into the monitor table.
Getting ready to put this in place with the basic functionality and then add features as I go.