Loading...

Example: Building the Backup Failures Report

The following procedure is a real example of how to build the Backup Status Report.

Before You Begin

Procedure

  1. On the Web Console for the Private Metrics Reporting Server, click Reports.

    The Worldwide Dashboard appears.

  2. At the top of the page, click Worldwide Reports > Report Manager , and on the Reports tab, click New Report.
  3. On the Report Builder page, on the Reports tab, in the Report Name box, type Backup Failures, and in the Description box, type Includes information about the backup jobs that failed in each CommCell environment.
  4. On the Dataset tab, click Add , and then configure the settings:
    1. In the Add Data Set dialog box, on the Query tab, select Database.
    2. In the Data Set Name box, type BackupInfo.
    3. In the Data Sources list, select the name of a data source, and in the Databases list, select the database that you want to query.
    4. Select Views, and in the list, select dbo.CommCellClientLevelBkpJobSummary.
    5. Click Preview to collect the field names that you can use as columns in your report.
    6. Click the Advanced tab, and in the Time Out box, type 10.
    7. Click Done.

      The BackupInfo data set appears under Data Sets.

  5. From the Visualization tab, drag Data Table to the Drop components to generate report box.
    1. From the Data Set list, drag field names to the Data Table:
      • Data Source
      • ClientName
      • TotalJobs
      • Failed
      • FailedObjects
      • FailedFolders
    2. Select the table, on the Properties tab, click General .
    3. In the Title box, type Job Failure Summary.
  6. On the Properties tab, click Fields , and then configure sorting and column names:
    • Next to Sorting, click Add Sorting , select Failed Jobs from the list, and then select Desc.

      The data in the table is sorted by the number of Failed Jobs in descending order.

    • Expand each Field Name section, and in the Display Name box, type a name for the column:
      • CommCell
      • Client
      • Total Jobs
      • Failed Jobs
      • Failed Objects
      • Failed Folders
  7. From the Visualization tab, drag Vertical Bar Chart to the Drop components to build the report box.
    1. From the Data Set list, drag Failed to the Drop Y-Axis box.
    2. From the list under Drop Y-Axis, select Distinct.
    3. From the Data Sets list, drag Data Source to the Drop X-Axis box.

      The chart you created appears in the report builder.

    4. On the Properties tab, click General , and configure the chart titles:
      • In the Chart Title box, type Failed Backup Jobs Per CommCell.
      • In the Y-Axis Title box, type Failed Backup Jobs.
      • In the X-Axis Title box, type CommCell.
  8. On the Properties tab, click click Fields and configure custom colors for the bars:
    1. Next to Custom Colors, click Customize Series Colors .
    2. Select each X-Axis from the list, and then click the box next to it.

    3. Click the Default Color box, select a color from the Color dialog box, and then click OK.

      Any bar that is not configured with a custom color displays the color configured in the Default Color box.

  9. Click Preview to see what the report will look like.

  10. At the top of the page, click Save, and then click Deploy.

    The report appears on the Worldwide Reports page under Untagged.

Related Topics