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

Page 15
Image 15
HP Scripting Tools for Windows PowerShell manual Hostname

Scripting Tools for Windows PowerShell specifications

HP Scripting Tools for Windows PowerShell is a powerful suite designed to enhance the management and automation of HP devices and services within a Windows environment. With a robust approach to system administration, it allows IT professionals and system administrators to streamline their workflows, manage resources more effectively, and reduce manual interventions.

One of the main features of HP Scripting Tools is the integration of HP's extensive hardware and software management capabilities into PowerShell. By leveraging PowerShell's scripting abilities, users can automate the configuration, monitoring, and reporting of HP devices at scale. This is particularly beneficial in enterprise settings, where managing a large fleet of devices can become cumbersome and prone to human error.

Among the technologies utilized by HP Scripting Tools is the HP Management Interface, which provides a comprehensive set of cmdlets tailored for handling various HP hardware components, such as servers, printers, and storage solutions. These cmdlets facilitate operations such as retrieving device status, updating firmware, and managing device configurations. This integration simplifies the process of interacting with HP hardware compared to traditional methods, enabling users to perform complex tasks with simple scripts.

Another critical characteristic of HP Scripting Tools is its emphasis on ease of use and accessibility. The tools provide detailed documentation and examples to guide users in writing scripts that address specific needs. Whether automating routine maintenance tasks or deploying configurations across multiple devices, users can rely on the resources provided to optimize their scripting efforts.

Furthermore, HP Scripting Tools supports the management of HP’s software solutions, including HP Smart Admin and HP System Software Manager. This allows for the central management of software updates and configurations, ensuring that systems remain up-to-date and secure with minimal effort.

Additionally, HP Scripting Tools promote collaboration by enabling scripts to be shared across teams, facilitating consistent administration practices. This collaborative environment ensures that best practices are followed and reduces the redundancy of script-writing efforts.

In conclusion, HP Scripting Tools for Windows PowerShell is an invaluable asset for organizations utilizing HP devices, offering essential features to automate management tasks, enhance operational efficiency, and optimize resource utilization. With its powerful cmdlets and seamless integration into PowerShell, it empowers IT professionals to take full control of their HP equipment in a more productive and efficient manner.