Load array attributes and values and assign to arrays

Function: The Load Array Attributes utility provides an efficient method of assigning attributes to a large number of arrays.

Take the following steps to load array attributes and values:

Create a CSV File of Arrays, Attributes and Values.
Execute the Load Array Attribute Utility.
Verify the Array Attributes Load.
Create a report template using a Report Template Designer.

Once attribute values are assigned to hosts, a Report Template Designer report can query the database to report on arrays, filtered by the attributes that you've created to categorize them.

Create a CSV File of Arrays, Attributes, and Values

In preparation for loading array attributes, you will need to enter information into a spreadsheet from which you will create a comma-separated values (CSV) file. The table in the spreadsheet should be in the following format:

Columns

One column lists the arrays, which must already exist in the IT Analytics database.
Each additional column lists attributes and values.

Rows

First (Header) Row - Enter the object type--in this case, Array Name--followed by attribute names. Note that any column may be used for the list of array names. When you run the utility, you'll indicate which column contains the array names. The header row is information only and is not processed as a data row.
Subsequent rows list arrays, followed by the attribute values that you are assigning to each array.

Execute the Load Array Attribute Utility

Before You Begin

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)

To assign attributes to arrays

Note:

This utility only assigns attributes to active arrays. If an array exists in the system, but it is inactive, the log will indicate that no attribute was assigned.

Create a table in a spreadsheet.
Save the table as a comma-separated file (for example, ArrayAttributes.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

Execute the following at the SQL prompt:

SQL> Execute load_package.loadArrayAttributeFile
('pathname_and_filename','domain_name',
array_name_column_num,'log_path_name',
'log_file_name','check_valid_value');

Where:

'pathname_and_filename'	Full path + filename (enclosed in single straight quotes) of the CSV file you created.
'domain_name'	Name (enclosed in single straight quotes) of the IT Analytics domain in which the arrays reside.
array_name_column_num	Column number in the csv file where the array names are listed. These arrays must already exist in the IT Analytics database. Typically, this would be column 1.
'log_path_name'	Full path (enclosed in single straight quotes) where the log file will be created/updated. Verify that you have write access to this directory. Example: 'C:\tmp' Optional: If you do not specify a path and log file name, only error messages will be written to the scon.err file. To omit this parameter, enter: ''
'log_file_name'	Filename of the log where execution status and errors messages are written. Example: 'ArrayAttributeLoad.log' Optional: If you do not specify a path and log file name, only error messages will be written to the scon.err file. To omit this parameter, enter: ''
'check_valid_value'	'Y' or 'N' Indicates if you want the utility to check if the values provided in this file are among the existing possible values for the attributes. Y or N must be enclosed in single straight quotes.

Example:

Execute load_package.loadArrayAttributeFile
('C:\myfiles\ArrayAttributes.csv','QA_Portal',
1,'C:\tmp','ArrayAttributeLoad.log','Y');

Restart the Portal services so that the newly added attributes become available in the Dynamic Template Designer.

Verify the Array Attributes Load

To verify that the attribute load took effect:

In the Portal, go to Reports.
Select a blue user folder.
Select New SQL Template.
With the SQL Template Designer open, click the Query tab.
Enter the following query in the SQL Template Designer to verify Array attributes:
```
select * from aps_v_storage_array_attribute
```

Load array attributes and values and assign to arrays

Feedback

Feedback