Hi Craig,
I tried to run this one liner and it works. was able to pull out the VM and the host model associated with it.
get-vm | where-object {$_.PowerState -eq "PoweredOn"} | Select Name, @{N='Model'; E={ (Get-VMHost -Name $_.Host).Model }}
when I incorporate the script you gave me the below is the output I get a bunch of datas.
| PowerState | Version | Description | Notes | Guest | NumCpu | MemoryMB | MemoryGB | HardDisks | NetworkAdapters | UsbDevices | CDDrives | FloppyDrives | Host | HostId | VMHostId | VMHost | VApp | FolderId | Folder | ResourcePoolId | ResourcePool | PersistentId | UsedSpaceGB | ProvisionedSpaceGB | DatastoreIdList | HARestartPriority | HAIsolationResponse | DrsAutomationLevel | VMSwapfilePolicy | VMResourceConfiguration | GuestId | Name | CustomFields | ExtensionData | Id | Uid | Client |
This is how my script looks like now per your recommendation.
Connect-VIServer
$date = Get-Date -format M-d-yyyy
Import-Csv C:\test\vmlisttest.csv -UseCulture | %{
Get-VM -Name $_.Name | where-object {$_.PowerState -eq "PoweredOn"}
Select Name,
@{N='Datacenter';E={Get-Datacenter -VM $_ | Select -ExpandProperty Name}},
@{N='Model'; E={ (Get-VMHost -Name $_.Host).Model }},
@{N='Cluster';E={Get-Cluster -VM $_ | Select -ExpandProperty Name}},
Host,NumCpu, MemoryGB,
ProvisionedSpaceGB,Powerstate,
@{N='Path';E={
$current = Get-View $_.ExtensionData.Parent
$path = $_.Name
do {
$parent = $current
if($parent.Name -ne "vm"){$path = $parent.Name + "\" + $path}
$current = Get-View $current.Parent
} while ($current.Parent -ne $null)
[string]::Join('\',($path.Split('\')[0..($path.Split('\').Count-2)]))
}},
FolderId
} | Export-Csv “C:\test\test-vcenter-test-vmpath-$date.csv” -NoTypeInformation -UseCulture
Any Ideas?
