It took me a while to find all the little pieces to put together a custom rule that used data collected through TSQL. In fact, because it took so much work to pull all the little pieces together, I wrote an article describing how I did it. This isn’t a wonderful new invention. It’s just the publication of a bunch of research. If you’re an Operations Manager expert, this isn’t for you. If you’re like I am, trying to find your way through the forest, this little bit of map will hopefully provide some assistance. Available at SQL Server Central.
Great post. I have made a couple of basic monitors using oBag but was having trouble transitioning in to making rules and how to map the oBag values back to the rule. Your article was more thorough than most I’ve come across.
-D