Custom Reporting

  • Article

There are two primary ways for a MOM administrator to create a customized report:

  • Authoring a new custom report, or modifying an existing report, by using a report authoring tool such as Visual Studio .NET.

  • Creating a linked report, based on an existing report.

The following section discusses how to create a linked report that is based on an existing report.

Example - Server Memory and CPU Performance

This example uses SQL Server Report Manager to create a custom report that charts a selected group of memory- and processor- related performance counters, collected on a single computer, on the same chart.

To create a custom report that charts a selected group of memory- and processor-related performance counters

  1. Start with the Performance Analysis report found in Operational Health Reporting folder in Report Manager. Choose the right parameter values in this report to generate the desired report, as shown in the screenshot.

  2. In Report Manager, click the Properties tab, click Create Linked Report to create a linked report. The Linked Report Properties dialog box appears, which allows you to specify the name, the description and the location of the linked report.

  3. Save this report to a folder titled Custom Reports that was previously created. This report could be stored in any folder that the user chooses.

  4. After creating the linked report, specify default values for the object, counter, instance and scale parameters. Click the Properties tab of the Created Linked report, and click the Parameters sub-tab. For this example, the parameter values are set as follows:

    Table 8.3 Parameters for example report

    Parameter

    Has Default

    Default value

    Prompt User

    Prompt String

    BeginDate

    NO

     

    Yes

    Begin Date

    EndDate

    No

     

    Yes

    End Date

    CompGroup

    Yes

    [ALL]

    Yes

    Computer Group

    Server

    Yes

    [Query-based]

    Yes

    Computer

    ObjName1

    Yes

    Memory

    NO

    ObjName1:

    CtrNme1

    Yes

    Available MBytes

    NO

    CtrName1:

    InstName1

    Yes

    NULL_INSTANCE

    NO

    InstName1:

    ScaleFactor1

    Yes

    1.00

    NO

    ScaleFactor1:

    ObjName2

    Yes

    Memory

    NO

    ObjName2:

    CtrNme2

    Yes

    Cache Bytes

    NO

    CtrName2:

    InstName2

    Yes

    NULL_INSTANCE

    NO

    InstName2:

    ScaleFactor2

    Yes

    0.000001

    NO

    ScaleFactor2:

    ObjName3

    Yes

    Processor

    NO

    ObjName3:

    CtrNme3

    Yes

    % Processor Time

    NO

    CtrName3:

    InstName3

    Yes

    _Total

    NO

    InstName3:

    ScaleFactor3

    Yes

    1.00

    NO

    ScaleFactor3:

    ObjName4

    Yes

    Processor

    NO

    ObjName4:

    CtrNme4

    Yes

    Interrupts/sec

    NO

    CtrName4:

    InstName4

    Yes

    NULL_INTANCE

    NO

    InstName4:

    ScaleFactor4

    Yes

    1.00

    NO

    ScaleFactor4:

This report, when viewed, only allows the Begin Date, End Date , Computer Group and Computer as user modifiable options, and it will graph the previously specified counters for the computer and date range that is specified by the user.

Linked reports allow a user to create a custom report without having to use a report authoring tool. Linked reports are displayed in the Report Manager just like all other reports.

Note

A user must be a Content Manager to create or modify a linked report. Linked reports are not exported or imported as part of Management Packs.