making a list off all my running vm's with powershell. want to change my output

Question

For another script im making i need a list of my VM's. I use the following script for that:

Add-PSSnapin VMware.VimAutomation.Core Connect-VIServer vmXX Connect-VIServer vmXI $vms = get-vm | where { ($_.powerstate -eq "poweredon") } $rows = @() Foreach ($VM in $vms) { $View = $VM | get-view $Config = $View.config if ($Config.Template) { continue } $row = New-Object -TypeName PSObject $row | Add-Member -MemberType NoteProperty -Name $Config.Name $rows += $row }

Now this outputs the names as VM : VMXX - Build Server I've tried -replace and -trim but i cant find a way to just get a clean list with only VM names in it and nothing else.

what are you trying to achieve? What properites do you need? to only get vm names you dont need all that script, just use Get-VM | Select -Expand Name or in your case $Rows = $vms | Select -Expand Name — Avshalom
– Avshalom, Commented Aug 19, 2015 at 8:45

ATek · Accepted Answer · 2015-08-19 17:08:01Z

I think the main thing you were missing is the -Name "" -Value "" format in your Add-Member line.

Something like this.

Add-PSSnapin VMware.VimAutomation.Core Connect-VIServer @("svc01","svc02") -WarningAction 0 -Force $vms = Get-VM | Where-Object { ($_.powerstate -eq "PoweredOn") } $rows = @() ForEach ($vm in $vms) { if ($($vm | Get-View).config.template) { continue } $row = New-Object -TypeName PSObject $row | Add-Member -MemberType NoteProperty -Name "Name" -Value $vm.Name $rows += $row } $rows

After some more recearch i turned my script into the following which seems to do the trick:

gokhuysen · Accepted Answer · 2015-08-20 09:26:05Z

i changed my code to the following which seems to do the trick:

Add-PSSnapin VMware.VimAutomation.Core Connect-VIServer vmXX $outfile1 = "d:\beheer\scripts\XX.csv" $FileExists = Test-Path $outfile1 If ($FileExists -eq $True) { del $outfile1 } foreach ($vmachine in Get-VM | where {$_.powerstate -eq "poweredon"} |where { $_.ExtensionData.Config.ManagedBy.extensionKey -notmatch "com.vmware.vcDr" }| sort ) { $list = $vmachine.Name $VM = $list -split (" ") $vm1 = $VM[0] | Out-File $outfile1 -append } Connect-VIServer vm65 # PowerShell Checks If a File Exists $outfile1 = "d:\beheer\scripts\CommVault\VMlist.csv" foreach ($vmachine in Get-VM | where {$_.powerstate -eq "poweredon"} |where { $_.ExtensionData.Config.ManagedBy.extensionKey -notmatch "com.vmware.vcDr" } | sort ) { $list = $vmachine.Name $VM = $list -split (" ") $vm1 = $VM[0] | Out-File $outfile1 -append }

Collectives™ on Stack Overflow

making a list off all my running vm's with powershell. want to change my output

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related