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

Risk Analysis > Client Coverage report

This is a report where a .CSV file can be imported and compared to the existing backup solution to determine if there are systems that are not being protected correctly. The purpose of this report is to show what hosts are not backed up because the backup application is not even aware of them. The report compares what OpsCenter hosts are known to be backed up with an external list that is fed in by .csv file. The list can come from a content management database (CMDB), DNS listings or any other authoritative source of what hosts should be backed up. The report works across all backup applications and shows you what backup application and policy executed the backup and the time of the last full or incremental backup.

The Client Coverage report tells you whether all clients in your environment are being backed up or not. OpsCenter can only report on clients that have already been defined and configured for backups. This report helps you to identify the clients that are a part of your environment but are not known to OpsCenter. These clients may not be getting backed up because of backup software not being installed or the clients not being configured for backups.

To run this report, you must specify a CSV file (comma-separated value) that contains a complete and authoritative inventory of all servers across the enterprise. Some of the independent sources of server inventory across the enterprise which can be used to generate a CSV file are the following:

  • Configuration Management Database (CMDB)

  • Asset Management System

  • Domain Name System (DNS)

  • Homegrown databases

  • Spreadsheet

OpsCenter imports data from the CSV file and compares the list of clients (available in CSV) with the clients known to OpsCenter. The clients which are present in CSV but not in OpsCenter can be easily identified from this report.

Figure: Client Coverage report shows a sample view of the Client Coverage report.

Figure: Client Coverage report

Client Coverage report

Note:

The CSV file must be located on the machine from where you are running the Client Coverage report. See About comparison of clients listed in CSV and OpsCenter. for more information on how the comparison takes place.

The following table provides details on each column that is displayed in the report:

External Client

Name of the client that appears in the CSV file.

Note:

A client may be known by multiple names and all the names may be documented in the CSV file. The name that appears in the External Client column is the first name that is documented in the CSV file. For example, if a CSV file lists multiple names for a client such as, myhost, myhost.vtas.com, myhost.veritas.com, then myhost appears in the External Client column.

Backed Up Client

Name of the backed up client in OpsCenter

Message

The result of comparison. The following are the possible messages:

  • Match - Direct

  • Match - FQDN vs. Short name

  • In External List And Not In Backup

The Client Coverage report helps you to identify these clients which are present in your environment but are not known to OpsCenter. You must verify if these clients are being backed up.

See About comparison of clients listed in CSV and OpsCenter.

Product

A list of backup products used for backing up the client, such as, NetBackup or Backup Exec.

Policy Full Name

The backup policy associated with the client when the last full backup was successful

Last Full Job Time

This is the time when the last full backup was successful for the specific client.

Policy Name Incremental

The backup policy associated with the client when the last incremental backup was successful.

Last Incremental Job Time

This is the time when the last incremental backup was successful for the specific client.

The following are details associated with the Client Coverage report:

Report Name

Client Coverage

Report Category

Client

Where to Locate

Report > Report Templates > Client Reports > Risk Analysis > Client Coverage

Report Purpose

This report shows a comparison of the list of clients being backed up against an independently-sourced list (like CMDB, third party and homegrown asset management systems) of clients.

Supported products

NetBackup, NetBackup Master Appliance, Backup Exec, NetBackup PureDisk

Applicable View

Client

Report Display

Tabular

Drill down report

No

Can be scheduled

No

Supported export formats

PDF, CSV, TSV, HTML, XML

Mapping with VBR report

Backups > Risk Analysis > Client Risk Analysis > Client Coverage

The following table shows the filters for Client Coverage report and how you can use these filters to view specific data in the report.

View Selection

Select a view from the Select View Name drop-down list. This can be done to view the report for a specific location, department etc. In case you select a specific view, you must create the CSV file that contains the clients in the particular view only. For example, if you want to see the Client Coverage report for HR department in Canada, then the CSV file must contain the client list specific to the HR department in Canada.

Additional Parameters

Client Selection Criteria

All

  • All: This is selected by default. Comparison results for all the clients are displayed.

  • In external list but was never backed up: Select this option if you want to view the clients that are present in your environment but are not known to OpsCenter. You must verify if these clients are being backed up.

  • Getting backed up but not in external list: Select this option if you want to view the clients that are known to OpsCenter but not present in the CSV file. This may be due to several reasons like machine not being available in the network or machine not registered in the DNS, and so on.

  • Is matching (Direct): Select this option if you want to view the clients for which host name in CSV is exactly the same as the host name in OpsCenter. For example, myhost.vtas.com in CSV and myhost.veritas.com in OpsCenter.

  • Is matching (FQDN vs Short Name) : Select this option if you want to view the clients for which the host name is an FQDN in CSV and a short name in OpsCenter or a short name in CSV and an FQDN in OpsCenter. For example, if the CSV file contains myhost.veritas.com and OpsCenter contains myhost, then the comparison result is Match - FQDN vs. Short Name. Similarly, if the CSV file contains myhost and OpsCenter contains myhost.veritas.com, then the client is displayed in the report.

  • Was getting backed up but not in external list: Select this option if you want to view the clients that were being backed up earlier but not present in the CSV file.

  • Was matching (Direct): Select this option if you want to view the clients for which host name in CSV was exactly the same as the host name in OpsCenter. For example, myhost.vtas.com in CSV and myhost.veritas.com in OpsCenter.

  • Was matching (FQDN vs Short Name) : Select this option if you want to view the clients for which the host name was an FQDN in CSV and a short name in OpsCenter or a short name in CSV and an FQDN in OpsCenter.

Wild Card

You can specify a part of the backed up client name so that the report shows data only for the specific backed up clients that are of your interest. For example, to see details of all backed up servers running Oracle which are known to have a string "ora" somewhere in the host name, you can type the following:

  • %ora% - Include or exclude all backed up clients with 'ora' anywhere in the host name

  • ora - Include or exclude all backed up clients named ora.

  • ora% - Include or exclude all backed up clients whose names start with ora.

  • %ora - Include or exclude all backed up clients whose names end with ora.

  • Similarly, you can specify multiple search strings as follows:

    • %ora%, %syb% - Include or exclude all OpsCenter hosts with Ora or Syb anywhere in the backed up client name.

Note:

This search is applicable only for Backed up clients and not the External Clients.

Note:

The search is not case-sensitive. For example, if you search for Ora, you may find results like ora, Ora, oRa, and so on.

Display Options

Type a report description.

Select the number of rows you want displayed on a single page.

Example of filter usage: To view details of all backed up servers running VMWare that are known to have 'vm' somewhere in the host name, type %vm% in the Wild Card text box.