topic Re: Drive Report - Custom Report in HPE OneView

Drive Report - Custom Report

ServerParrott — Thu, 16 May 2019 08:54:57 GMT

Hi,

I have found the inbuilt reports on OneView and the Global Dashboard to be sufficient enough so far, however, due to orders beyond my control, it's become necessary to create a report of what models of drives we have in all of our servers. Now obviously I don't want to click on each server in OneView and go to the hardware view, or even worse, go to every single iLO.

Is it possible to create a custom report with the drive model/part number information?

If so, how?

Any specific powershell modules to install?

Any help would be greatly appreciated.

Thanks

Re: Drive Report - Custom Report

ServerParrott — Thu, 16 May 2019 10:51:26 GMT

@ChrisLynch Sorry to tag you directly, any thoughts on this?

Re: Drive Report - Custom Report

ChrisLynch — Tue, 16 Jul 2024 06:14:36 GMT

There are two requirements:

You need to have HPE OneView 4.20 installed.
Only Gen10 servers can report their drive inventory today.
You can use any REST API client, including PowerShell to get server objects.

The Get-HPOVServer Cmdlet will return the server objects. However, the returned object will not contain the local storage details. So, if you have Gen10's, you can do something like:

(Get-HPOVServer | ? model -match 'Gen10' | select -fir 1 | % { sr -uri ($_.uri + '/localStorage' )
 }).Data

Which then returns something similar to:

AdapterType                                   : SmartArray
BackupPowerSourceStatus                       : Present
CacheMemorySizeMiB                            : 1024
CurrentOperatingMode                          : Mixed
EncryptionCryptoOfficerPasswordSet            : False
EncryptionCspTestPassed                       : False
EncryptionEnabled                             : False
EncryptionFwLocked                            : False
EncryptionHasLockedVolumesMissingBootPassword : False
EncryptionMixedVolumesEnabled                 : False
EncryptionSelfTestPassed                      : False
EncryptionStandaloneModeEnabled               : False
ExternalPortCount                             : 0
FirmwareVersion                               : @{Current=}
InternalPortCount                             : 2
Location                                      : Slot 0
LocationFormat                                : PCISlot
Model                                         : EMBEDDED CONTROLLER
Name                                          : HpSmartStorageArrayController
PhysicalDrives                                : {@{BlockSizeBytes=512; CapacityLogicalBlocks=286677120;
                                                CapacityMiB=139264; EncryptedDrive=False; FirmwareVersion=;
                                                Location=1I:1:1; Model=EH0146FCBVL; SerialNumber=SGH101X2RN; Status=},
                                                @{BlockSizeBytes=512; CapacityLogicalBlocks=286677120;
                                                CapacityMiB=139264; EncryptedDrive=False; FirmwareVersion=;
                                                Location=1I:1:2; Model=EH0146FCBVL; SerialNumber=confidential info erased; Status=}}
SerialNumber                                  : 0PR0X0E9T0
Status                                        : @{Health=Warning; State=Enabled}

The PhysicalDrives property will contain the drives for that server. The inventory view is only as current as the last time the server was powered on.

Re: Drive Report - Custom Report

Bruce_Lundeby — Thu, 16 May 2019 20:53:25 GMT

I cannot talk about product futures, but you might keep a lookout for features in Global Dashboard in the very near future.

Re: Drive Report - Custom Report

ServerParrott — Fri, 17 May 2019 14:44:01 GMT

Hi Chris! Thanks for the reply! We do have a few G10's knocking around so this is helpful!

Thanks!

Re: Drive Report - Custom Report

ServerParrott — Fri, 17 May 2019 14:44:45 GMT

Sounds intriguing Bruce! Will do. Thanks.

Re: Drive Report - Custom Report

ric9887 — Sat, 01 Feb 2020 10:06:52 GMT

These Powershell scripts produce a useful CSV of HDD/SSD s/n's from OV or just through ILO connectivity for Gen 10's.

https://github.com/HewlettPackard/oneview-powershell-samples/tree/master/OneView-Inventory-SAS-SSD

Am hoping this fuctionality will be added into OV reporting at some point.

Re: Drive Report - Custom Report

Johannes_we — Fri, 12 Jan 2024 16:37:40 GMT

For anyone out there looking for a way to acheive this using PowerShell

$servers = (Get-OVServer | ? generation -like 'Gen1*' ) $list = foreach($server in $servers) { Get-RSOVServerDiskInfo -Server $server } function Get-RSOVServerDiskInfo { Param( $Server) foreach($disk in (Send-OVRequest -uri ($server.uri + '/localStorage' )).Data.PhysicalDrives) { $item = "" | select Name,Disk,Firmware,CapacityGB,Location,Health $item.Name = $server.name $item.Disk = $disk.model $item.Firmware = $disk.firmwareversion.current.VersionString $item.Location = $disk.location $item.CapacityGB = $disk.CapacityGB $item.Health = $disk.status.health $item } }

Re: Drive Report - Custom Report

NJK-Work1 — Wed, 10 Jul 2024 18:52:20 GMT

Is there an updated version of this script that supports the Gen11 model? The "Data" property for localstorage at that URI is blank for all Gen11 servers that I tested. The Gen10 servers, it works great...but Ge11 I get nada. All our Gen11 servers have SSD drives, whereas the Gen10 servers are all old-school mechanical drives - does that matter?

Thanks.

Re: Drive Report - Custom Report

ChrisLynch — Wed, 10 Jul 2024 22:32:40 GMT

The data is likely within localStorageV2 endpoint. The different controllers across Gen10 and Gen11 provide different Redfish endpoints, which in turn is just pass-through data from the iLO. The following modified script should provide what you are looking for:

(Get-OVServer | ? generation -like 'Gen1*' ) | ForEach { foreach ($disk in (Send-OVRequest -uri ($_.uri + '/localStorageV2' )).Data.PhysicalDrives) { $item = "" | select Name,Disk,Firmware,CapacityGB,Location,Health $item.Name = $server.name $item.Disk = $disk.model $item.Firmware = $disk.firmwareversion.current.VersionString $item.Location = $disk.location $item.CapacityGB = $disk.CapacityGB $item.Health = $disk.status.health $item } }

Re: Drive Report - Custom Report

NJK-Work1 — Thu, 11 Jul 2024 13:59:32 GMT

Excellent - I will try it out. Thank you.

Re: Drive Report - Custom Report

NJK-Work1 — Thu, 11 Jul 2024 14:20:29 GMT

FYI...looks like it is "data.drives" now and not "data.physicaldrives" for the gen11 at the "/localStorageV2" uri. But, does appears to be working.

Thanks again.

Re: Drive Report - Custom Report

NJK-Work1 — Tue, 16 Jul 2024 06:15:57 GMT

@ChrisLynch One more question...looks like firmware is not available for the Gen11 version of the data, but I do see something called "Revision". Would "Revision" represent the same thing as "Firmware"?

Thanks.

Re: Drive Report - Custom Report

ChrisLynch — Tue, 16 Jul 2024 21:40:09 GMT

Can you provide a sample output from what you get? I don't have a Gen11 server at the moment to verify. Keep in mind that the data here is passed-through from the iLO in its native Redfish format. So any changes to the format and data is controlled by the iLO.

Re: Drive Report - Custom Report

DaveMorris — Tue, 29 Oct 2024 17:07:09 GMT

I have a quick script to pull from OneView. It's a bit rough but works.

You'll need to have a connection open first to OV, then run it.

https://github.com/dmorriselc/hponeview/tree/main