SCC Health Check Reports

SCC.HealthCheck.Reports :: 2.0.0.3 (Management Pack)

Reports to access Operations Manager 2007 R2 database health. Designed by Oskar Landman and Pete Zerger.

Summary

This management pack contains several reports for checking the health of your management group. The reports are divided into DataWarehouse and Operational Database Reports. Each Report contains a short description why these counters are interesting and if any additional parameters are required.

Configuration

Because of the MP also queries the Operational Database some additional steps are required for the reports to run correctly.

Please be aware that although the queries in this MP are tested the approach of querying the Ops DB directly is not supported by Microsoft.

To add the extra Shared Datasource to reporting please read the documentation accompanied by the MP.

Additional

This Management Pack is Designed by Oskar Landman And Pete Zerger. It is basically a wrap up of all queries out there to check your environment. The reports are created to easily and quickly identify any issues in your environment.

External

The MP is based on a blog series (6 Parts!) by Pete Zerger:

For additional queries and informational please refer to www.SystemCenterCentral.com.

Management Pack Elements

Reports (27)

 DisplayNameIDAccessibilityVisible
SCC.HealthCheck.Reports.V1.DW.Alerts.AlertsByUserIDAlerts - Alerts Closed by UserID (DW)SCC.HealthCheck.Reports.V1.DW.Alerts.AlertsByUserIDInternalTrue
SCC.HealthCheck.Reports.V1.DW.Alerts.AlertsClosedByUserAlerts - Alerts Closed by Specific User (DW)SCC.HealthCheck.Reports.V1.DW.Alerts.AlertsClosedByUserInternalTrue
SCC.HealthCheck.Reports.V1.DW.Alerts.AlertsClosedbyUserCountAlerts - Alerts Closed by User [Count] (DW)SCC.HealthCheck.Reports.V1.DW.Alerts.AlertsClosedbyUserCountInternalTrue
SCC.HealthCheck.Reports.V1.DW.Discoveries.DiscoveriesLast24HoursConfig Churn - Discoveries Last 24 Hours (DW)SCC.HealthCheck.Reports.V1.DW.Discoveries.DiscoveriesLast24HoursInternalTrue
SCC.HealthCheck.Reports.V1.DW.Discoveries.ModfiedPropertiesLast24HoursConfig Churn - Modified Properties Details Last 24 Hours (DW)SCC.HealthCheck.Reports.V1.DW.Discoveries.ModfiedPropertiesLast24HoursInternalTrue
SCC.HealthCheck.Reports.V1.DW.Misc.OutageAndMaintReportMisc - Outage and Maintenance Report (DW)SCC.HealthCheck.Reports.V1.DW.Misc.OutageAndMaintReportInternalTrue
SCC.HealthCheck.Reports.V1.OM.Alerts.NumberAlertsPerDayAlerts - Number of Alerts per Day (OM)SCC.HealthCheck.Reports.V1.OM.Alerts.NumberAlertsPerDayInternalTrue
SCC.HealthCheck.Reports.V1.OM.Events.CommonEvtsNumPubEvents - Most Common Events by Number and Publisher (OM)SCC.HealthCheck.Reports.V1.OM.Events.CommonEvtsNumPubInternalTrue
SCC.HealthCheck.Reports.V1.OM.Misc.DownAgentsAgents - Down Agents (OM)SCC.HealthCheck.Reports.V1.OM.Misc.DownAgentsInternalTrue
SCC.HealthCheck.Reports.V1.OM.Misc.RunAsProfilesMisc - Run As Profiles (OM)SCC.HealthCheck.Reports.V1.OM.Misc.RunAsProfilesInternalTrue
SCC.HealthCheck.Reports.V1.OM.Monitors.NoisiestMonitorsState - Noisiest Monitors (OM)SCC.HealthCheck.Reports.V1.OM.Monitors.NoisiestMonitorsInternalTrue
SCC.HealthCheck.Reports.V1.OM.Monitors.StateChangesPerDayState - State Changes Per Day (OM)SCC.HealthCheck.Reports.V1.OM.Monitors.StateChangesPerDayInternalTrue
SCC.HealthCheck.Reports.V1.OM.Perf.PerformanceInsertsPerDayPerformance - Performance Inserts Per Day (OM)SCC.HealthCheck.Reports.V1.OM.Perf.PerformanceInsertsPerDayInternalTrue
SCC.HealthCheck.Reports.V1.OM.Perf.Top20PerformanceInsertionsByPerfPerformance - Top 20 Performance Insertions By Perf (OM)SCC.HealthCheck.Reports.V1.OM.Perf.Top20PerformanceInsertionsByPerfPublicTrue
SCC.HealthCheck.Reports.V2.OM.Alerts.Top20AlertsByRepeatCountAlerts - Top 20 Alerts By Repeat Count (OM)SCC.HealthCheck.Reports.V2.OM.Alerts.Top20AlertsByRepeatCountInternalTrue
SCC.HealthCheck.Reports.V2.OM.Alerts.Top20ByAlertCountAlerts - Top 20 Alerts By Alert Count (OM)SCC.HealthCheck.Reports.V2.OM.Alerts.Top20ByAlertCountInternalTrue
SCC.HealthCheck.Reports.V2.OM.DW.DatabaseSizeSpaceMisc - Operational and Datawarehouse Usage Report (OM) - (DW)SCC.HealthCheck.Reports.V2.OM.DW.DatabaseSizeSpaceInternalTrue
SCC.HealthCheck.Reports.V2.OM.Events.AllByCountLast7dEvents - All Events Count By Last 7 Days (OM)SCC.HealthCheck.Reports.V2.OM.Events.AllByCountLast7dInternalTrue
SCC.HealthCheck.Reports.V2.OM.Events.Top20ComputersGeneratingMostEventsEvents - Top 20 Computers Generating the Most Events (OM)SCC.HealthCheck.Reports.V2.OM.Events.Top20ComputersGeneratingMostEventsInternalTrue
SCC.HealthCheck.Reports.V2.OM.GroupsReportMisc - Groups Report (OM)SCC.HealthCheck.Reports.V2.OM.GroupsReportInternalTrue
SCC.HealthCheck.Reports.V2.OM.Misc.AgentHotfixAgents - Agent Hotfix Report (OM)SCC.HealthCheck.Reports.V2.OM.Misc.AgentHotfixInternalTrue
SCC.HealthCheck.Reports.V2.OM.Misc.AgentMissingHotfixAgents - Agents Missing Hotfix Report (OM)SCC.HealthCheck.Reports.V2.OM.Misc.AgentMissingHotfixInternalTrue
SCC.HealthCheck.Reports.V2.OM.Misc.InfrastructureMisc - Infrastructure Overview (OM)SCC.HealthCheck.Reports.V2.OM.Misc.InfrastructureInternalTrue
SCC.HealthCheck.Reports.V2.OM.Misc.ManagementPacksMisc - Management Packs (OM)SCC.HealthCheck.Reports.V2.OM.Misc.ManagementPacksInternalTrue
SCC.HealthCheck.Reports.V2.OM.Perf.Top20ComputersByPerfCountPerformance - Top 20 Computers By Perf Count (OM)SCC.HealthCheck.Reports.V2.OM.Perf.Top20ComputersByPerfCountInternalTrue
SCC.HealthCheck.Reports.V2.OM.Perf.TopPerformanceBaselineGeneratingRulesPerformance - Top Performance Baseline Generating Rules (OM)SCC.HealthCheck.Reports.V2.OM.Perf.TopPerformanceBaselineGeneratingRulesInternalTrue
SCC.HealthCheck.Reports.V2.OM.State.OldStateChangesNotGroomedState - Old State Changes Not Groomed (OM)SCC.HealthCheck.Reports.V2.OM.State.OldStateChangesNotGroomedInternalTrue