Example: Building the Backup Failures Report

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

Before You Begin

To add remote CommServe computers or external databases as data sources, see Adding Remote CommServe Computers as Data Sources and Configuring External Data Sources.


  1. On Web Console, click Reports.

    The Reports page appears.

  2. From the navigation pane, click Configuration > Reports, and then click New Report.

    The Report Builder page appears.

  3. 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 data_set_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 Local (CommCell Name) , and in the Databases list, select CommServ.

    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.

  5. From the Visualization tab, drag Data Table to the Drop components to build the 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, and on the Properties tab, click General properties_general.

    3. In the Title box, type Job Failure Summary.

  6. On the Properties tab, click Fields fields_tab, and then configure sorting and column names:

    • Next to Sorting, click Add Sorting add_data_source, 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 properties_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 fields_tab and configure custom colors for the bars:

    1. Next to Custom Colors, click Customize Series Colors sorting_add.

    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.