Install-Module -Name HPEOneView.660

## Source URL for HPWE OneView PowerShell modules: https://hewlettpackard.github.io/POSH-HPEOneView/

# Load required PowerShell modules
#Install-Module -Name HPEOneView.660
$Modulename = 'HPEOneView.660'      # Module version must match the HPE OneView appliance version
If (-not (Get-Module -Name $ModuleName -ErrorAction SilentlyContinue)) {
    Import-Module $Modulename
}

$DateTime = $((Get-Date).ToString('yyyy-MM-dd_hh-mm-ss'))
$OutputPath = "$env:USERPROFILE\Documents\Reports\HPOneView"

If ( -Not (Test-Path -Path $OutputPath)) {
    New-Item -ItemType directory -Path $OutputPath
}

Set-Location $OutputPath
$Outputfile = "All-HPOneView-Servers-$DateTime"

# List of all HP OneView appliances
$ListOfHPEOneViewAppliances = (
    "<FQDN/IP address of HPE OneView server #1",
    "oneview.yourdomain.local",
    "10.10.10.50"
)

## Get credentials
$CredentialPrompt = "Please enter the username and password to connect with the HPE OneView server(s) : "
$Credentials = Get-Credential -Message $CredentialPrompt


## Connect to HP OneView appliances
ForEach ($HPOneViewAppliance in $ListOfHPEOneViewAppliances) {
    Connect-OVMgmt -Hostname $HPOneViewAppliance -Credential $Credentials
}

# Show a list of all connected HPE OneView servers
$ConnectedSessions

# Acquire server information
$HostReport = New-Object System.Collections.ArrayList
$ListOfServers = New-Object System.Collections.ArrayList

$ListOfServers = Get-OVServer -ApplianceConnection $ListOfHPEOneViewAppliances | Select-Object -Property *
$ListOfServers.Count

Foreach ($Server in $ListOfServers) {
    Write-Host "Processing host" $Server.Servername

    $HostObject = New-Object -TypeName psobject

    $HostObject | Add-Member -MemberType NoteProperty -Name SerialNumber -Value $Server.SerialNumber # Serialnumber needs to be first for VLOOKUP to work in Excel
    $HostObject | Add-Member -MemberType NoteProperty -Name Name -Value $Server.Name
    $HostObject | Add-Member -MemberType NoteProperty -Name "Server Name" -Value $Server.ServerName
    $HostObject | Add-Member -MemberType NoteProperty -Name ServerModel -Value $Server.model
    $HostObject | Add-Member -MemberType NoteProperty -Name ProductNumber -Value $Server.partNumber
    $HostObject | Add-Member -MemberType NoteProperty -Name "RAM Count - Gb" -Value ($Server.memoryMB / 1024)
    $HostObject | Add-Member -MemberType NoteProperty -Name processorType -Value $Server.processorType
    $HostObject | Add-Member -MemberType NoteProperty -Name processorSpeedMhz -Value $Server.processorSpeedMhz
    $HostObject | Add-Member -MemberType NoteProperty -Name processorCount -Value $Server.processorCount
    $HostObject | Add-Member -MemberType NoteProperty -Name processorCoreCount -Value $Server.processorCoreCount
    $HostObject | Add-Member -MemberType NoteProperty -Name "BIOS version" -Value $Server.romVersion
    $HostObject | Add-Member -MemberType NoteProperty -Name formFactor -Value $Server.formFactor
    $HostObject | Add-Member -MemberType NoteProperty -Name iLOmodel -Value $Server.mpModel
    $HostObject | Add-Member -MemberType NoteProperty -Name iLOLicenseType -Value $Server.mpLicenseType
    $HostObject | Add-Member -MemberType NoteProperty -Name iLOFirmwareVersion -Value $Server.mpFirmwareVersion
    $HostObject | Add-Member -MemberType NoteProperty -Name "iLO host name" -Value $Server.mpHostInfo.mpHostName
    $HostObject | Add-Member -MemberType NoteProperty -Name "iLO IP name" -Value ($Server.mpHostInfo.mpIPaddresses | Where-Object { $_.address -like "*.*.*.*" } | Select-Object -ExpandProperty address)
    $HostObject | Add-Member -MemberType NoteProperty -Name "Source OneView appliance" -Value $Server.ApplianceConnection.Name

    $HostReport.add($HostObject) | Out-Null
}

$HostReport = $HostReport | Sort-Object Name
$HostReport | Export-Csv "$Outputfile.csv" -NoTypeInformation -UseCulture

# Housekeeping - let's disconnect the connected sessions
$ConnectedSessions | Disconnect-OVMgmt