Accepted Solutions
Hi LucD,
Thanks for your reply, but I m a bit confused with this
[string]::Join(',',($_ | Get-NetworkAdapter | %{$_.Type)})
Where should I add this into my commands ? $VMsItems = Get-VM -Name $ColVM | Select Name, VMHost, PowerState,
@{N="OSFullName";E={($_ | Get-VMGuest).OSFullName}},
@{N="IPAddress";E={($_ | Get-VMGuest).IPAddress}},
@{N="AdapterType";E={($_ | Get-NetworkAdapter).Type}}, <-- I guess it s here right ?
@{N="AdapterName";E={($_ | Get-NetworkAdapter).Name}},
@{N="Datacenter";E={($_ | Get-Datacenter).Name}},
@{N="CardCount";E={($_ | Get-NetworkAdapter).Count}}
Change to this ?
@{N="AdapterType";E={[string]::Join(',',($_ | Get-NetworkAdapter | %{$_.Type)})},
Also, I'll have a look at your Excel Function 
Thanks for your support,
LucD,
I've changed script to this, in bold :
##### CREATE EXCEL #####
$Excel = New-Object -Com Excel.Application
$Excel.visible = $true
$Excel = $Excel.Workbooks.Add(1)
$VM = $Excel.WorkSheets.Item(1)
$VM.Name = "Network Type"
$VM.Cells.Item(1,1) = "VM Name"
$VM.Cells.Item(1,2) = "OS Name"
$VM.Cells.Item(1,3) = "IP Address"
$VM.Cells.Item(1,4) = "VM HOST"
$VM.Cells.Item(1,5) = "VM STATUS"
$VM.Cells.Item(1,6) = "Adapter Type"
$VM.Cells.Item(1,7) = "Adapter Name"
$VM.Cells.Item(1,8) = "DataCenter"
$WorkBook = $VM.UsedRange
$WorkBook.Interior.ColorIndex = 0
$WorkBook.Font.ColorIndex = 5
$WorkBook.Font.Bold = $True
$WorkBook.HorizontalAlignment = -4108
$VmRange = $VM.range("A1:Z500")
$Vmrange.font.size = 8
$intRow = 2
##### CONNECTING VCENTER #####
Connect-VIServer -server $VCenter -User $User -Password $PWD -AllLinked:$true
$VMs = Get-VM | Sort-Object Name
Foreach ($ColVM in $VMs) {
#Gathering Info on $ColVM
$VMsItems = Get-VM -Name $ColVM | Select Name, VMHost, PowerState,
@{N="OSFullName";E={($_ | Get-VMGuest).OSFullName}},
@{N="IPAddress";E={($_ | Get-VMGuest).IPAddress}},
@{N="AdapterName";E={([STRING]::JOIN(',',($_ | Get-NetworkAdapter | %{$_.Name})))}},
@{N="AdapterType";E={([STRING]::JOIN(',',($_ | Get-NetworkAdapter | %{$_.Type})))}},
@{N="Datacenter";E={($_ | Get-Datacenter).Name}},
@{N="CardCount";E={($_ | Get-NetworkAdapter).Count}}
#Filling Excel Report
#Foreach ($Name in ($VMsItems.AdapterType)){
$VM.Cells.Item($intRow,1) = [STRING]$VMsItems.Name
$VM.Cells.Item($intRow,2) = [STRING]$VMsItems.OSFullName
$VM.Cells.Item($intRow,3) = [STRING]$VMsItems.IPAddress
$VM.Cells.Item($intRow,4) = [STRING]$VMsItems.VMHost
$VM.Cells.Item($intRow,5) = [STRING]$VMsItems.PowerState
If ($VMsItems.PowerState -eq "PoweredOn"){$VM.Cells.Item($intRow,5).Interior.ColorIndex = 4}
Else {$VM.Cells.Item($intRow,5).Interior.ColorIndex = 3}
$VM.Cells.Item($intRow,8) = [STRING]$VMsItems.Datacenter
$VM.Cells.Item($intRow,6) = [STRING]$VMsItems.AdapterType
If ($VMsItems.AdapterType -like "*Vmxnet3*") {$VM.Cells.Item($intRow,6).Interior.ColorIndex = 4}
Else {$VM.Cells.Item($intRow,6).Interior.ColorIndex = 3}
$VM.Cells.Item($intRow,7) = [STRING]$VMsItems.AdapterName
$IntRow ++ }
#}
$WorkBook.EntireColumn.AutoFit()
$VM.Columns.Item(2).ColumnWidth = 25
##### SAUVEGARDE #####
$Excel.SaveAs($FILENAME)
##### DECONNEXION VCENTER & KILL EXCEL PROCESS #####
Disconnect-VIServer -server * -Confirm:$false -Force:$true
#Stop-Process -processname excel
Now, I see another problem, objects are correctly populated in the command, $VMs = Get-VM | Sort-Object Name, but they are not filled in excel ...
Here is a sample of the file attached
Do you have any ideas to correct this ?
Thanks,
Julien
I think, the problem is located with SRM protected VMs.
The command doesn t fill excel while it checks protected VMs, which are in a specific ressource pool and a specific folder ...
Do you know a way to filter VMs ? To get all the VMs excepted SRM ressource pool or excepted SRM folder
I have 1 datacenter, with no ressource pool, which is Production
I have a 2sd datacenter, with SRM ressource pool and "Hors-Prod" ressource pool
By the way, thanks a lot for your help 
Julien