Share via

Creating Custom Reports with the MOM Reporting Database

  • Article

The MOM Report Console uses the data archived in the MOM Reporting Database, along with SQL Server Reporting Services to create custom, web-based reports.

To create your own custom reports, you will need the following:

  • A MOM Reporting Database, with SQL Server Reporting Services and IIS.
  • Microsoft Visual Studio .NET, or a 3rd party authoring environment designed for creating reports with SQL Reporting Services.

You should be familiar with the Transact-SQL language. For information about the available views, see the MOM Reporting Database Schema reference. You must use the SQL views when creating the queries for custom reports. Unlike the views, the underlying tables might change in future releases of Microsoft Operations Manager.

To create a new report:

  1. Start Visual Studio .NET.

  2. Create a new project. Select the Report Project Wizard from the Business Intelligence Projects group. After specifying a name and location for the project files, click Next. The Report Wizard will start.

  3. On the Select Data Source page, specify "SystemCenterReporting" for the name, and "SQL Server" for the type.

  4. To build the connection string, click Edit. In the Data Link properties:

    1. Type the name of the reporting database server.
    2. Select Windows NT Integrated security.
    3. Select the SystemCenterReporting database.
    4. Click Test Connection to verify that you can connect to the specified computer and database. Click OK, and then click Next.

  5. For the query string, type:

    "SELECT * FROM SC_AlertFact_View"

    This will return all alerts. (You can modify the query later on.) Click Next.

  6. Select the Tabular report type. Click Next.

  7. To design the Tabular report, select the AlertName column, and then click Group. Select the AlertResolutionState_FK and the AlertDescription columns, and click Details. Click Next.

  8. Select Stepped table layout, and then click Next.

  9. Choose a style, and then click Next.

  10. Select a reporting server to deploy to, and then click Next.

  11. Type a name for the report, and then click Finish.

To edit the report:

Click the Preview tab to run the report query and display the results.

The report is modified in the Visual Studio .NET integrated development environment. You can change the display properties in the Layout view. Modifying the report's layout is similar to editing the controls on a Windows Forms application or an ASP .NET page.

Click the Data tab to view or edit the query used to create the report. The Data window provides a graphical display of the views used in the SQL query. It also allows you to directly edit the SQL query used for the report. If you want to include new columns in your report, you must first add the relevant views and columns in the Data window.

To deploy the completed report:

  1. In Visual Studio .NET, click Build, then Deploy Solution. All of the reports contained in the solution will be updated on the computer that hosts SQL Reporting Services.
  2. Check the Output window and Tasks window for build errors.