Differences

This shows you the differences between two versions of the page.

--- vmware:scripts:getinfo [2018/02/02 17:59] – lunetikk
+++ vmware:scripts:getinfo [2018/04/23 17:53] – lunetikk
@@ Line 10: / Line 10: @@
 $allvminfo = @()
 $vms = Get-Vm
+$targetfile = "C:\Temp\VMInfo.csv"
 foreach($vm in $vms){
 $vminfo = "" | Select Name, Host, Network, PowerState, CPUCount, RAMAssigned, ProvisionedSpace, UsedSpace, UnusedSpace, ConfiguredOS, RunningOS
-$VMHost = Get-VM $vm.Name | select Host
+$VMHost = Get-VMHost -VM $vm
 $VMHost = $VMHost.Host
 $VMNetwork = Get-VM $vm.Name | Select {@($_.guest.IPAddress[0])}
@@ Line 51: / Line 52: @@
 	$allvminfo += $vminfo
 }
-$allvminfo | Select Name, Host, Network, PowerState, CPUCount, RAMAssigned, ProvisionedSpace, UsedSpace, UnusedSpace, ConfiguredOS, RunningOS | Export-Csv "C:\Temp\VMinfos.csv" -noTypeInformation
+$allvminfo | Select Name, Host, Network, PowerState, CPUCount, RAMAssigned, ProvisionedSpace, UsedSpace, UnusedSpace, ConfiguredOS, RunningOS | Export-Csv $targetfile -noTypeInformation
+#The following lines will clean up the .csv
+(Get-Content $targetfile).replace('@{@($_.guest.IPAddress[0])=', '') | Set-Content $targetfile
+(Get-Content $targetfile).replace('@{@($_.ExtensionData.Config.GuestFullname)=', '') | Set-Content $targetfile
+(Get-Content $targetfile).replace('@{@($_.Guest.OsFullName)=', '') | Set-Content $targetfile
+(Get-Content $targetfile).replace('}"', '"') | Set-Content $targetfile
 </code>

Lunetikk's IT Wiki