Load host attributes and values
Function: This utility provides an efficient method for creating multiple attributes, along with a list of possible values for each attribute. Note that the result of this process is simply an inventory of attributes with an associated list of values (LOV). These attributes need to be applied to hosts. This can be accomplished via the Portal or by using other attribute load utilities.
Bulk Load utilities must be run in SQLPLUS as user APTARE. The load_package utility is located in:
/opt/aptare/database/stored_procedures (Linux) \opt\oracle\database\stored_procedures (Windows)
In preparation for loading host attributes, enter the information into a spreadsheet from which you will create a comma-separated values file.
The table in the spreadsheet should be in the following format:
first column - list the attribute name
subsequent columns - list the possible values for the attribute
Table: Table 1: Example of a Table of Attributes and Values
Attribute Name | Attribute Value | Attribute Value |
|---|---|---|
Operating System | Windows | Win |
Criticality | Mission Critical | Low |
To load attributes and values for a domain
- Create a table in a spreadsheet, as shown in the above example. Save the table as a comma-separated file in a temporary directory.
Windows example: C:\temp\attributes.csv
Linux example: /tmp/attributes.csv
- Log in to the Portal server.
- At the command line:
su - aptare
- At the command line, launch sqlplus:
sqlplus <pwd>/<pwd>@//localhost:1521/scdb
Example: sqlplus portal/portal@//localhost:1521/scdb
- At the command line, execute the following at the SQL prompt:
SQL> Execute load_package.loadAttributeFile('pathname_and_filename', 'domain_name');where:
'pathname_and_filename'
full path + filename (enclosed in single straight quotes) of the CSV file that you created
'domain_name'
name of the domain in which the hosts reside (enclosed in single straight quotes).
Example:
Execute load_package.loadAttributeFile('c:\temp\attributes.csv', 'APTARE'); - Restart the Portal services so that the newly added attributes become available in the Dynamic Template Designer.
To identify the domain, in the Portal: