Veritas NetBackup™ OpsCenter Reporting Guide

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

SLP Status report

The SLP Status report provides a summary of lifecycle policies that are associated with a master server. The SLP Status report is a tabular report that lets you know the current progress of SLPs in the selected timeframe for each master server that is added to the OpsCenter console.

The SLP status report gives a quick summary of the SLP activity and lets you identify the SLPs that are incomplete. You can see if all your duplications (copies) are complete or not.

By clicking the links in the SLP Status report, you can drill down to more detailed reports. You can use the drill-down reports to focus on SLP's, images, or the image copies that are incomplete. You can also view SLP status for each destination and also for each SLP.

From the SLP Status report, you can drill down to the following reports:

SLP Status by SLP report

See SLP Status by SLP report.

From the SLP Status by SLP report, you can drill down to the following reports:

SLP Status by Client report

See SLP Status by Client report.

SLP Status by Image report

See SLP Status by Image report.

SLP Status by Image Copy report

See SLP Status by Image Copy report.

The SLP Status report comprises of the following columns:

Master Server (where the SLP lives)

Name of the master server (link) where the SLP runs. The SLP may run on the origin master server or any of the destination master servers (in case of Auto Image Replication). The NetBackup master server must be of 7.1 or a later version and also added to the OpsCenter console. This column is mandatory and cannot be removed when you edit the report.

Click on the master server (link) to see the drilldown report named SLP Status by SLP.

Oldest Unfinished Image

This column tells you about the oldest image that is SLP-incomplete for the selected master server. This column represents the image end time (and date). The data from this column helps you to identify the possible bottlenecks in the SLP process.

This column is mandatory and cannot be removed when you edit the report.

Total Clients

Number of the unique clients that are backed up by the SLP for the selected master server. Note that if the same client is backed up twice or thrice by the SLP, the client is counted only once. Click the number (link) to view the SLP Status by Client report.

This column is mandatory and cannot be removed when you edit the report.

Total Existing Images

Total number of the images that are present in the OpsCenter database for SLP's on the selected master server (includes both SLP-complete images and SLP-incomplete images). Click the number (link) to view the SLP Status by Image report for the specific master server. This report displays details of images in the OpsCenter database that are associated with the SLP's on the selected master server.

This column is mandatory and cannot be removed when you edit the report.

Images % SLP Complete

Percentage of images in the OpsCenter database that are SLP-complete for the selected master server. This column is calculated using data from the following columns of the SLP Status report:

  • Images SLP Complete

  • Total Existing Images

The contents of Images % SLP Complete column is calculated by using the following formula:

Images SLP Complete / Total Existing Images * 100

This column is mandatory and cannot be removed when you edit the report.

Images SLP Complete

Number of images in the OpsCenter database that are SLP-complete for the specific SLP on the selected master server. You can remove this column when you edit the report.

Click the number (link) to view the SLP Status by Image report. A filtered view of the report appears that displays details of images in the OpsCenter database that are SLP-complete for the specific SLP.

Images Not SLP Complete

Number of images in the OpsCenter database that are SLP-incomplete for the specific SLP on the selected master server. This column is mandatory and cannot be removed when you edit the report.

Click the number (link) to view the SLP Status by Image report. A filtered view of the report appears that displays details of images in the OpsCenter database that are SLP-incomplete.

Total Expected Copies

Total number of image copies in the OpsCenter database for the specific SLP on the selected master server (includes both complete copies and incomplete copies). This column is mandatory and cannot be removed when you edit the report.

Click the number (link) to view the SLP Status by Image Copy report.

% Copy Complete

Percentage of completed copies in the OpsCenter database for the specific SLP on the selected master server. This column is mandatory and cannot be removed when you edit the report. The data for this column is calculated by using data from the following columns of the SLP Status By SLP report:

  • Copies Completed

  • Total Expected Copies

The contents of % Copy Complete column is calculated by using the following formula:

Copies Completed / Total Expected Copies * 100

Copies Completed

Number of the completed copies that are present in the OpsCenter database for SLP's on the selected master server. Click the number (link) to view the SLP Status by Image Copy report. A filtered view of the report appears that displays details for copies in the OpsCenter database that are complete for the selected master server.

You can remove this column when you edit the report.

Copies Not Complete

Number of incomplete copies in the OpsCenter database for SLP's on a selected master server. This column is calculated using the following formula:

Copies Not Complete = Total Expected Copies - Copies Completed

Click the number (link) to view the SLP Status by Image Copy report. A filtered view of the report appears that displays details for image copies in the OpsCenter database that are incomplete for the selected master server.

This column is mandatory and cannot be removed when you edit the report.

Total Expected Size - all copies (MB)

Expected aggregate size of all copies for SLP's on the selected master server that are present in the OpsCenter database. This column is mandatory and cannot be removed when you edit the report.

The Total Expected Size for all copies is calculated by using the following formula:

Total Expected Size for all copies = (Number of copies) * (backup copy size)

Note:

The total expected size for all copies is a front-end size and is derived from the number of copies multiplied by the size of backup copy. The effects of deduplication, compression, or optimized deduplication on the Total Expected Size - all copies are not considered in the SLP reports.

Completed Copy Size (%)

Percentage of completed copy size for the selected master server. This column is mandatory and cannot be removed when you edit the report.

The Completed Copy Size (%) for the specific master server is calculated using data from the following columns of the SLP Status report:

  • Completed Copy Size

  • Total Expected Size - all copies

The contents of Completed Copy Size (%) column is calculated for each master server by using the following formula:

Completed Copy Size / Total Expected Size - all copies * 100

Completed Copy Size (MB)

Aggregate size of all the completed copies in the OpsCenter database for the selected master server. You can remove this column when you edit the report. Note: The Completed Copy Size is a front-end size. The effects of deduplication, compression, or optimized deduplication on completed copy size are not considered in the SLP reports.

Remaining Copy Size (MB)

Aggregate size of all remaining copies that are to be created for the selected master server. This column is mandatory and cannot be removed when you edit the report.

The Remaining Copy Size (MB) for a specific master server is calculated in the following manner:

(Remaining Copy Count) x (Size of Backup Copy1)

Note:

The remaining copy size is a front-end size and is derived from the number of remaining copies multiplied by the size of backup copy 1. The effects of deduplication, compression, or optimized deduplication on remaining copy size are not considered in the SLP reports.

You can use filters to view specific data in the SLP Status report. The following filters are available when you edit the SLP Status report:

Views

Select a particular view to see data for the selected view.

Master Server

Select one or more master servers to see data for the selected master servers.