This tool will collect information from an HP 3PAR storage system and output the ATUM compliant csv formatted Storage Device and Storage Logical data sets for upload into Apptio.

To execute the tool, you must set up a python environment on the computer which will execute the script.

Instructions on how to do that can be found here :  Setting up a Python Environment for Data Collection Tools

After Python has been installed, you can download and run the data collection tool. Download the attached file and install the tool using pip.

To do this,  start a command prompt and change directory to where the script downloads. Then run the command "pip install threepar_data_collection-0.1.0.zip"

Directions:

The script has two input modes, file mode and cli mode.

• file mode is for the situation where all of the output from the CLI commands below has been collected into files for the 3par tool to transform into CSVs for upload into Apptio. In file input mode, the script will accept options that will specify the files it is to parse.
• cli mode is for the situation where the output will be gathered by the script connecting to the storage array via SSH and executing all of the commands. In this case, the options to the script are the hostname and username of the 3par system. After the user runs the script, it will prompt the user for the SSH password and then log in to the 3par system and execute all of the cli commands for the user. Once all of the output has been gathered, the script will do the transforms and output the CSV files for upload into Apptio.

Using file input mode

When using file input mode of the script, output from the following commands is required. Login to the 3par system over ssh and capture the output of each command in a separate file.

1. showpd -space
2. showvv -s
3. showvlun

If you are using a Windows system, you will most likely be using PuTTY to ssh to the 3par system for management purposes. In that case you will need to  enable session logging and then log the output of each command. For example, to gather the output of the "showpd -space" command, configure a putty session for logging to the filename showpd.txt. Then, start the SSH session and run the command. After that, do the same thing for the other two commands.

After the output has been gathered, put the files in the same directory as the transformation tool.

Run the transformation tool to produce the CSVs for upload into Apptio. Two files will be produced that are the Storage Logical data set and Storage Device data set for the array.

Example usage for file mode:

    threepar_data_collection.py --location Middlefield --showpd_file showpd.txt --showvv_file showvv.txt --showvlun_file showvlun.txt

Using cli input mode

When using cli mode, you do not need to run the cli commands yourself. Use the  input mode option in the script to set the input mode to "cli" and add the hostname and username of the 3par system instead of the file names.

The output will be the CSV files that are ready to upload into Apptio.

Example usage for cli mode: