Veritas NetBackup™ OpsCenter Reporting Guide

Last Published:
Product(s): NetBackup (8.3.0.1, 8.3, 8.2, 8.1.2)
  1. Reporting in OpsCenter
    1. About OpsCenter reports
      1.  
        OpsCenter reporting user interface
      2.  
        Report creation wizards in OpsCenter
      3.  
        Reports > Report Templates
      4.  
        About custom reports in OpsCenter Analytics
      5.  
        About custom SQL query in OpsCenter Analytics
      6.  
        About supporting OpsCenter custom reports and custom SQL queries
    2. About managing reports in OpsCenter
      1.  
        Save report and email report dialog boxes
      2.  
        Saving an OpsCenter report
      3.  
        Exporting an OpsCenter report
      4.  
        File formats available in OpsCenter
      5.  
        Emailing a report in OpsCenter
      6.  
        Configuring number of rows in a tabular report for email or export
      7.  
        Adding email recipients to an OpsCenter report mailing
      8.  
        Add email recipients dialog box options
    3. About managing My Reports
      1.  
        Creating a report using the My Reports tab
      2.  
        Deleting a saved report using the My Reports tab
      3.  
        Viewing a saved report using the My Reports tab
      4.  
        Editing a saved report using the My Reports tab
      5.  
        Exporting a saved report
      6.  
        Emailing a saved report
    4. About managing My Dashboard
      1.  
        Reports > My Dashboard options
      2.  
        Adding reports to a dashboard
      3.  
        Modifying a dashboard section
      4.  
        Deleting a dashboard section
      5.  
        Emailing dashboard sections
      6.  
        Refreshing My Dashboard
    5. About managing reports folders in OpsCenter
      1.  
        Reports > Manage Folders options
      2.  
        Adding a reports folder in OpsCenter
      3.  
        Editing a reports folder in OpsCenter
      4.  
        Deleting reports folders in OpsCenter
      5.  
        Deleting reports from a folder in OpsCenter
    6. About managing report schedules in OpsCenter
      1.  
        Reports > Schedules options
      2.  
        Viewing report schedule details in OpsCenter
      3.  
        Using report schedules in OpsCenter
      4.  
        Report Schedule Wizard
      5.  
        Creating a report schedule in OpsCenter
      6.  
        Editing a report schedule in OpsCenter
      7.  
        Deleting a report schedule in OpsCenter
      8.  
        Enabling or disabling a report schedule
    7. About managing time schedules in OpsCenter
      1.  
        Reports > Schedules > Create or Edit Time Schedule options
      2.  
        Viewing time schedule details
      3.  
        Creating a time schedule
      4.  
        Editing a time schedule
      5.  
        Deleting a time schedule
  2. OpsCenter reports
    1. Report Templates in OpsCenter
      1.  
        About report filters in OpsCenter
      2.  
        Creating an OpsCenter report using a Report Template
      3. Using report formats
        1. About report formats
          1.  
            About viewing data in a graphical report
    2. About Report Templates descriptions
      1. About Audit reports
        1.  
          Audit Reports > Audit Trails Report
      2. About Backup reports in OpsCenter
        1.  
          Deduplication > Deduplication Rates by Master Server
        2.  
          Deduplication > Deduplication Rates by Policy Type
        3.  
          Deduplication > Deduplication Size Factor
        4.  
          Deduplication > Pre vs. Post Deduplication Size report
        5.  
          Deduplication > Deduplication Size Savings
        6.  
          Variance > Throughput Variance
        7.  
          Job Activity > Variance > File Count Variance report
        8. Job Activity > Variance > Backup Duration Variance report
          1.  
            About client jobs for selected time frame report
        9. Job Activity > Variance > Backup Job Size Variance report
          1.  
            Client backup jobs
        10.  
          Job Activity > Backup Window > Job Count report
        11.  
          Job Activity > Backup Window > Job Size report
        12.  
          Job Activity > Backup Window > File Count report
        13.  
          Job Activity > Job Count
        14.  
          Job Activity > Job Size
        15.  
          Job Activity > Client Count
        16.  
          Job Activity > Job Duration
        17.  
          Job Activity > File Count
        18. Job Browser > Tabular Backup Report
          1.  
            Skip File Details
        19.  
          Planning Activity > Capacity Planning > Forecasted Size report
        20.  
          Planning Activity > Capacity Planning > Historical Size report
        21.  
          Planning Activity > Forecast > Job Count report
        22.  
          Planning Activity > Forecast > Job Size
        23.  
          Planning Activity > Scheduled Job > Scheduled Job report
        24.  
          Changing the Planning Activity > Scheduled Job > Scheduled Job report parameters
        25.  
          Planning Activity > Scheduled Job > Job Count Scheduled Vs Actual report
        26.  
          Excluding manual jobs from the actual jobs in the Job Count Scheduled Vs Actual report
        27.  
          Planning Activity > Scheduled Job > Job Count within Backup Window report
        28.  
          Planning Activity > Scheduled Jobs > Job Details Scheduled Vs Actual report
        29.  
          Modifying the Planning Activity > Scheduled Jobs > Job Details Scheduled Vs Actual report
        30.  
          Planning Activity > Scheduled Job > All Jobs report
        31.  
          Planning Activity > Stored Backup Images > Valid Backup Images report
        32.  
          Planning Activity > Stored Backup Images > Duplicate Copies report
        33.  
          Planning Activity > Stored Backup Images > Stored Backup Images > Stored Backup Images on Media
        34.  
          Status & Success Rate > Status > Failed Job Count report
        35.  
          Status & Success Rate > Status > Partially Successful Job Count report
        36.  
          Status & Success Rate > Status > Successful Job Count report
        37.  
          Status & Success Rate > Status > All Failed Backups report
        38.  
          Status > Consecutive Failures
        39. Status & Success Rate > Status > Week At A Glance report
          1.  
            Week at a Glance Detail report
        40.  
          Status & Success Rate > Status > Backup Window Failures report
        41.  
          Status & Success Rate > Status > Partially Successful Job Details report
        42.  
          Status & Success Rate > Status > Skipped Files Summary report
        43. Status & Success Rate > Status > Job Attempt Status Detail report
          1.  
            Job details by attempt status
        44.  
          Status & Success Rate > Status > Job Details report
        45.  
          Status & Success Rate > Status > Job Summary by Status report
        46.  
          Status & Success Rate > Status > Job Status > Historical report
        47.  
          Status & Success Rate > Status > Job Status > Distribution report
        48.  
          Status & Success Rate > Success Rate > Success Rate - All Jobs report
        49.  
          Status & Success Rate > Success Rate > Advanced Success Rate report
        50.  
          Status & Success Rate > Success Rate > Success Rate - All Attempts report
        51.  
          Status & Success Rate > Success Rate > Success Rate - First Attempt report
        52.  
          Status & Success Rate > Success Rate > Success Rate - Line report
      3. About Catalog reports in OpsCenter
        1.  
          Cold catalog backup report
      4. About Chargeback reports in OpsCenter
        1.  
          Deduplication Chargeback report
        2.  
          Cost Tabular report
        3.  
          Backup Chargeback report
      5. About Client reports in OpsCenter
        1.  
          Risk Analysis > Client Risk Analysis report
        2. Risk Analysis > Client Coverage report
          1.  
            About CSV formats
          2.  
            About comparison of clients listed in CSV and OpsCenter
        3.  
          Risk Analysis > Recovery Point Objective report
        4.  
          Clients Not Backed up report
        5. Virtual Client Summary report
          1.  
            Virtual Client Job Details
        6. Job Success by Client report
          1.  
            Job Details by Client
        7.  
          Job Success by Client (Tabular) report
        8.  
          Client summary dashboard report
        9. BMR client configuration backup failures report
          1.  
            Jobs by application report
        10.  
          SAN client jobs report
      6. About Cloud reports
        1.  
          Job Success Rate report
        2.  
          Data Expiring in Future
        3.  
          Cloud Metering
        4.  
          Average Data Transfer Rate
        5.  
          Cloud Metering Chargeback
      7. About Disk and Tape Device Activity reports in OpsCenter
        1.  
          Disk and Tape Device Activity > Current Disk Pool Usage Report
        2.  
          NetBackup Disk Pool Capacity report
        3.  
          NetBackup Disk Pool Size vs. Percentage Full report
        4.  
          Library Summary report
        5.  
          Library Capacity Forecast report
        6.  
          Disk and Tape Device Activity > Tape Drive Throughput
        7.  
          Disk and Tape Device Activity > Tape Drive Utilization Report
        8.  
          Disk Usage report
        9.  
          Storage Unit Usage report
      8. About Media reports in OpsCenter
        1.  
          Media Reports > Media State
        2.  
          Available Media report
        3.  
          Drives in Use report
        4.  
          Full Media Capacity report
        5.  
          Media Summary by Media Server report
        6.  
          Media Reports > Media Utilization
        7.  
          Tape Count report
        8.  
          Tapes Expiring in Future report
        9.  
          Tapes Expiring Now report
        10.  
          Vault Media Usage report
        11.  
          Media Reports > Media Expiration Schedule
      9. About Performance reports in OpsCenter
        1. Master Server Job Throughput report
          1.  
            Total Jobs of a Server report
          2.  
            Successful Jobs of a Server
        2.  
          Media Server Job Throughput report
        3.  
          NetBackup SAN Client Performance report
      10. About Policy reports in OpsCenter
        1. Top 10 Policies Using Most Server Space report
          1.  
            Job Details for Policy
        2.  
          Job Success Rate by Policy Type report
        3.  
          Policy Change report
        4. Policy Summary Dashboard report
          1.  
            Total Jobs for Policy
          2.  
            Successful Jobs for Policy
          3.  
            Partial Jobs for Policy report
          4.  
            Failed Jobs for Policy
      11. About Restore reports in OpsCenter
        1.  
          Restore > Restore Job Attempt Summary by Job Count
        2.  
          Restore > Restore Job Attempt Summary by Volume Restored
        3.  
          Restore > Restore Job Details
        4.  
          Client Restore report
      12. About Storage Lifecycle Policy reports
        1.  
          About SLP and Auto Image Replication
        2.  
          SLP Status report
        3.  
          SLP Backlog report
        4.  
          SLP Status by SLP report
        5.  
          SLP Status by Client report
        6.  
          SLP Status by Image report
        7.  
          SLP Status by Image Copy report
        8.  
          SLP Status by Destinations report
        9.  
          SLP Duplication Progress report
        10. Limitations of SLP reports
          1.  
            About storage lifecycle policy retention
          2.  
            About data collection from EMM
          3. SLP reporting limitations
            1.  
              Issues associated with initial data collection
            2.  
              Issues associated with periodic data collection
            3.  
              Known Issues with SLP reports
      13. About Workload Analyzer reports in OpsCenter
        1.  
          Workload Analyzer report
        2.  
          Workload Analyzer subreports: Job Count, Size, Queue, and Throughput
        3.  
          Workload Analyzer report template options
        4.  
          Generating a Workload Analyzer report
        5.  
          About exporting and emailing the Workload Analyzer report
  3. Custom reports in OpsCenter Analytics
    1. Creating a custom report in OpsCenter
      1. About Custom Report Wizard parameters
        1.  
          Configuring timeframe parameters
        2.  
          Selecting and using filter parameters
        3. About display options
          1.  
            About Historical view display options
          2.  
            About Ranking chart display options
          3.  
            About Distribution chart display options
          4.  
            About Tabular display options
          5.  
            Defining report conditions
    2.  
      Creating an OpsCenter report using SQL query

