August 2007 - Posts
From the Microsoft System Center SMS and MOM Team Blog:
http://blogs.technet.com/smsandmom/archive/2007/08/23/system-center-operations-manager-2007-management-pack-update.aspx
Update to address fixes and enhancements:
• OnDemandDetection for threshold monitors.
• Ability to override Priority / Severity settings.
• Alert rules/monitors added for Batch response.
• Added Knowledge for rules and monitors.
• Fixed Distributed Application health rollup state.
• Top customer impacting bugs found post-RTM
The updated file list includes:
• Microsoft.SystemCenter.2007.mp (6.0.5000.28)
• Microsoft.SystemCenter.Internal.mp (6.0.5000.28)
• Microsoft.SystemCenter.Library.mp (6.0.5000.28)
• Microsoft.SystemCenter.OperationsManager.200.mp (6.0.5000.28)
• Microsoft.SystemCenter.ServiceDesigner.Library.mp (6.0.5000.28)
• Microsoft.SystemCenter.WebApplication.Library.mp (6.0.5000.28)
• System.Health.Library.mp (6.0.5000.28)
Link to download the Management Pack Update
http://www.microsoft.com/downloads/details.aspx?FamilyID=0d7fc438-4eb9-496e-a664-54d43a577576&DisplayLang=en
I've seen Don Jones and Jeffery Hicks at their two day class at Windows Connections Conference back in 2006.
They were great people, more than willing to help every one in the class and the class was excellent as well. It was the most worth while activity I've done at a conference like that. Anyways I noticed this deal for their PowerShell 101 Class-On-Disk and wanted to share it with the community before the deal is gone.
For the month of August or till supplies run out like their blog entry states they are offering with a coupon code PowerShell 101 Class-On-Disk for $49 bucks.
UPS just delivered mine today. The Class-On-Disk looks like a very nice package. I'm looking forward to getting past the first few sections to get to the debugging etc. Links to cheap training are below:
Blog entry with coupon code
http://blog.sapien.com/current/super-summer-sale-on-self-paced-shell-schooling.html
PowerShell 101 class on a disk with coupon $49!
http://www.scriptingoutpost.com/ProductInfo.aspx?productid=DJV-PS101
PowerShell 101 class on a disk plus PowerShell TFM Book with coupon $89.
http://www.scriptingoutpost.com/ProductInfo.aspx?productid=BK-SA.COM-PS101
Enjoy!!!!!!!!!!!! 
I took a week off last week from work, blogging etc. I just played guitar, and played with my kids at the neighborhood pool. It was very nice and needed break.
One item that I noticed on several other blogs from last week is the OpsMgr 2007 Override Explorer utility that is on Boris Yanushpolsky blog. Check out his blog here, there is already some good info on OpsMgr 2007 and I'm sure there will be lots more to come. http://blogs.msdn.com/boris_yanushpolsky/
Have a great week. WOOT!
TechNet Webcast: End-to-End Service Monitoring with System Center Operations Manager 2007 (Level 200)
Date: Wednesday, August 08, 2007 11:30 AM Pacific Time (US & Canada)
From Microsoft Web site:
Summary
In this webcast, we discuss some common challenges that customers have in monitoring distributed applications, and we explain how Microsoft System Center Operations Manager 2007 addresses those issues. Our focus here is not about how you develop a service-oriented architecture (SOA) or how you design distributed applications, but rather how to monitor them. Next, we look at how you can design the monitoring of your distributed application and we also explore monitoring individual components.
Link to the event:
http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032345598%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e
Get a Simpsons style picture of yourself. Just upload a head shot of yourself and make a few selections.
Just go to the following web site.
http://simpsonizeme.com

After using the script in part one, you notice a server that is dumping a large number of performance counters into the OnePoint database, use this script to figure out what entries its adding to the OnePoint database. This script will output the Performance Counters for one server that you specify for the past two hours sorted by the sampled time.
-- Scott Moss
-- Part 2 what Perfmon counters?
-- Get performance Counters for a single server for the past 2 hours
-- from the onepoint database.
Declare @Server varchar(30)
SET @Server = 'YOURSERVERNAMEHERE' -- a server name
select ComputerName, PerformanceInstanceName, PerformanceObjectName, PerformanceCounterName,
TimeSampled, SampledValue
from dbo.SDKPerformanceView
where (DateDiff(hh, TimeSampled, GetDate()) <= 2) AND ComputerName=@Server
Order by TimeSampled ASC -- END SQL SCRIPT
Ever wonder what performance counters are being captured in the OnePoint Database? This SQL script will shed some light as to what is actually being inserted into the one point database. This script specifically pulls out what has been put into the db for the past two hours using the SDKPerformanceView.
-- Scott Moss 8/1/07
-- Part 1 what Perfmon counters?
-- Get count of performance counters per computer name in onepoint db
-- for the past 2 hours, sorted by number of Performance Counters
select ComputerName, COUNT(*) AS PerformanceCounterCount
from dbo.SDKPerformanceView
where (DateDiff(hh, TimeSampled, GetDate()) <= 2)
GROUP BY ComputerName
ORDER BY PerformanceCounterCount DESC