System Center Operations Manager by Jonathan Hambrook

July 19, 2007

Want to ‘Design a new report’ in SCOM 2007?

Filed under: Microsoft, SCOM 2007 — opsmgr @ 3:59 pm

Most have you will have clicked on the ‘Design a new report’ button and found that there were ‘No Data Sources available’.
Design a new report

Here is how you can setup this feature for SCOM 2007.

CREATE A REPORT MODEL

1. Open SQL Server Business Intelligence Development Studio
2. Click File -> New -> Project
3. Select Report Model Project
4. Fill in a Name and Location
5. Click OK
New Project

CREATE A DATA SOURCE

1. In Solution Explorer, right-click Data Sources, Click Add New Data Source
Solution Explorer

2. Click Next on the Welcome Screen
3. Click New
4. Fill in the connection to the SQL Server and Instance (ie: SERVER\INSTANCE) to your SCOM Database
5. Select the Database you want to interact with. (ie: OperationsManagerDW)
DNR Connection Manager

6. Click OK
7. Click Finish

You will now see the Data Source under Solution Explorer

CREATE A DATA SOURCE VIEW

1. In Solution Explorer, right-click Data Sources, Click Add New Data Source View
2. Click Next
3. Select the data source from the Relational data souces: panel
4. Click Next
5. This is the part where you need to think, You will need to select the tables and views you want to include in the model. If you not sure and just want to play around you can however I would not suggest it… but you can sellect all the tables, however leave the views out as they can cause issues.
6. Click Next
7. Click Finish

You will now see the Data Source View under Solution Explorer
Solution Explorer 2

CREATE A REPORT MODEL

1. In Solution Explorer, right-click Data Sources, Click Add New Report
2. Click Next
3. Select the Data Source and Click Next
4. Select the Model Rules and Language (If unsure, keep the defaults) Click Next
5. Select Update model statistics before generating and Click Next
6. Type in a name Name and Click Run

Note: This may take some time depending on the number of Tables and Views selected when creating the Data Source View.

7. Click Finish
8. Under Solution Explorer Right-Click the new Report Model and selct Deploy
Solution Explorer 3

9. Exit SQL Server Business Intelligence Development Studio and Save.

RUN DESIGN A NEW REPORT

1. Open System Center Operations Manager Console
2. In Report Click Design new report
3. Report Builder will launch and you will see a Data Source
4. Highlight it and Select a Report Layout Click OK
Microsoft Report Builder

HAVE FUN!!!

About these ads

9 Comments »

  1. Hello,

    When I right-click on a report, and choose ‘Schedule’, I don’t see any email delivery option in the ‘Delivery Method’ dropdown menu. Is this some sort of a security/permission issue, or just an error? (I’m using the console as administrator of the machine.)

    Thanks!

    Comment by Kevin — July 26, 2007 @ 6:55 am

  2. I have noticed this too and am still looking into it. Do you have the ability to email when using the built-in reports?

    Comment by opsmgr — July 31, 2007 @ 1:52 pm

  3. No, I cannot use the email with any of the reports – built-in or otherwise.

    Comment by Kevin — August 1, 2007 @ 1:25 am

  4. The e-mail server has to be configured in SQL Reporting Services before it will appear in the OpsMgr console. Here’s a link to the required steps: http://technet.microsoft.com/en-us/library/bb309519.aspx

    Comment by Lee Scales — August 23, 2007 @ 12:27 am

  5. Thanks for the link Lee! Sometimes if feels like I have to know all the answers :)

    Comment by opsmgr — August 23, 2007 @ 10:28 am

  6. [...] There is no report model in Ops Mgr by default, so if you want to create a brand new report, you must start with create a report model. You can do that with SQL Server Business Intelligence Development Studio. Take a look at Jonathan Hamb step by step guide how to create a report model here. [...]

    Pingback by contoso.se » Blog Archive » Monitor and Report SQL logon — November 21, 2007 @ 5:35 am

  7. [...] There is no report model in Ops Mgr by default, so if you want to create a brand new report, you must start with create a report model. You can do that with SQL Server Business Intelligence Development Studio. Take a look at Jonathan Hamb step by step guide how to create a report model here. [...]

    Pingback by OpsMgr 2007 » Blog Archive » Monitor and Report SQL Logons — November 26, 2007 @ 9:51 am

  8. [...] time ago Jonathan Hambrook has written an article about Designing a new Report in SCOM 2007. Although this is great article you need to have some prerequisites ready to get started with [...]

    Pingback by Stefan Stranger's Weblog - Manage your IT Infrastructure : Designing a new Report for OpsMgr 2007 — November 3, 2008 @ 10:41 pm


RSS feed for comments on this post. TrackBack URI

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

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: