Powercli output

[vmstoani]

Hi,

The following Script brings double entries of each vm in the csv file.

Get-VM | Get-VMGuest | where-object {$_.State -eq 'Running' -and $_.OSFullName -Like '*Windows*'} | Select VmName, ToolsVersion, OSFullName | export-csv D:\Scripts\VM\VMTools\VMwareToolsVersionWindows_oh.csv

How can i change this?

thx

regards andi

-------------------------------------------

[brentmillerdoj]

No reason those commands on their own should pull double entries.  I suggest making sure you're not connected to vCenter twice in the same PowerCLI session.

Your current connection vCenter session can be viewed in the variable $global:DefaultVIServers

-------------------------------------------

[vmstoani]

Hi,

Correctly. There has been more than one connection to the vCenter.

Many thanks

Andi

-------------------------------------------

[ChrisLeblanc]

You may need to look at the output directly without the CSV part to see what really is going on.

I added one option I use to your code. Select unique ones based on the VMName

Get-VM | Get-VMGuest | where-object {$_.State -eq 'Running' -and $_.OSFullName -Like '*Windows*'} | Sort-Object -Property VMName -Unique | Select VmName, ToolsVersion, OSFullName | export-csv D:\Scripts\VM\VMTools\VMwareToolsVersionWindows_oh.csv

[rastickland]

Have you looked into RVTools from Dell?  it would give you a very similar output with much less work.  Make sure you download the only one from dell, as there are issues with third-party downloads

-------------------------------------------

[ChrisLeblanc]

RVTools is great. Use it all the time. 

-------------------------------------------

[rastickland]

In the downloaded files, some scripts need to be run to connect to multiple vCenters, but it is possible to do

-------------------------------------------

[MohammadHadi Milani]

Use this 

Get-VM | Get-VMGuest | Where-Object { $_.State -eq 'Running' -and $_.OSFullName -like '*Windows*' } | Select-Object VmName, ToolsVersion, OSFullName -Unique | Export-Csv D:\Scripts\VM\VMTools\VMwareToolsVersionWindows_oh.csv -NoTypeInformation

-------------------------------------------