SCOM Dashboard created with PowerPivot

System Center Operations Manager (SCOM) is a cross-platform data center management system that provides health and performance monitoring of systems and services.

PowerPivot and Power View, included in Microsoft Excel 2013, is a first-class business intelligence (BI) tool that's capable of storing, processing, and visualizing vast amounts of data.

I developed a dashboard using these tools to collect data from the SCOM Data Warehouse, giving a birds eye view of client environments.  SQL queries underly all the information and it updates every few minutes.

This is the view displayed simultaneously overhead for every managed client and corresponds to alerts and scheduled reports which are sent to engineers and management from SCOM and SQL Server Reporting Services(SSRS).

Daily Health Check Created with VBA

A Health Check was developed using Microsoft Excel VBA collecting data from amongst others the SCOM Data Warehouse.

It generates a report on a daily basis and distributes it to management to reflect the status of the environment across platforms.

With Excel VBA (Visual Basic for Applications) you can automate tasks in Excel by writing macros.

Information is gathered from different platforms in depending on the format in which the environment supplies it.  Most data is collected from the SCOM Data Warehouse by importing reports generated by SCOM in .csv format and then analyzing it in Excel.

A snapshot of the report.  A scrolling matrix shows the status of the last 10 days.  Drill down is possible when more information is required about specific environments.

The process is fully automated except for comments that engineers need to add in order to explain the failures/issues and action plans.  This ensures that problems are highlighted and dealt with and management stays informed.

The backup results is achieved via monitoring event logs with SCOM