Creating a custom report in OpsCenter

In addition to using the reports that come by default with OpsCenter, you can use the Custom Report Wizard to create custom reports that are unique to your installation.

After creating a custom report, you can modify the report, print, save, and email it.

As you work with different report categories, the Report Wizard displays different parameters. Many of the parameters are used for multiple report categories, and they appear in different combinations for each type.

You can create a custom report by using the parameters that are available in the Custom Report Wizard.

To create a custom report

  1. In the OpsCenter console, click Reports > Report Templates.
  2. Click Create New Report.
  3. On the Select Report Creation Option page, click Create a Custom Report to start the Custom Report Wizard.
  4. Select a report category from the Category drop-down list:

    Agent

    Select this category if you want to know about the configured Agents on the OpsCenter Server.

    Backup/Recovery

    Select this category to create reports on jobs, disk pool, logs, image, media, tape drive etc.

  5. The Subcategories appear as per what you select from the Category drop-down list. From the Subcategory drop-down list, select one of the following report subcategories:

    The following subcategory appears when you select Agent as the main category:

    Agent Status

    Select to view information specific to the Agent. For example, you can create a report that shows the configured Agents on the OpsCenter Server and the Agent status.

    The following subcategories appear when you select Backup/Recovery as the main category:

    Disk Pool

    Select to view a consolidated report related to disk pool.

    Job/Image/Media/Disk

    Select to view job, image, media, or disk data. The reports based on this subcategory provide a consolidated view of job, image, media, and disk. For example, you can create a custom report that tells the number of images per job type or a tabular report that tells which image is backed up on which media.

    You can also view the backups that are taken on the disk.

    Log

    Select to view logs that are generated as a result of backup and recovery activity in NetBackup and Backup Exec.

    Media

    Select to view reports on media like tape media etc.

    Tape Drive

    Select to view reports on tape drives. This subcategory does not show reports related to media servers.The associated filter parameters, such as Tape Drive Device Host or Tape Drive Type appear.

    Scheduled Jobs

    Generate reports on Scheduled Jobs using this category. For example you can create a report that compares the scheduled time and the actual time for scheduled jobs.

  6. Select a report format from the following formats in the View Type drop-down list:

    Distribution

    Display groupings or objects or resources in a pie chart.

    Ranking

    Display a horizontal bar graph showing all the data for each view level object, from greatest to the least, within the selected time frame.

    Historical

    Display a stacked (segmented) bar graph with a trendline superimposed over it showing the average upward and downward trends of the data over time.

    Tabular

    Display data in the form of a table.

  7. Click Next.
  8. In the Select Parameters panel of the Custom Report Wizard, select values for one or more report parameters. The report parameters that appear depend on the report category and the view type that you selected.

    See Configuring timeframe parameters.

    See About Custom Report Wizard parameters.

    As you select parameters, the Content pane may refresh to display additional selections. For example, when you select a view filter, you are then given a choice of items on which to filter the report display.

  9. Click Next.
  10. In the Modify Display Options panel, define the measurements to be collected for historical, ranking, tabular, and distribution reports. Different display options are displayed for different view types.

    See About display options.

    Click Next.

  11. In the View Report Data panel, you can view the report that is created as per your selection.

    Click Next.

    To return to the Custom Report Wizard and make changes to the report, click Back.

  12. Save the report. Enter a report name, a description (optional), and location where you want to save the report.

    Click Save.

