Most have you will have clicked on the ‘Design a new report’ button and found that there were ‘No Data Sources available’.
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
CREATE A DATA SOURCE
1. In Solution Explorer, right-click Data Sources, Click Add New Data Source
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)
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
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
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
HAVE FUN!!!
[...] http://opsmgr.wordpress.com/2007/07/19/want-to-design-a-new-report-in-scom-2007/ [...]
Pingback by No Report Models in System Center Operations Manager (SCOM) 2007 « Dustin’s Tech Notes — July 20, 2007 @ 1:08 am
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
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
No, I cannot use the email with any of the reports – built-in or otherwise.
Comment by Kevin — August 1, 2007 @ 1:25 am
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
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
[...] 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
[...] 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
[...] 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