Search <book_title>...

Veritas NetBackup™ OpsCenter Reporting Guide

Last Published: 2018-02-16

Product(s): NetBackup (8.1.1, 8.1)

Reporting in OpsCenter
OpsCenter reports
1. Report Templates in OpsCenter
2. About Report Templates descriptions
Custom reports in OpsCenter Analytics
1. Creating a custom report in OpsCenter
  1. About Custom Report Wizard parameters
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

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.