NetBackup IT Analytics System Administrator Guide

Description

Sets up host aliases from a comma-delimited file containing a list of hosts and host aliases.

for a description of the logic used to process hosts and aliases.

Usage

execute load_package.loadHostAliasFile('<file_name>',
'<log_path_name>','<log_file_name>');

Where file_name is the fully qualified path to the csv file that contains the aliases to be loaded.

Example of the file_name specification:

'/opt/aptare/database/HostAliases.csv'

Example of the command execution:

execute load_package.loadHostAliasFile('/opt/aptare/database HostAliases.csv', '/tmp','loadHostAlias.log');

Load File Specification

The specification for the comma-delimited file is as follows:

<domain>, <hostname>, <alias_hostname>

Example: Enterprise, whitney,182.16.1.101

The detailed specification for each field follows:

domain                CHAR(128)    NOT NULL
hostname              CHAR(64)     NOT NULL
alias_hostname        CHAR(64)

The alias_hostname can be either a host name (up to 64 characters) or an IP address.

Data Constraints

Field values cannot contain embedded commas.

The second field, hostname, is the external name, as defined in the Portal database.

The csv file must exist and be readable.

The csv filename must be specified within single quotes.

Logic Conditions

If the host alias already exists, no updates take place.

If the host alias does not already exist in the Reporting Database, the utility adds it.

The utility applies case differences in the input file as updates to preexisting rows.

Logging

The utility logs all additions, updates, warnings and errors to the specified log file. Logging strings are typically in the format: Date -> Time -> load_package:sub_routine -> Action

sub_routine is the sub-routine that is being executed (e.g., loadHostLine).