Using Report Builder to create new Reports in SCOM 2012

As anyone who has clicked the link in the Reporting view in the Operations Manager Console to author reports via the Report Builder will know, the required models are not available within the tool to get you started.

Details on how to get the models loaded in 2007 SP1/R2 is detailed below.

http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/20269/Default.aspx

I’ve detailed how to get this implemented with SCOM 2012 as there are some subtle differences.

Firstly, load up the Report Manager.  Browse to http://<reportserver>/Reports

Click on the Details View

rs1

Click on Data Warehouse Main to open up the properties of this object.

(Notice that the icon is grey ?  It’s hidden, we need to make it visible.  For default deployments, this is the case)rs2

Once in the Data Warehouse Main properties page, ensure the checkbox for ‘Hide in tile view’ is not selected.  Once done, Apply the settings

rs3

When you navigate back to the Home page, you’ll find that the Data Warehouse Main item has been ‘lit up’.  This means we can now use it as a data source for report models.  rs4

Next, we need to import the Event and Performance Model files so they can be used by the report builder.

1. Click on Upload File.

rs5

2. Click on Browse.  Locate the SCOM 2012 source files and from there, select the ReportModels\Other folder.  In here you can find the 2 .SMDL model files required.

Select Event.smdl and open

rs6

Repeat from step 1, but select the Performance.smdl file.

OK, that done, just need to link the models to the Data Warehouse Main datasource.

So, from the Home screen, click on  either the newly loaded Event or Performance items.

rs7

Select the Data Source link, click Browse

rs8

Select the Data Warehouse Main item, click on OK and Apply

rs9

Do the same for the other SMDL file.  That’s it, all the configuration you need to do !

If you’re using SQL 2012, it looks like you will need to download Report Builder 3.

http://www.microsoft.com/en-gb/download/details.aspx?id=29072

Click above to obtain it.

 

Some great info on creating reports can be found here…

http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/76257/Default.aspx

Advertisements
This entry was posted in Console, Reporting, SCOM 2012, SQL. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s