Veritas NetBackup™ OpsCenter Reporting Guide

Last Published:
Product(s): NetBackup (8.1.1, 8.1)
  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

Deduplication > Deduplication Size Savings

Most NetBackup customers have either implemented some sort of deduplication or plan to in the near future. This is the current trend as customers try to get control of infrastructure and the amount of time backups take. Add to this the need for many customers to protect remote offices across smaller WAN links and deduplication becomes critical since only so much data can be pushed through a small pipe and many times there is no one at the remote site who is capable of managing hardware. In the data center, deduplication reporting helps to determine what the actual deduplication rate is occurring at each PureDisk storage unit. Reporting can be abstracted to view the protected size or stored size across all PureDisk environments or drilled down in to one specific area. Common file or data types can then be identified and matched with their ability to be deduplicated. The report below is a simple dedupe report created using a Media Server Deduplication Pool. It is a very basic report and shows how much data would have been backed up without deduplication enabled. In large environments this would show the number of GB or TB that is NOT being used due to deduplication. The other reports can contrast the dedupe data savings vs. the actual deduped information however in this very small test environment this report shows better information. OpsCenter and OpsCenter Analytics provide the ability to report on the various forms of deduplication available with NetBackup. It can provide reports that show things such as how much deduplication is being done at a remote site before the data hits the WAN pipe. Using the trending feature of Opscenter Analytics can also help to understand if the data is growing faster than the hardware or when the WAN bandwidth can be expected to max out. This allows the company to make educated decisions on when to add infrastructure proactively instead of waiting for things to fail. This report shows the total number of bytes that do not need to be backed up because of deduplication. There is no calculation or ratio in this number. It is the number of bytes (MB, GB, TB etc.) that have not changed since the last backup and therefore do not need to be backed up. This report shows only deduplication jobs. The default Report On parameter for this report is Master Server. This report is available in Historical, and Ranking views. The ranking report groups the total number of bytes saved per host being backed up to show the top five hosts in terms of deduplication savings.

The historical report shows the total number of bytes that do not need to be backed up because of deduplication. There is no calculation or ratio in this number. It is the number of bytes (MB, GB, TB etc.) that have not changed since the last backup and therefore do not need to be backed up. This report shows only deduplication jobs. The default Report On parameter for this report is Master Server

Figure: Deduplication Size Savings Report (Historical) shows a sample view of Deduplication Size Savings Report.

Figure: Deduplication Size Savings Report (Historical)

Deduplication Size Savings Report (Historical)

The ranking report shows the number of bytes that have not changed within the time frame and therefore do not have to be backed up due to deduplication. The report groups the total number of bytes saved per host being backed up to show the top five hosts in terms of deduplication savings. This report shows only deduplication jobs. The default Report On parameter for this report is Master Server.

Figure: Deduplication Size Savings Report (Ranking) shows a sample view of Deduplication Size Savings Report.

Figure: Deduplication Size Savings Report (Ranking)

Deduplication Size Savings Report (Ranking)

The following are the details that are associated with the Deduplication Size Savings report:

Report Name

Deduplication Size Savings

Report Category

Deduplication

Where to Locate

Report > Report Templates > Backup > Deduplication > Deduplication Size Savings.

Report Purpose

Historical trending report showing savings in storage due to deduplication.

Supported products

NetBackup, PureDisk, and their Appliances

Applicable View

Master Server, Client

Report Display

Historical, Ranking

Drill down report

Yes. Drill down reports can be viewed at following four levels depending on the selected parameter value. Level 1: Client Name, Level 2: Job Type, Level 3: Schedule/Level Type, Level 4: Policy Name

Can be scheduled

Yes

Supported formats

PDF, CSV, HTML, XML, TSV

You can edit the Deduplication Size Savings report to show or hide the columns that you are interested in. All the columns are shown by default. You can also filter the report to view reports of specific master servers. The following table shows the filters for Deduplication Size Savings report and how you can use these filters to view specific data in the report.

Filter

Column

Description

View

 

Select a view to show data for the selected view in the report. By default All My Views is selected.

Master Server

Master Server

Select one or more master servers to view data for the clients that are backed up by the selected master servers in the report. All master servers that are added to the OpsCenter console are shown in the Value drop-down list .

Media Server

Media Server

Select one or more media servers to view data for the selected media servers in the report. All media servers that are added to the OpsCenter console are shown in the Value dropdown list.

Client

Client Name

Client OS

Select one or more clients to view data for the selected clients in the report. All clients that are protected by the master servers in the OpsCenter console are listed.

Select one or more client OS to view data for the selected client OS in the report.

Policy

Policy Name

Policy Type

Policy Keyword

Policy Data Classification Name

Select one or more policy names to view data for the selected policies.

Select one or more policy types to view data for the selected policy types.

Select one or more policy keyword to view data for the policies having the selected keyword.

Select one or more policy data classification names like Gold, Silver, Bronze etc. to view data for the policies having the selected data classiciation names.

Schedule

Schedule/Level Type

Schedule Name

Select one or more schedule or level types to view the data for the configured schedules.

Select one or more schedule names to view data for the selected schedule names.

Job

Job Type

Product Type

Job Transport Type

Job Status

Select one or more job types as Archive, Backup, or Restore to view data for the selected job types.

Select one or more backup products to view data for the selected products.

Select one or more transport types like FT, LAN, or Unknown to view data for the jobs that have the selected transport type.

Select one or more job status like Failed, Successful etc. to view data for the selected job status.

Example of filter usage: You may run the Duplication Size Savings report for a specific client to view details for the specific clients

The following report enhancements have been made for the Duplication Size Savings report:

  • Drill down reports for following four levels have been added.

    • Level 1: Client Name

    • Level 2: Job Type

    • Level 3: Schedule/Level Type

    • Level 4: Policy Name

  • The report now shows trendlines with customized average periods with option: Show trendline with moving average period of 3. The value can be 1, 2, 3, 7, 14, or 30. The default value is 3. Example: 3 displays a trendline that, at each interval, shows the average of the current data point and the two previous data points.

  • The unit Years has been added for Relative Timeframe selection. You can now view data for the last x years.

  • The option Next has been removed from the drop-down menu for Relative Timeframe. You now cannot enter a relative timeframe like Next 2 weeks. This is because the report does not support any futuristic data.

  • The following options have been removed from TimeFrameGroupBy selection:

    • Days of week Average

    • Days of week total

    • Hours of day Average

    • Hours of day Total

    • Minutes

    • Month of year Average

    • Month of year total

    • Quarter of year Average

    • Quarter of year total

The following filter enhancements have been made for the Duplication Size Savings report:

  • New columns Job Status (Complete Only) and Job Status (Complete and Partial Only) are added to the Report On parameter.

  • UNKNOWN has been added as a value for Policy Type column in the Policy filter. You can now filter report data for policy types that are UNKNOWN.

  • Job types which are not applicable for this report are removed from the filter. The supported job types are Backup, Archive, Restore, Catalog Backup, Backup from Snapshot, Snapshot, Duplicate, and Replication.

  • The default selected value for Job Type column is changed to Backup.

  • The default unit for Y1 axis is now GB.

  • Value SAN is removed from the Job Transport Type filter.

Known Issues:

  • Selecting Reporton Storage Unit name in OpsCenter does not result in any data for PureDisk because Storage Unit is not present in PureDisk .

  • The unit of data for Y axis/Y1 axis is one unit lower.