SCC Health Check Reports Management Pack V2 !

This is the version 2 of the SCC Health Check Reports Management Pack released previous month.

OpsMgr Database Hygiene: SCC Health Check Reports Management Pack by Oskar Landman & Pete Zerger

This version is a follow up based on feedback on the first version.

Apart from more knowledge and links added we have also wrapped up almost twice the amount of reports in this version!

Version 2

A quick review on all reports in this version: New additions!

Report Name	Queries Database
Agents - Agent Hotfix Report (OM)	OperationsManager
Agents - Agents Missing Hotfix Report (OM)	OperationsManager
Agents - Down Agents (OM)	OperationsManager
Alerts - Alerts Closed by Specific User (DW)	OperationsManagerDW
Alerts - Alerts Closed by User [Count] (DW)	OperationsManagerDW
Alerts - Alerts Closed by UserID (DW)	OperationsManagerDW
Alerts - Number of Alerts per Day (OM)	OperationsManager
Alerts - Top 20 Alerts By Alert Count (OM)	OperationsManager
Alerts - Top 20 Alerts By Repeat Count (OM)	OperationsManager
Config Churn - Discoveries Last 24 Hours (DW)	OperationsManagerDW
Config Churn - Modified Properties Details Last 24 Hours (DW)	OperationsManagerDW
Events - All Events Count By Last 7 Days (OM)	OperationsManager
Events - Most Common Events by Number and Publisher (OM)	OperationsManager
Events - Top 20 Computers Generating the Most Events (OM)	OperationsManager
Misc - Groups Report (OM)	OperationsManager
Misc - Infrastructure Overview (OM)	OperationsManager
Misc - Management Packs (OM)	OperationsManager
Misc - Operational and Datawarehouse Usage Report (OM) - (DW)	Both
Misc - Outage and Maintenance Report (DW)	OperationsManagerDW
Misc - Run As Profiles (OM)	OperationsManager
Performance - Performance Inserts Per Day (OM)	OperationsManager
Performance - Top 20 Computers By Perf Count (OM)	OperationsManager
Performance - Top 20 Performance Insertions By Perf (OM)	OperationsManager
Performance - Top Performance Baseline Generating Rules (OM)	OperationsManager
State - Noisiest Monitors (OM)	OperationsManager
State - Old State Changes Not Groomed (OM)	OperationsManager
State - State Changes Per Day (OM)	OperationsManager

We have also changed the documentation a little because some people reported authentication problems when running the Ops DB reports.

Feedback

Again the idea behind this MP is a real community MP. If you have feedback or additions please contact Oskar Landman or Pete Zerger and we are happy to add them to version 3! Of course your additions will be recognized by the community it the way of special credits!

The feedback can be in several ways of adding knowledge like links to good articles to fancy SQL queries to retrieve data out of the DB. Also if you feel we are missing crucial reports and don’t have the sql query to retrieve the data let us know we always like a challenge ;-)

Besides this we have also received rules and monitors to monitor the health of your environment more closely. We are currently looking if we will fit this in version 3 or make an additional MP accompanied by the reporting MP.

Future

The future of this MP will depend on the feedback and additions received. Although I can already tell you version 3 will be released and in here we will consolidate the reports to bring down the number of reports which will make it faster to check up on your environment! Because many of them are related.

Special Credits

Special thanks to Kevin Holman for his great feedback and as a query resource ;-)

And of course Pete Zerger for his reports and query additions! Always fun and looking forward to version 3! maybe we can do this one in German ;-)

The writers of this MP are not responsible for any problems derived from the MP although the MP has been tested on different installations and there are no known issues. There is always a possibility things are different in your environment so as always use the documentation and make sure that you know what you are doing.

The MP can be downloaded at the MP catalog.

Have Fun and feel free to comment or send in your feedback!

Comments
Social
Related

Comments (13) - Comment RSS

View all 13 comments

Oskar Landman wrote: on Jul 16, 2010 06:24 PM

Sameer,

Did you named the data source OperationalDatabaseMain ?

I believe it is case sensitive.

Permalink | Report Abuse

Sameer wrote: on Jul 19, 2010 09:23 AM

