Hi,
I want to create a CSV file to list the above
I have the following working ok but when I add the "Canonical Name" using the Get-ScsiLun i get an error.
"
Get-ScsiLun : 2/5/2014 3:33:55 PM Get-ScsiLun Object reference not set to an instance of an object.
At line:6 char:52
+ ForEach($mylun in ($myds |Get-Scsilun <<<< |sort-object -property Name)) {
+ CategoryInfo : NotSpecified: (:) [Get-ScsiLun], VimException
+ FullyQualifiedErrorId : Core_BaseCmdlet_UnknownError,VMware.VimAutomation.ViCore.Cmdlets.Commands.Host.GetScsiLun
It is important for me to get both Datastore and canonical name
Can someone please help
This is the script
$VmInfo = ForEach ($Datacenter in (Get-Datacenter | Sort-Object -Property Name)) {
ForEach ($Cluster in ($Datacenter | Get-Cluster | Sort-Object -Property Name)) {
ForEach ($VM in ($Cluster | Get-VM | Sort-Object -Property Name)) {
ForEach($myHost in ($VM |Get-VMhost |sort-object -property Name)) {
ForEach($myds in ($VM |Get-datastore |sort-object -property Name)) {
ForEach($mylun in ($myds |Get-Scsilun |sort-object -property Name)) {
ForEach ($HardDisk in ($VM | Get-HardDisk | Sort-Object -Property Name)) {
"" | Select-Object -Property @{N="VM";E={$VM.Name}},
@{N="Datacenter";E={$Datacenter.name}},
@{N="Cluster";E={$Cluster.Name}},
@{N="VM Host";E={$myHost.name}},
@{N="Capacity GB";E={$myds.CapacityGB}},
@{N="Capacity Free GB";E={$myds.FreeSpaceGB}},
@{N="SCSI";E={$mylun.CanonicalName},
@{N="Hard Disk";E={$HardDisk.Name}},
@{N="Datastore";E={$HardDisk.FileName.Split("]")[0].TrimStart("[")}},
@{N="VMDKpath";E={$HardDisk.FileName}}
}
}
}
}
}
}
}
}
$VmInfo | Export-Csv -NoTypeInformation -UseCulture -Path "C:\xfer\rj\VmQuery.csv"
Thanks and regards
Joseph
