Importing from excel worksheets – HP Insight Control Software for Linux User Manual

Page 18

Advertising
background image

3 Managing power and cooling facilities in your data center

Task: Importing power configuration from third-party management software

HP Insight Control power management provides tools to read data from third-party management
software in the form of SQL or web services queries. For each power management supported
third-party management software, a command is provided to generate output in the text format
suitable for use by the ipmimport command. The following integration tools are provided:

nlyte2txt

dcim2txt

eaton2txt

To import power configuration from the third-party management software:
1.

Execute the appropriate integration command redirecting the output to a file using the
capabilities of your local operating system. For example, use the following command to import
data from HP DCIM:

dcim2txt > data.txt

2.

Prior to importing the data into Systems Insight Manager, check the text file for errors using
the ipmtxt2xml command as given in the following sample command text. Insight Control
power management will detect any available rack or slot collision reference in the text file.

ipmtxt2xml data.txt

3.

Import the data.txt file using the following command:

ipmimport data.txt

You can also import data from nlyte and EATON POWER XPERT software.

Task: Importing power configuration from external databases

HP Insight Control power management collects power utilization and capacity data from systems
and devices in a data center and allows an administrator to set a cap on the utilization. Before
power management starts monitoring or managing power consumption of systems and devices, it
requires information on the physical topology of systems and devices and the power topology of
the power delivery devices connected in a data center. The power configuration information is
available in the CMS database, and you can import this information in text formats or Microsoft
Excel worksheets using the power management CLI commands.

Importing from Excel worksheets

In Excel worksheets, the data is normally available in visual layout (VIS) and tabular (TAB) formats.
For example, the data in an Excel worksheet is shown in figure 4:

18

Managing power and cooling facilities in your data center

Advertising
This manual is related to the following products: