VM's with RDM's

[wamatha]

Greetings,

We have a number of VM with RDMs in our environment.

I am looking for a script that will generate a csv report with VM name, RDM disk size, and Device ID

Thank you

Joseph

[AlbertWT]

Joseph,

Device ID, do you mean LUN ID for the RDM LUN ?

[vlife201110141 · Accepted solution]

####### Written by LucD only CanonicalName is changed by me #######
$report = @()
$vms = Get-VM | Get-View
foreach($vm in $vms){
foreach($dev in $vm.Config.Hardware.Device){
   if(($dev.gettype()).Name -eq "VirtualDisk"){
      if(($dev.Backing.CompatibilityMode -eq "physicalMode") -or
        ($dev.Backing.CompatibilityMode -eq "virtualMode")){
            $row = "" | select VMName, VMHost, HDDeviceName, HDFileName, HDMode, HDsize, CanonicalName
            $row.VMName = $vm.Name
            $esx = Get-View $vm.Runtime.Host
            $row.VMHost = ($esx).Name
            $row.HDDeviceName = $dev.Backing.DeviceName
            $row.HDFileName = $dev.Backing.FileName
            $row.HDMode = $dev.Backing.CompatibilityMode
            $row.HDSize = $dev.CapacityInKB
            $row.CanonicalName = ($esx.Config.StorageDevice.ScsiLun | where {$_.Uuid -eq $dev.Backing.LunUuid}).CanonicalName
            $report += $row
}}}}
$report

[wamatha]

EMC Device ID

[wamatha]

This is great, how do I export this to a CSV file?

[rsimonsca]

Replace the last line with:

$report | export-csv -notypeinfo -useculture c:\temp\vmrdm-report.csv

-notypeinfo:  Removes the default first line of the CSV file showing the fully qualified name of the .NET framework object

-useculture:  Uses the correct list separator for your location