Hacking the Data Warehouse at #MMS2013

#MMS2013 Session Catalog went live yesterday. So now, when sponsor sessions are listed, I can announce that I’m going to be there to deliver Veeam’s sponsor session and to speak about OpsMgr reporting. That’s a great chance to share all the things I have learned about SCOM Data Warehouse during last 4 years (including 1.5 […]
Continue reading…

 

Survey: How do you use SCOM report? – RESULTS

Here are the results of the poll that was announced a couple of weeks ago. I’m not going to provide any analysis here. I have made some conclusions, you may make your own. Number of participants: 52 (Thank You!) Results: Do you use SCOM reporting feature?  Do you use Generic reports?  Generic VS Product-specific?  Flexible […]
Continue reading…

 

Configure SQL Server Business Intelligence Development Studio 2008 to support OpsMgr reports development

Update: Instructions for SQL Server 2012 Data Tools are here. This is just a short note on how to configure BIDS 2008 to support OpsMgr reports development. Copy Microsoft.EnterpriseManagement.Reporting.Code.dll from SSRS bin folder to C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies\ Add ManagementGroupId key to devenv.exe.config: just copy <appSettings>…</appSettings> section from your ReportingServicesService.exe.config like this: <configuration> … <appSettings> <add key="ManagementGroupId" […]
Continue reading…

 

SSRS 2008 in backward compatibility mode: conditional visibility doesn’t work

Couple of months ago I blogged about conditional formatting. Now it turned out that conditional visibility doesn’t work as well. Here is the case: You design report which has a list with nested table; You use expressions to manage columns visibility; Outcome: Everything is okay in SSRS 2005 Everything is okay in SSRS 2008 running in “native” […]
Continue reading…

 

Microsoft generic reports do not work when you try to reuse your old SCOM Data Warehouse

Case You have a SCOM Data Warehouse. It was previously used by some management group(s). You deploy a new management group. You decide to use existing data warehouse when you deploy “Reporting” components. So you uncheck “Data Warehouse” option and instruct installer to use existing database:  Setup succeeds, but when you try to run any […]
Continue reading…

 

Conditional formatting doesn’t work if report is processed by SSRS 2008 (SP1 or SP2) in backward compatibility mode.

Pretty long  title, isn’t it? But the story is short. I was authoring an OpsMgr report containing custom control designed for SSRS 2005 (EnterpriseManagementChartControl – shipped by Microsoft with OpsMgr and is used by MS Generic report library) and some conditionally formatted table cells (background color, text color and font weight). Guess what I’ve got […]
Continue reading…

 

InteractiveHeight, SSRS 2005 rdl schema and an instance of SSRS 2008

Got an awesome bug yesterday. QA guys reported that when they had tried to deploy my reports MP to OpsMgr installation powered by SSRS 2008 SP1, they got the following error: Failed to deploy reporting component to the SQL Server Reporting Services server. The operation will be retried. Exception ‘DeploymentException’: Failed to deploy reports for […]
Continue reading…

 

Custom OpsMgr reports: how to get rid of rsInvalidDataSourceReference error

Note: This post is about rsInvalidDataSourceReference error observed in System Center Operation Manager environments. Please consider this blog post for the more details about the nature of rsInvalidDataSourceReference. That description is applicable for any SSRS deployment. You may get a rsInvalidDataSourceReference error when you try to deploy your custom report into OpsMgr SSRS instance. Everything […]
Continue reading…

 

Configure Visual Studio to support OpsMgr reports development

Should you want to develop rich OpsMgr reports using BIDS (Microsoft Business Intelligence Development Studio), you’ll need to complete several simple steps first: Copy MicrosoftRSChart.dll and MicrosoftRSChartDesigner.dll as described here Modify RSReportDesigner.config as described here If you want to use relative time picker and other cool features implemented in Microsoft Generic Report Library you’ll also […]
Continue reading…