Example 1: You may want to create a custom report based on your specific requirements. For example, you may want to create a daily status report of the clients that are backed up everyday.

This report gives the detailed tabular information of the jobs directory being backed up, its status (if it's successful, partially successful or failed), Level Type (Incremental, Full, Differential Incremental), the job file count and job size in the datacenter . You can enhance this report by adding more available columns based on the report requirement.

See the procedure to know how you can create a daily status report of the clients that are backed up everyday.

To create a daily status report of the clients that are backed up everyday

  1. In the OpsCenter console, click Reports.
  2. On the Report Templates tab, click Create New Report.
  3. On the Report Wizard, select the Create a custom report option and click Next.
  4. Select the Report Category as Backup/Recovery and the Subcategory as Job/Images/Media/Disk.
  5. Select the Report View type as Tabular.

    Click Next.

  6. Select the appropriate timeframe for which you want to view the data.
  7. Select the Job filter. Select the Column as Backup Job data type, Operator as =, and Value as Yes. Click Add.
  8. Click Next.
  9. Under Tabular Report Properties, select the Time Basis as Job End Time. Change the Display Unit as per your requirement.
  10. Select Available columns from the list that appears:
    • Backup Job File Count

    • Backup Job Size

    • Job Directory

    • Job End Time

    • Job Start Time

    • Job Status

    • Job Status Code

    • Job Type

    • Master Server

    • Schedule Name

    • Schedule/Level Type

    Click Add.

  11. Click Next to run the report.

Example 2: You may want to create a report that examines the number of tapes in each status category and its percentage.

To report on the distribution of tape status in your environment

  1. In the OpsCenter console, click Reports.
  2. On the Report Templates tab, click Create New Report.
  3. On the Report Wizard, select the Create a custom report option and click Next.
  4. Select the Report Category as Backup/Recovery and the Subcategory as Media.
  5. Select the Report View type as Distribution.

    Click Next.

  6. Select the appropriate timeframe for which you want to view the data. You can also select No Time Basis.
  7. Optionally, select any filters based on your requirement.

    Click Next.

  8. In the Distribution Chart Properties section, make the following selections:

    Chart Type

    Pie Chart

    Report On

    Media History Status

    Report Data

    Media ID

    Count

  9. Click Next.

Example 3: You may want to create a custom tabular report that shows the following information:

  • Know what jobs were successful in the past week for a specific master server

  • Show the amount of time the backup took

  • Show how large the backup was

To create a report showing successful backup job details for a master server

  1. In the OpsCenter console, click Reports.
  2. On the Report Templates tab, click Create New Report.
  3. On the Report Wizard, select the Create a custom report option and click Next.
  4. Select the Report Category as Backup/Recovery and the Subcategory as Job/Image/Media/Disk.
  5. Select the Report View type as Tabular.
  6. Change Relative Time Frame to Previous 1 Week
  7. Under Filters, select Job. In the Column area, select Job Type, select the = Operator and choose a value of Backup.

    Click Add.

  8. Back under the Column heading, select Job Status leave the Operator at "=" and choose Successful as the value

    Click Add.

  9. Click Next.
  10. Select the Time Basis as Job Start Time
  11. You may change the Display Unit or Time Duration. For example if the master server takes smaller backups, then you may change the Display Unit to MB.
  12. From the Available Columns list, select the following:
    • Backup Job Size

    • Client Name

    • Job Duration

    Click Add to move them under the Selected Columns area.

  13. In the Selected Column area, perform the following operations for each of the rows:
    • Click the check box next to Client Name on the right and click Move Up to make it the first row.

    • On the Job Duration row, change Operation to Total.

    • On the Job Size row, change Sort Order to Descending and Operation to Total.

  14. Click Next.