Our winner for week 7 is Bob M. After much troubleshooting effort and discussion here in the OpsMgr forums (see full discussion here) Bob was able to perfect a scripting effort started by the talented Stefan Stranger [MSFT] to raise an alert in OpsMgr 2007 or SCE when databases have not been backed up recently. I know several people who were using Bob's solution the week he published. Here is Bob's full accounting of the solution, which would be useful an every environment using SQL monitored by OpsMgr.

OpsMgr Script: SQL DB Backup test alerting when it shouldn't

This script would go nicely into a 2-state monitor in OpsMgr. For steps on how to do this, see How to create a Script-based 2-State Monitor

Well done Bob! Your name goes into the hat for the grand prize drawing at MMS 2010 in Las Vegas!

SPECIAL THANKS TO OUR SPONSORS

We want to give a special shout out to proud Gold Sponsor Quest Software, who helps make all of this possible. As we've said in the past..great company with great people we've enjoyed working with over the years. They're doing some truly amazing things in the System Center space, and not just with Operations Manager 2007. They have cross-platform solutions for ConfigMgr 2007 and even auto-provisioning solutions for  SCVMM and Hyper-V, and much more.

Click the banner below to check out Quest Management Xtensions (QMX) Solutions for System Center

Details on the POST OF THE WEEK

Want to know how your contributions can be considered for the post of the week? Read more HERE.

Previous Installments of POST OF THE WEEK

• WEEK 6: POST OF THE WEEK (David Allen)
• WEEK 5: POST OF THE WEEK (Oskar Landman)
• WEEK 4: POST OF THE WEEK (Tommy Gunn)
• WEEK 3: POST OF THE WEEK (Oskar Landman)
• WEEK 2: POST OF THE WEEK (Stefan Koell)
• WEEK 1: POST OF THE WEEK (Andreas "Tenchuu" Zuckerhut)