This section explains the power consumption data file format (CSV format).
Each defined item of the exported power consumption data is separated by a comma (",").
Each line is exported in the following format.
Data format
Data is exported using the following format:
Time,target_name(data_type)[,target_name(data_type)]... |
Header line
The header line contains column titles identifying the data (from line 2 and later) that is displayed under each column. Each column title is set according to the data types that have been selected in the [Export Environmental Data (target_type)] dialog.
Time
This column displays the date and time at which each data sample was collected.
Within data lines, the entry corresponding to this column is displayed in the following format: "YYYY-MM-DD hh:mm:ss" ("YYYY": Year, "MM": Month, "DD": Date, "hh:mm:ss": Hours:Minutes:Seconds). The time is displayed according to the time zone set in the Admin Server operating system.
target_name(data_type)
This column title defines the device and data type of the value displayed in the data lines under each column.
The target_name part displays the name of the selected target.
The data_type part displays the selected data type. Power (W) is shown as "power", Average Power (W) as "power-average", and Energy (Wh) as "energy".
Data lines
Each data line contains data values corresponding to each of the column titles shown in the header line.
A hyphen ("-") is displayed for any data that could not be collected.
Note
Regardless of the specified power monitoring target, the data held within Resource Coordinator VE that fits the conditions given for the selected time span and rate will be exported.
Depending on the status(es) of specified power monitoring target(s), the data corresponding to the specified time span and rate may not have been collected.
In this case, a hyphen ("-") will be displayed for any data that could not be collected.
Hyphens can be displayed when data was collected from another power monitoring target (including a deleted one) at the same collection time, and data was not collected from the specified power monitoring target.
No data is collected from servers on which ServerView Agent is not running. In this case, missing data is shown using hyphens ("-").
When exporting power consumption data, data collection itself may still be in-progress. In this case, a hyphen ("-") will be displayed for any data that hasn't been collected yet.
If the "Finest sampling" rate is selected in the [Export Environmental Data (target_type)] dialog, the power and average power values will be equal for each data sample.
If a rate other than "Finest sampling" has been selected in the [Export Environmental Data (target_type)] dialog, values for each sample are displayed as follows. If data was collected at the displayed sample time, that value is displayed. If no data was collected at the displayed sample time, the data that was last collected in the time interval between that sample and the previous sample will be displayed.
The energy (Wh) value of a finest sample is calculated under the assumption that the power value (W) collected for the sample stayed at the same value until the next sampling (in other words it is assumed that power values (W) do not vary during the duration of the polling interval).
Only daily average data can be collected from blade chassis.
Data collected from servers do not include power consumed by storage blades.
For rates other than "Finest sampling", the energy value is calculated as the sum of energy samples. The energy value of samples for which no data could be collected will be deemed to be 0.
The average power (W) of each sample is calculated from the energy value (Wh) of that sample and its corresponding time interval.