Hi OsKar,

Yes, I did name it OperationalDatabaseMain. I just copy pasted of what you had in the document.

Edit-

OK, I checked on the name. In the document the name is supposed to be "OperationalDataBaseMain" I tried to change this name to "OperationalDatabaseMain" as Oskar advised. But still its giving me the same error.. :(

Permalink | Report Abuse

Layne wrote: on Jul 21, 2010 05:15 PM

Sameer, even though I'm using R2 I had the same error as you. I'm not sure if this will help you, but I had copied the connection string from the Data Warehouse Main datasource and changed the initial catalog. However, I needed to remove the Integrated Security=SSPI before the reports would work.

Permalink | Report Abuse

elb01pd wrote: on Jul 29, 2010 04:23 AM

Write a comment...

Permalink | Report Abuse

elb01pd wrote: on Jul 29, 2010 04:29 AM

hello, I'm using R2 as well and had the same error. I did the same as Layne and I got 6 of the reports working. For the rest of the reports I get the known error.

Permalink | Report Abuse

new2scc wrote: on Jul 29, 2010 07:20 AM

Oskar/Pete,

One alert report i've been struggling badly with and believe it would be VERY useful to have is a report to show all critcial alerts which are in resolution state NEW for > 24 hrs, which can be run for the previous week/month or whatever timeframe.

The purpose is that our organisation is introducing internal service level agreements were all critical alerts should be acknowledged within one working day. Therefore we need to be able to run reports to check what alerts fell outside the SLA, and therefore know the service/service owner who needs to address the issues. In my SCOM deployment I have created additional resolution states of Acknowledged (1), Work In Progress (2) ontop of the default New (0) and Closed (255) states.

At first glance I thought this would be quite straight forward but being a bit of a novice and the more I looked into it, the more difficult is seemed to achive (i posted about this on several sites and looked at others eg http://social.technet.microsoft.com/Forums/en-US/operationsmanagerreporting/thread/b13d7b90-193e-4633-b968-caaafb153798 - I think the problem lies in how to calc the correct time in a particular state since it seems to raise another entry for the alert with the changes resloution state.

If you have a sample SQL to do this it would be great if you could send me it and if you felt it was worth including in your V3 MP. Ideally if you could run a report to show alert Name/desc, Date/time created, Date/Time resolved, Lenthg to time in state (for NEW), closed By, Owner where you could maybe specify via params time period eg previous week/monthetc...

Anyway thats my suggestion - I hope it makes sense and if you (OR ANYONE ELSE) had any ideas of a SQL script which I could work with to get me going in the meantime I'd greatly appreciate it!!...

Many thanks

PS Had emailed this but not sure if you got it!!

Permalink | Report Abuse

elb01pd wrote: on Jul 29, 2010 08:22 AM

Everything is fine now, I had to tick "Impersonate the authenticated user after a connection has been made to the data source" as well.

Permalink | Report Abuse

Scom4v wrote: on Sep 28, 2010 05:33 AM

Hi,

I have created the DataSource and Imported the MP but I have only 2 reports in the SCC Health Check reports folder :

Alerts - Alerts Resolved Closed by UserID (DW)

Misc - Management Packs (OM)

Thanks,

Abder

Permalink | Report Abuse

new2scc wrote: on Mar 21, 2011 07:10 AM

Hi, just wondering if there is any news of Version 3 being made available and what new reports etc may be included?...

Cheers

Permalink | Report Abuse

Blake wrote: on Sep 14, 2011 04:14 PM

I hate to beat a dead horse, but I'm still getting similar errors when I run any of the OM reports. The DW reports work fine.

I enabled remote errors on my SQL Reporting Server, so I have a little more detail. For instance when I run the Agents - Agent Hotfix Report (OM) report, I receive the following error:

An error has occurred during report processing.
Query execution failed for dataset 'OperationalDataBaseMain'.
Invalid object name 'MT_HealthService'. <--- REMOTE ERROR!!!!

Any ideas? I'm still digging. If I find the answer I'll repost; hopefully someone else has already crossed this bridge.

Permalink | Report Abuse

Who Viewed

Who Reviewed