Import host attribute values
When importing Host Attributes, the system will read the prepared CSV file and display a dialog to review the data results before the final import.
enables you to:
assign attributes to existing hosts
create new attributes if they do not exist
unassign attributes from hosts
This operation may be scheduled to occur on a regular basis using the portal.properties file. This operation may also be completed using the bulk load utility. As a best practice, use the Portal for the import. See also the System Administrator Guide under Attribute Management.
See Attribute bulk load utilities.
See “To import host attribute values from a CSV file”.
This video demonstrates importing of host attributes using Import Host Attributes dialog box.
Hosts and attributes must exist.
See Add attributes .
The CSV file must be created. Refer to the following format specifications.
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 as the header title. Enter existing host names in the rows. This value must be the unique Host Name, not the value identified as Host Display Name.
Subsequent columns - list the existing attribute name as the header title. Enter possible values for the attribute as a comma separate list in the corresponding rows.
See Examples of attributes and values.
You can leave a table cell unpopulated to remove pre-existing values and the attribute will be unassigned from the corresponding Host.
Only list a host once. If a host name is listed in multiple rows, only the attributes from the last row with the same host name will be saved.
Table: CSV format specifications
Hosts | Attribute Name 1 | Attribute Name 2 | Attribute Name X |
|---|---|---|---|
Host name 1 | Attribute value | Attribute value | |
Host name 2 | Attribute value | Attribute value | |
Host name X | Attribute value | Attribute value | Attribute value |
To import host attribute values from a CSV file
- Prepare the CSV according the previous format specifications.
- Select Inventory.
- Verify your hierarchy is set to display by Inventory Object Type.
- Select the Hosts folder and set to list view.
- Click Import Host Attributes to select the prepared CSV file. The results of the intermediate import are displayed.
- Review the intermediate import results:
In the Data from CSV table, red entries indicate hosts that are not recognized in the Portal.
In the Hosts not found in the portal - import will be skipped table, the list of Host Names read from the CSV, but were not found in the IT Analytics database are displayed. No action is taken if Host Names do not exist in the Portal prior to importing Attributes and their values.
See Adding and Editing Hosts and Backup Servers .
Note:
Hosts are listed by the unique Host Name. This is not the Host Display Name.
- Create new attribute values is selected by default to use the import to create new values that do not currently exist in the Portal. If this option is not selected, new values are ignored when imported.
- Click Unassign attribute if import value not present to remove the association between the Host and the Attribute. If the imported CSV file contains unpopulated cells for any attribute values, pre-existing values are removed and the Attribute will be unassigned from the corresponding Host. If this option is not selected, an unpopulated cell in the imported CSV file is ignored.
- Click Import to complete the Import.
