|
|
 
0 |
Hey everyone, Tommy here: Sorry the POTW for week 10 (week ending Feb 6th) is a bit late. I shared my vote and asked if I could write up this one and then promptly went on vacation. And because I want to give you some background, this post is going to be a bit longer than most POTW.
The winner this week is being recognized not for one piece of work but two. Seemingly small bits of effort, but important, as they were answers to questions that have been around for quite a long time in the life of Operations Manager 2007. There are two OpsMgr questions for which the answer has always led to a SQL query, leading one to believe these questions could not be answered with a PowerShell script. In fact in one case, I heard second hand that a MS person said they didn't think it was possible to solve one of these challenges with a PowerShell…only SQL queries directly on the OperationsManager database.
Why does it matter? Well, accessing SQL database puts you closer to your data, where you might accidentally hit a wrong key or something and unintentionally do some harm. And some DBAs won't let you get on the console of their SQL server, so you're just stuck.
The first question was asked by me in the forums here at SCC. My question:
How can I retrieve a list of the most common alerts (both rule and monitor generated) in PowerShell?
For the original discussion, see Most Common Alerts (both rule and monitor-generated) in Powershell).
I have seen a SQL query for this passed around for awhile, but never PowerShell. I asked the questions and I got my answer…and it was a correct answer! The guy who answered the question and the week 10 winner and future MVP (hint hint Microsoft) is Andeas "Tenchuu" Zuckerhut of Vienna, Austria. His answer seems simple in retrospect..hind site 20/20 as they say. I wouldn't have thought of this on my own. Here's the answer Tenchuu put together in this blog post…
OpsMgr: Most Common Alerts Report (rule and monitor generated) with Powershell FINALLY
The next question, also in the OpsMgr forum as SCC, was this:
How can I retrieve a list of uncommunicative (grey) agents in OpsMgr using PowerShell?
And again, Andreas comes through with what in retrospect seems simple, but clearly takes an advanced understanding of classes, properties, methods and other minutia of the OpsMgr SDK in order to put together the combination to get the desired result, which is covered in this post.
OpsMgr: Finding Grey Agents with Powershell
Andreas name goes into the hat (again) for the grand prize drawing at MMS 2010 in Las Vegas. Nice work dude! While I am thinking about it, here's another very cool script he put together when you need to do an emergency MP uninstall….use with caution and only if necessary.
Uninstall Multiple Management Packs including Relationships - PowerShell Script
There's more where this came from!
Andreas has done some really innovative work with the OpsMgr SDK and PowerShell. Read more of his adventures pushing the OpsMgr SDK to it's limits (and beyond) on his blog. Join us in congratulating Andreas for some really excellent work.
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