HP Scripting Tools for Windows PowerShell - Manual (Page 15)

When a CSV file is imported into PowerShell, it creates an object array that has elements with
member name properties set to the first row names, and each element of the array set to each line
of the spreadsheet.
CSV input file:
Input1.csv:
Server,Username,Password,HostPower
192.168.1.1,admin,admin123,Yes
192.168.1.3,admin,admin123,Yes
If the input CSV file has Server, Username, Password, and the HostPower values, the following
PowerShell script could be used.
PowerShell script:
$path = ".\input1.csv"
$csv = Import-Csv $path
$rt = Set-HPiLOHostPower -Server $csv.Server -Username $csv.Username `
-Password $csv.Password -HostPower $csv.HostPower
$rt | Format-List
$rt = Get-HPiLOHostPower -Server $csv.Server -Username $csv.Username `
-Password $csv.Password
$rt | Format-List
The preceding example imports the CSV file into $csv and then uses the multi-valued parameters
to operate on multiple iLOs in a single command. The script then gets the current power setting
using the same $csv and lists the results. If both servers were already powered on, the following
output would be displayed.
Script output:
IP : 192.168.1.1
HOSTNAME : ilohostbc.company.net
STATUS_TYPE : WARNING
STATUS_MESSAGE : {Host power is already ON.}
IP : 192.168.1.3
HOSTNAME : isabella-vp2.company.net
STATUS_TYPE : WARNING
STATUS_MESSAGE : {Host power is already ON.}
IP : 192.168.1.1
HOSTNAME : ilohostbc.company.net
STATUS_TYPE : OK
STATUS_MESSAGE : OK
HOST_POWER : ON
IP : 192.168.1.3
HOSTNAME : isabella-vp2.company.net
STATUS_TYPE : OK
STATUS_MESSAGE : OK
HOST_POWER : ON
If no errors or warnings were returned from the set cmdlet, only the output from the get cmdlet
would be displayed. Set cmdlets return nothing unless there is an error or warning returned from
iLO.
Alternatively, just the iLO IP address or host name could be stored in the CSV file, if a single user
name, password, and power setting apply to all iLOs.
Using iLO cmdlets on multiple targets 15