|
|
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 |
Thank you for your rating!
|
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?
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
It fitting for it to stay here on System Center Central forum as it is the users of this forum putting it to together.
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
Hey Guys,
Any update on this Health Check Script? Has it been completed yet?
Thanks, Tom
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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.
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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?
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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.
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
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 |
Thank you for your rating!
|
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
|
|
| Your Reports Help Protect the Community |
|
The community depends on each member to help keep Answers a safe and positive place. Do your part by using the form below to report Q&A that violates the Community Guidelines.
|
Additional Detail(optional)
|
Report Abuse |
|