Execute the script
To load host HBA port data
Note:
When running this script, pay attention to the value you supply for the isIncremental parameter. When you specify 'N' your existing host data is deleted. When you specify 'Y' your host data is added without removing existing records.
- Create a table in a spreadsheet, as shown in the above example. Save the table as a comma-separated file (for example, hostWWN.csv).
- Log on to the Portal Server as user aptare.
- At the command prompt, type: sqlplus <pwd>/<pwd>@//localhost:1521/scdb
- Execute the following at the SQL prompt:
SQL> Execute srm_load_pkg.loadHBAPortFile('< domainName>', '<isIncremental>', '<CSVfile>', '<logPathname>', '<logFilename>',[,'<source_name>']);where:
'domainName'
NetBackup IT Analytics domain name (enclosed in single straight quotes)
'isIncremental'
'Y' or 'N' (enclosed in single straight quotes) to indicate if it is an incremental load.
If 'Y', an HBA port record will be created if none exists. If 'N', old HBA port records will be deleted first and then new records created. Take care when choosing this option, as it will remove existing host data from the database.
'CSVfile'
CSV file path and name (enclosed in single straight quotes)
'logPathname'
Log path name (enclosed in single straight quotes). The audit log file is created only if errors occur. Other status is logged in scon.log.
'logFilename'
Log file name (enclosed in single straight quotes). This audit log file is created only if errors occur. Other status is logged in scon.log.
'source_name'
source_name is an optional, case-insensitive string, up to 100 characters, representing the source of the host details; for example, CMDB might be relevant for a change management database. This source information is retained for historical purposes, to track how the host was added to the database. If nothing or NULL is provided for this parameter, HBA CSV Load will be inserted as the source into the reporting database.
Example:
Execute srm_load_pkg.loadHBAPortFile('corpHost1', 'Y', '/tmp/hba_port_data.txt','/tmp','hba_port_data.log','CMDB'); - IMPORTANT: If you created a new source_name, you need to insert it into the custom host source ranking table using the instructions provided in