Requirements for a SCOM 2007 Health Check Script?
Home  » Requirements for a SCOM 2007 Health Check Script?

Requirements for a SCOM 2007 Health Check Script?
Posted: Sun, Jun 21, 2009 10:54 AM :: Rank: 85
Author
Points: 72684
Level: System Center Expert

Simon and I were discussing the need for a freely availble SCOM Health Check Script to make troubleshooting end user issues an easier task. Certainly this could be accomplished through Powershell with enough effort, and some pieces of such a script already exist in the public domain.

In order to do this, we would need to establish the requirements that would have to be addressed by the script. And it need not strictly be a health check script, but could be more of a data collection tool that would allow one to assess health where programmatic diagnosis may not be practical

SCOM Health Check Script Requirements:

  • Check proper database sizing based on monitored server / device count
  • Check SQL configuration against supported configurations / best practices 
  • Look for database latency - (event 2115) in the RMS / MS OpsMgr Event Log 
  • Collect agent count reporting to each MS & RMS
  • Retrieve recent warning and critical events from RMS OpsMgr Event Log 
  • What else????

Please add your thoughts to the list!

   Report Abuse
RE: Requirements for a SCOM 2007 Health Check Script?
Posted: Sun, Jul 12, 2009 6:25 AM :: Rank: 100
Author
Points: 72684
Level: System Center Expert

To provide a workspace for this, I think I'll try moving objectives and code snippets to a (temporarily) protected WIKI page that only volunteers will see. Or should we take this to Codeplex?

   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Mon, Jul 13, 2009 4:57 AM :: Rank: 96
Author
Points: 40804
Level: System Center Expert
It fitting for it to stay here on System Center Central forum as it is the users of this forum putting it to together.
   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Mon, Sep 21, 2009 7:44 PM :: Rank: 92
Author
Points: 190
Level: System Center Hero
Hey Guys,



Any update on this Health Check Script? Has it been completed yet?



Thanks, Tom
   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Mon, Sep 21, 2009 8:51 PM :: Rank: 73
Author
Points: 72684
Level: System Center Expert
TMartin, we are working at this diligently (Simon is leading the project) and making good progress. It's definitely taken a lot of thought. I expect it will be quite awhile before it is ready...but it is definitely in motion.



We will definitely keep you posted.
   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Fri, Sep 25, 2009 7:41 AM :: Rank: 83
Author
Points: 14136
Level: System Center Expert
Not sure if this set of SQL queries made it into the list from Kevin Holman's blog...he has a bunch over here, some of which would be great for a health check script. Here's a link:



http://blogs.technet.com/kevinholman/archive/2007/10/18/useful-operations-manager-2007-sql-queries.aspx
   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Mon, Nov 09, 2009 2:53 PM :: Rank: 79
Author
Points: 190
Level: System Center Hero
Hello Pete,

Thanks for your earlier response on the status. Is there a Beta version of this Health script? I would love to help out by testing what you have and provide any needed feedback.



Thanks,

Tom
   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Tue, Oct 05, 2010 10:58 AM :: Rank: 83
Author
Points: 35
Level: System Center Enthusiast
Actually the Distributed Application SCOM 2007 health model is lacking these checks. Wouldn't it be much neater to improve this DA using the script(s) mentioned.



Any progress on this project by the way?
   Report Abuse
RE: Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Tue, Oct 05, 2010 11:04 AM :: Rank: 71
Author
Points: 47503
Level: System Center Expert

Yes, it's done. Pete and Oskar created a reporting MP for OpsMgr to deliver all the queries in a friendly format. Download at SCC Health Check Management Pack Version 2

   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Fri, Sep 16, 2011 10:14 AM :: Rank: 66
Author
Points: 90
Level: System Center Enthusiast
Hi,

I am only able to generate a couple of reports, for Alerts closed by a specific user. All other end up with an error,

An error has occurred during report processing. Query execution failed for dataset "OperationalDatabaseMain'. Invalid object name 'MT_HealthService'.



KIndly help me fix this,



Regards,

Dhanraj
   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Fri, Sep 16, 2011 12:35 PM :: Rank: 53
Author
Points: 6358
Level: System Center Specialist
hi ,



can you tell me the version of SCOM you are using?



Also you may try to run the query below directly in SQL Server Management Studio against you OpsDB.



select bme.path AS 'Agent Name', hs.patchlist AS 'Patch List' from MT_HealthService hs

inner join BaseManagedEntity bme on hs.BaseManagedEntityId = bme.BaseManagedEntityId

order by path



This should provide you an output with the Agent Name and the Patch List.

Let me know if this works directly on your OpsDB



Cheers,

Oskar
   Report Abuse
RE: Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Sat, Sep 17, 2011 4:06 AM :: Rank: 75
Author
Points: 1140
Level: System Center Specialist

FaNtAsTiC work guys! keep it up.

Just to add...

Data sync issue - State Change data

Review ACS filter

Review most common Events and turn-off unnecessary

thanks.
   Report Abuse
RE: Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Sat, Sep 17, 2011 7:53 AM :: Rank: 68
Author
Points: 1140
Level: System Center Specialist

Fantastic Job Pete. Keep it up!

We are premier customers of Ms. I recently had a Scom Health Check program in our company. I would love to see a similar tool again.

Just want to add some...

Review ACS filter
Review most common Events and turn off unnecessary
Sort out those alerts which don't have proper name and especially descriptions

many thanks

   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Sat, Sep 17, 2011 3:23 PM :: Rank: 78
Author
Points: 13150
Level: System Center Expert
Pete and Oscar created the SCC Health Check Reports to bring many of the requests in this forum thread to life. You can find it at http://www.systemcentercentral.com/tabid/145/indexId/69990/Default.aspx
   Report Abuse
Re: Requirements for a SCOM 2007 Health Check Script?
Posted: Mon, Sep 19, 2011 4:26 AM :: Rank: 67
Author
Points: 90
Level: System Center Enthusiast
Hi Oskar,



Running on SCOM 2007 R2 with CU2. and yes the query you wrote worked giving me the CU version on all systems.



Regards,

Dhanraj



   Report Abuse

Home  » Requirements for a SCOM 2007 Health Check Script?
34 Items Page 1  [2]      
Top Contributors
Featured Members
Pete Zerger
Points: 72684
Level: System Center Expert
Tommy Gunn
Points: 47503
Level: System Center Expert
Simon Skinner
Points: 40804
Level: System Center Expert
Andreas Zuckerhut
Points: 30700
Level: System Center Expert
Stefan Koell
Points: 30179
Level: System Center Expert