Exchange 2010 Reports MP Bug

A couple of fellow colleagues in MCS (Paul Bishop & Jason Rydstrand) a while back had identified a significant bug in the latest version of the Exchange 2010 management pack, which will cause severe growth of two tables in the data warehouse DB in an enterprise deployment of Exchange 2010 and Operations Manager.  This affects both OM…

0

How to Fix the OM 2012 Service Level Tracking Summary Report

This is a fix specific to a report that is provided out of the box with the System Center Operations Manager 2012 RTM and SP1 version, specifically the Service Level Tracking Summary Report that is in the Microsoft Service Level Report Library.  If you have ever run this report you will have noticed that the…

0

How to Use a Textbox Object Picker Control in your Custom Report

So this is a topic I have been meaning to post in a while now and finally made the time/effort to write it up.  This is a scenario that is not documented in the Report Authoring Guide for Operations Manager and I had to go through the reports in the Generic Report Library MP in…

0

Custom Operations Manager Reports

Based off of a recognized demand, I developed a management pack that provides three key reports for Operators and Administrators to leverage.  These reports were based off of queries developed by Kevin Holman and Jonathan Almquist and tuned to support these reports.  The three reports that I have included in this MP are: Maintenance Mode…

13

SQL Reporting Services Gotcha

I uncovered a situation with SQL Server 2005 Reporting Services that I did not encounter before and it is worth mentioning because it follows the premise of – verify SQL Reporting Services first before installing Operations Manager 2007 Reporting.  Background: Windows Server 2008 x64 hosting SQL Server 2005 Enterprise Edition x64 w/SP2 configured with two instances. …

0

Updated Deployment Guide - Operations Manager Reporting on Windows Server 2008

Today I have updated the Deployment Guide for Operations Manager 2007 Reporting on Windows Server 2008.  This was due to some confusion from those who downloaded the doc and were attempting to setup this configuration in their environment.  I received a few e-mails and determined this needed to be addressed accordingly.  Specifically I had verbiage in…

2

Deployment Guide - Operations Manager Reporting on Windows Server 2008

While I realize that today my colleauge in arms Walter Chomak, has blogged about installing System Center Operations Manager 2007 Reporting on Windows Server 2008, the attached guide provides greater detail and guidance on installing SQL Server 2005 Reporting Services and Operations Manager Reporting role on Windows Server 2008.  Walter covers a key step, but I want…

0

Operations Manager 2007 Reporting Authoring Guide Now Available

The Operations Manager 2007 Reporting Authoring Guide is now available for download – http://download.microsoft.com/download/7/4/d/74deff5e-449f-4a6b-91dd-ffbc117869a2/OpsMgr2007_RprtGuide.doc. This document provides an in-depth understanding of the reporting feature, such as: Working with published and linked reports Developing custom reports Schema of the Microsoft.SystemCenter.DataWarehouse.Report.Library.xml (Reporting Management Pack) Scheduling reports (example documented is for e-mail) but now with SP1 we support…

0

Operations Manager Reporting - Resolving Those Errors

Sometimes working with Operations Manager Reporting and SQL Server 2005 Reporting Services can be a bit frustrating or challenging because the error displayed are often ambiguous.  Some common situations I have come across are the following (including the solution): Operations Manager 2007 Reporting Setup states “SRS Validation Error.”  Check the following: That SQL Reporting Services service is…

2