Basic reporting in SCOM

This is the part three of a set of articles related to SCOM

Part1 - SCOM BASICS

Part2 - Useful SQL queries in SCOM database

Basic reports in SCOM

There are two main ways to edit or develop a report for SCOM: via Report Builder or via Visual Studio. 

In this article we are going to use Visual Studio 2010 with bussines inteligence tools installed.       

Useful SQL queries in SCOM database

This is the part two of a set of articles related to SCOM

Part1 - SCOM BASICS

Which are the differences between Operations and Datawarehouse databases.

Extracted from Microsoft web:

• The operational database is a SQL Server database that contains all configuration data for the management group and stores all monitoring data that is collected and processed for the management group. The operational database retains short-term data, by default 7 days.

• The data warehouse database is a SQL Server database that stores monitoring and alerting data for historical purposes. Data that is written to the Operations Manager database is also written to the data warehouse database, so reports always contain current data. The data warehouse database retains long-term data.

The data retentions in the operational database can be extended from the administration console in the menu Administration --> Settings --> Database Grooming. It is a good idea to extend them to two weeks if you do not have a lot of events in SCOM, because you can plot larger performance charts from the console or search alert events from the console without entering into reporting services. Remember, this is an operational database, so more than four weeks of retention usally can impact  the SCOM perfromance negatively.