Scott Moss at myITforum.com

I seemed to have missed this one.

Wednesday, September 26, 2007 9:30 AM Pacific Time (US & Canada)

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032348827&EventCategory=4&culture=en-US&CountryCode=US

http://blogs.technet.com/cliveeastwood/archive/2007/09/12/system-center-operations-manager-2007-resource-kit-tools-released-to-the-download-center.aspx

Some Operations Manager Resource Kit utilities. I'll just post the link to the other site that lists all eight utilities.
Enjoy!

I seemed to have missed these last week.

Windows Internet Naming Service Management Pack 2000, 2003 Management Pack for Operations Manager 2007

http://www.microsoft.com/downloads/details.aspx?FamilyID=bf9bda7f-6c4c-4a49-89b8-43126a75dd4e&DisplayLang=en

Microsoft Internet Security and Acceleration (ISA) Server 2004, and 2006 Management Pack for Operations Manager 2007

http://www.microsoft.com/downloads/details.aspx?FamilyID=6bf3b468-0473-41a1-9ea1-f3bcec7aa562&DisplayLang=en

Microsoft Windows Routing and Remote Access Service (RRAS) 2003 Management Pack for Operations Manager 2007

http://www.microsoft.com/downloads/details.aspx?FamilyID=7eb093db-c46b-4516-881d-7180c4e8f097&DisplayLang=en

Microsoft Windows Distributed Transaction Coordinator Management Pack for Operations Manager 2007

http://www.microsoft.com/downloads/details.aspx?FamilyID=10ea7b5b-1be3-4490-a1ea-973670a2d3b9&DisplayLang=en

MOM 2005 SQL Query to return Only Managed computers that belong to a Computer Group

This query returns only Agent Managed Computers names for a specific Computer group.
The results will not include Cluster Server names.

Props to my DBA buddy Nick DeAngelo for pointing me in the correct direction with the syntax.
The second bit of SQL code was borrowed from from Roy McCaw Blog http://rorymccaw.spaces.live.com see post Nov 2005.

-- Scott Moss
-- 09/08/07
-- Managed Computers that belong to a specific Computer Group
-- This query returns the Managed computers (Cluster Names will not be in this list)
-- that belong to a specific Computer group.

select [Name] from Computer
WHERE [IsConfigManager]=0 AND ManagedType = '2' AND
(idConfigManager IS NULL OR idComputer <> idConfigManager) AND 
IsAddedByServiceDiscovery = 0 AND [Type] <> 67108864

AND [Name] in (SELECT [ComputerName]
FROM [OnePoint].[dbo].[SDKComputerToComputerGroupView]
WHERE ComputerGroupName = 'YOUR COMPUTER GROUP NAME HERE')

The following SQL Script will return a count of the number of computers that belong to each computer group in your OnePoint Database.
This count includes all computers that is in the OnePoint Database, which includes Discovered, Unmanaged and Managed computers. This query can help you identify possible problems with a group or when troubleshooting why Computer group modifications in the Management console take a long time.

-- Scott Moss
-- 09/02/07
-- http://myitforum.com/cs2/blogs/smoss/default.aspx
-- Computer Group member ship counter
-- returns a count of discovered/managed/unmanaged computers

SELECT [Rule], COUNT(*) AS [Members]
FROM computertocomputerruleview
group by [Rule]
order by [Members] desc

Monday September 10, 2007 11:30 AM Pacific Time (US & Canada) 

TechNet Webcast: Client Monitoring with System Center Operations Manager 2007 (Level 300)

http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032348672%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

Session Summary

In this session, we show you some of the new features that we have built into Microsoft System Center Operations Manager 2007 so that you have a good understanding of what we are doing with client monitoring. We begin with a look at some customer challenges around client monitoring, and then we explain the Microsoft short-term and long-term visions for client monitoring. Next, we discuss our approach to making client monitoring as flexible as possible with features like Agentless Exception Monitoring, Aggregated Client Monitoring, and Critical Client Monitoring. We wrap up this session with a look at the management packs we are delivering specifically for client monitoring.

Presenter: Chris Avis, IT Pro Evangelist, Microsoft Corporation

Monday September 17, 2007 9:30 AM Pacific Time (US & Canada) 

TechNet Webcast: Reporting with System Center Operations Manager 2007 (Level 200)

http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032348786%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

Session Summary

In this session, we discuss the new features and benefits of reporting in Microsoft System Center Operations Manager 2007. We start with a look at the new functionality and features in Operations Manager 2007 Reporting. We cover the installation prerequisites, and then we walk through an installation of Operations Manager 2007 Reporting. Next, we examine the new reporting console integration and the new reports in Operations Manager 2007. We explore these new features and the data they enable you to report on. Finally, we wrap up the session by describing the report contents that are included in the new management pack format.

Presenter: John Baker, IT Pro Evangelist, Microsoft Corporation

This is just like Jason Harter SQL script, I just modified it to query the past 1 days worth of events.
To see the original go to http://jharter.spaces.live.com/blog/cns!39CE28DB5474A6C7!332.entry 

Reviewing this on a regular basis (depending on the size of your environment) will help you identify possible problems before they get out of control.

NOTE: Change "YOURSERVERNAME" to the name of a server that you'd like to review the events of.

-- MOM 2005 Event Storm past 1 day Part 2
-- Scott Moss 09/01/07
-- http://myitforum.com/cs2/blogs/smoss
-- OnePoint or SCDW MOM 2005
-- This is just like Jason Harter sql script, I just modified it to query the past day.
-- to see the original go to http://jharter.spaces.live.com/blog/cns!39CE28DB5474A6C7!332.entry

Declare @Server varchar(30)
SET @Server = 'YOURSERVERNAME'    -- type a server name       
 
SELECT     ComputerName, Message, COUNT(*) AS EventCount
FROM       SDKEventView
WHERE      (DateDiff(D, TimeGenerated, GetDate()) <= 1) AND ComputerName=@Server
GROUP BY   Message,ComputerName
ORDER BY   EventCount DESC 

This is just like Jason Harter SQL script, I just modified it to query the past 1 days worth of events.
To see the original go to http://jharter.spaces.live.com/blog/cns!39CE28DB5474A6C7!332.entry 

Reviewing this on a regular basis (depending on the size of your environment) will help you identify possible problems before they get out of control.

-- MOM 2005 Event Storm past 1 day Part 1
-- Scott Moss 09/01/07
-- http://myitforum.com/cs2/blogs/smoss
-- MOM2005 DBs OnePoint or SCDW
-- This is just like Jason Harter SQL script, I just modified it to query the past day.
-- to see the original go to http://jharter.spaces.live.com/blog/cns!39CE28DB5474A6C7!332.entry

SELECT  ComputerName, COUNT(*) AS EventCount
FROM  SDKEventView
WHERE   (DateDiff(D, TimeGenerated, GetDate()) <= 1)
GROUP BY ComputerName
ORDER BY EventCount DESC