NetBackup IT Analytics System Administrator Guide

1. Access the Duplicate Host Analysis report from Reports tab > System Administration reports.
2. Click the Duplicate Host Analysis report name. Use the descriptions in the table below to set the required report scope and generate the report.

   Field name		Description
   Host Group		Allow you to select the host groups, backup servers, or hosts for the report scope. Your selection narrows down the scope and helps find duplicates more efficiently by targeting specific host groups or host name.
   Find Duplicates Using: Host Name Display Name		You can choose between Host Name (default) and Display Name. Both searches are case-sensitive. For Host Name, the system compares the internal host names to find duplicates. This is the default criterion in the legacy host merge option. For Display Name, the system uses the display or external names of the hosts to find duplicates.
   Host Type for the Duplicate Host Clients Only All		Clients Only allows you to find duplicates only for hosts that are identified as Clients (hosts backed up by any backup system). All detects duplicates for all types of hosts.
   Surviving host Selection Criteria Highest Job Count Most Recently Updated		Allows you to specify the criteria to select the surviving host among the duplicates when performing a host merge. Highest Job Count: Selects the host with most associated jobs as the surviving host. This is the default criterion of the legacy host merge option, as a higher job count suggests that the host has more data associated with it. Most Recently Updated: Selects the most recently updated host as the surviving host. Use this option when the duplicate hosts found are no longer actively collecting new data, as it helps to retain the most current host.
   Cascade into sub-groups		The scope selector default is to cascade to all child sub-groups when generating the report. If you prefer to report ONLY on the host group you selected, then uncheck Cascade into sub-groups.
   Filter by Common Attributes		Select this checkbox to have the report scope display attributes using "AND" logic. By selecting this feature, the report will display those results with the intersection of the selected criteria. If this checkbox is not selected, the report will display attributes using "OR" logic. For example, if you select attribute values, Campbell, Engineering, Cost Center 1 and select Filter by Common Attributes, the report will display only the results that contain all 3 attribute values. If you do not select Filter by Common Attributes, the report will display all results with attributes Campbell, Engineering, or Cost Center 1.
   Apply Attributes to Backup Servers		Select this checkbox to apply the attributes only to the backup servers, instead of hosts.

3. After generating the report, export the report in CSV format on your system.
4. Create a copy of the CSV report and prepare the copy for the host merge script as described in the next step.

To merge duplicate hosts:

1. Run the host_merge.sql script from the ../database/tools directory.

   You can run the script from SQL*Plus or SQL Developer as portal or equivalent user which has access to all the schema tables.

2. Enter the following details when requested by the script:

   • Enter 1 or 2: Enter 1 to run the pre-assessment when you run the script for the first time. You can enter 2 when the pre-assessment is successful.

   • Enter Duplicate Host Analysis CSV file name with full path: Enter the report CSV file path including the file name.

   • Enter log file path: Enter the location for log file (without the file name)

   • Enter log file name: Enter the name of the log file.

   After your pre-assessment is successful, repeat this step with option 2 to complete the host merge.