How to use the parameters in the OpsCenter Risk Analysis - Client Coverage report

Description

About the Client Coverage report

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.

Note: The CSV file must be located on the machine from where you are running
the Client Coverage report.

REPORT COLUMNS

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.Veritas.com, myhost.veritas.com, then
myhost appears in the External Client column.
 

BACKED UP CLIENT
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

See About comparison of clients listed in CSV and OpsCenter below
 

BACKUP PRODUCT
A list of backup products used for backing up the client, such as,
NetBackup, Backup Exec, or Tivoli Storage Manager.

FULL POLICY
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.

INCREMENTAL POLICY
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.

ABOUT CSV FORMATS

The CSV file required as an input to the Client Coverage report can be created
using a text editor or Microsoft Excel application.
A typical CSV file format is as follows:
Host1_name1,Host1_name2,Host1_name3,Host1_name4
Host2
Host3

Note: Host1_name1,Host1_name2,Host1_name3,Host1_name4 are multiple names
of the same machine. Multiple names for the same machine may exist due to many
reasons like because of a machine having multiple Network Interface Cards etc.

Note: Each host machine exists in a new line. For example, Host1, Host2, and
Host3 all exist in three separate lines.

Here is a sample CSV format:

css-bin3,css-bin3.Veritas.com
macy.Veritas.com,macy,macy.veritas.com
css-bin10.Veritas.com

Note: There is no space after the comma in the CSV file.

About comparison of clients listed in CSV and OpsCenter

OpsCenter imports data from the CSV file and compares the list of clients (available in
CSV) with the clients known to OpsCenter.
The Client Coverage report shows any or all of the following outcomes after
comparison:

Client is in
External Client
and Backed Up
Client list
This means that a client exists in both the CSV file and OpsCenter database.
Note: In case multiple names for a machine are present in CSV and
OpsCenter, then all the names present in CSV are compared with each name
in OpsCenter till a match is obtained.

The comparison results in this case may be one of the following:

Match - Direct:
This happens when the host name in CSV is exactly
the same as the host name in OpsCenter. For example,
myhost.Veritas.com in CSV and myhost.Veritas.com in OpsCenter.

Match - (FQDN vs. Short Name):
This happens when 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
comparison result is 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.

In Backup And Not
In External List
This happens when the host name is 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.
 

Running a Client Coverage report

Use the following procedure to run the client coverage report.
 

1.  Click Reports > Report Templates > Client Reports > Risk Analysis > Client Coverage  in the OpsCenter console.

2.  Click Browse to select the csv file for comparison.

Note: The CSV file must be located on the machine from where
you run the Client Coverage report.

3.  Click Edit Parameters

View Selection:
You can define the report’s scope by doing the following: Select
a Client view from the Within View drop-down list. This can be done to
view the report for a specific location, department etc.
If you want to filter the report to include only the data for a
particular set of objects (instead of the data for all objects in the
view), select the view level of the filtered objects from the Filter
at drop-down list.
If you selected a Filter at value, select one or more objects whose
data you want to include in the report in the Select specific items
list box.
Note: In case you select the View parameters, 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.

Client Selection Criteria

In External List And Not In Backup
In Backup And Not In External List
Match (Direct)
Match (FQDN vs Short Name)

Wild Card (Optional)
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 Row Per Page you want displayed on a single page.

4 Click Run.