How to correlate Datastores to LUN ID's

[hugopeeters]

I am trying to retrieve a list of LUNs with the corresponding Datastores created on these luns.

My code so far:

$VIServerName = "viserver"

$VMHostName = "ESXserverFQDN"

$VIServer = Get-VIServer $VIServerName

$VMHost = Get-VMHost $VMHostName

$VMHostStorage = Get-VMHostStorage $VMHost

The properties of the $VMHostStorage object contains all the information I need, but unfortunately it lacks the correlation between the properties. The property $VMHostStorage.ScsiLun contains the LUN's and all properties I find interesting about them. The property $VMHostStorage.FileSystemVolumeInfo contains all datastores (much like the Get-Datastore command retrieves). But both these properties are unsorted arrays.

How can I find the correlation I am looking for?

[LucD]

I'm afraid we have to revert to the SDK to get that kind of info.

This script lists all vmfs filesystem defined on a specific ESX server.

And for each vmfs it lists the devicepath for each extent.

$hss = Get-View (Get-View (Get-VMHost -Name <ESX-name>).ID).ConfigManager.StorageSystem
foreach($mount in $hss.FileSystemVolumeInfo.MountInfo){
  if($mount.Volume.Type -eq "VMFS"){
    foreach($ext in $mount.Volume.Extent){
      Write-Host $mount.Volume.Name $ext.DiskName
    }
  }
}

[ae_jenkins]

Hey LucD. . .can this be expanded to pull in ScsiLUN information? What I'm really looking for is the path information which can show the HBA detail, and SAN path information (hex volume name).

[herve_warin]

Thanks a lot, LucD, this sample is very interesting to me, but I also would be interested in the same script.

Thanks in advance.

[hugopeeters]

I already found a way to get my answer. I compared the LUN path in both arrays.

See my scripting contest contribution for details.

[LucD]

Does this contain what you wanted to see ?

$esxhost = <ESX-host>
$report = @()

$hss = Get-View (Get-View (Get-VMHost -Name $esxhost).ID).ConfigManager.StorageSystem
foreach($mount in $hss.FileSystemVolumeInfo.MountInfo){
  if($mount.Volume.Type -eq "VMFS"){
    foreach($ext in $mount.Volume.Extent){
      foreach($lun in $hss.StorageDeviceInfo.MultipathInfo.Lun){
	    if($lun.Id -eq $ext.DiskName) {break}
	  }
	  foreach($path in $lun.Path){
	    $row = "" | select DSname, Pathname, PathState, PortWWN 
	    $row.DSname = $mount.Volume.Name
		$row.Pathname = $ext.DiskName
		$row.PathState = $path.PathState
		$row.PortWWN = ("{0:x}" -f $path.Transport.PortWorldWideName)
		$report += $row
	  }
    }
  }
}
$report

[ae_jenkins]

Yes - exactly what I was looking for - thanks LucD. Sorry for the late reply: I didn't get an e-mail alert, probably because I didn't open up this discussion.