<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Script modification to ADD MAC Address against respective NICs_ vCloud Director in vSphere Command-Line Interface Discussions</title>
    <link>https://communities.vmware.com/t5/vSphere-Command-Line-Interface/Script-modification-to-ADD-MAC-Address-against-respective-NICs/m-p/1857447#M856</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear Friends,&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&lt;STRONG&gt;Need some help to modify\update below script to &lt;/STRONG&gt;&lt;SPAN style="text-decoration: underline;"&gt;add a MAC Address Column &lt;/SPAN&gt;&lt;STRONG&gt;in front of each NICs IP.&lt;/STRONG&gt;&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;It is a simple script which connects to &lt;SPAN style="text-decoration: underline;"&gt;vCloud Director&lt;/SPAN&gt;, asks for VAPP and provides details abut it like VM info, Org Networks etc etc.&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;Attached please find the CSV generated by the script and also sample what i am looking forward to add in it.&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;Below is the the script which i am using so far to update my CMDB.&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;===========================================================&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;function exportTRS{&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;try {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;# $date = (Get-Date).ToString("s").Replace(":","-")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$excel = New-Object -ComObject Excel.Application&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$excel.Visible = $false&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$workbook = $excel.Workbooks.Add()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet = $workbook.ActiveSheet&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Name = 'AS Built'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1 = $sheet.range("1:1")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,1) = 'OrgVDC Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,2) = 'vApp Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,3) = 'Server Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,4) = 'eth0'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,5) = 'eth1'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,6) = 'eth2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,7) = 'vCPU'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,8) = 'Memory'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,9) = 'Storage'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,10) = 'Guest OS Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3 = $sheet.range("2:2")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3.Cells.Interior.ColorIndex = 56&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3.Cells.Font.ColorIndex = 2&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(2,4) = 'Prod'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(2,5) = 'Nic2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(2,6) = 'Nic3'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2 = $sheet.range("50:50")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(50,1) = 'OrgVDCs networks connected'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(50,2) = 'Gateway'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(50,3) = 'Subnet Mask'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;#$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row = 3&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$nume_VAPP = read-host "Please Enter the Name of the VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;write-host "Getting vApp Properties for $nume_VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$vapp = Get-CIVApp -Name $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$orgtemp = $vapp.Org.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$name = $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$date = (Get-Date).ToString("d")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;write-host "Searching for organization $orgtemp"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$Org = Search-Cloud -QueryType Organization -Name "$orgtemp";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;write-host "Searching for organization VDC with $($Org.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$aOvdcs = Search-Cloud -QueryType AdminOrgVdc -Filter "org==$($Org.id)";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$aVApps = Search-Cloud -QueryType AdminVApp -Filter "Name==$name";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$VappOrgID = $aVApps.PropertyList.Vdc&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$OrgName = Get-OrgVDC -ID $VappOrgID&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;Write-host "Getting VM information"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$vms = Get-CIVM -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;#$vms = search-cloud -querytype Adminvm -Filter "container==$($vapp.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;foreach ($vm in $vms ){&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$hardware = $vm.ExtensionData.GetVirtualHardwareSection()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$diskMB = (($hardware.Item | where {$_.resourcetype.value -eq "17"}) | %{$_.hostresource[0].anyattr[0]."#text"} |&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;Measure-Object -Sum).sum&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$diskGB = ($diskMB/1024)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$adapters = Get-CINetworkAdapter -VM $vm&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sortadapters = $adapters | Sort-Object&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $OrgName.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.VApp.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $sortadapters[0].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $sortadapters[1].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; $sheet.cells.Item($row,$column) = $sortadapters[2].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.CpuCount&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.memoryGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $diskGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.GuestOSFullName&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$net = Get-CIVAppNetwork -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row = 51&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[0].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[0].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[0].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[1].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[1].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[1].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[2].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[2].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[2].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$objRange = $sheet.UsedRange&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;[void] $objRange.EntireColumn.Autofit()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$filename = "C:\Work\ASB_$name.xlsx"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$workbook.SaveAs($filename)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$excel.Quit()&lt;SPAN style="white-space:pre;"&gt; &lt;/SPAN&gt;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;catch {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp; Write-Warning $_.Exception.Message&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;connect-ciserver XXXXXXXX -User XXXXXXX -Password XXXXXXXX&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;exportTRS&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;function exportTRS{&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;try {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;# $date = (Get-Date).ToString("s").Replace(":","-")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$excel = New-Object -ComObject Excel.Application&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$excel.Visible = $false&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$workbook = $excel.Workbooks.Add()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet = $workbook.ActiveSheet&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Name = 'AS Built'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1 = $sheet.range("1:1")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,1) = 'OrgVDC Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,2) = 'vApp Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,3) = 'Server Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,4) = 'eth0'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,5) = 'eth1'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,6) = 'eth2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,7) = 'vCPU'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,8) = 'Memory'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,9) = 'Storage'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,10) = 'Guest OS Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3 = $sheet.range("2:2")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3.Cells.Interior.ColorIndex = 56&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3.Cells.Font.ColorIndex = 2&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(2,4) = 'Prod'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(2,5) = 'Nic2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(2,6) = 'Nic3'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2 = $sheet.range("50:50")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(50,1) = 'OrgVDCs networks connected'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(50,2) = 'Gateway'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(50,3) = 'Subnet Mask'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;#$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row = 3&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$nume_VAPP = read-host "Please Enter the Name of the VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;write-host "Getting vApp Properties for $nume_VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$vapp = Get-CIVApp -Name $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$orgtemp = $vapp.Org.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$name = $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$date = (Get-Date).ToString("d")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;write-host "Searching for organization $orgtemp"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$Org = Search-Cloud -QueryType Organization -Name "$orgtemp";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;write-host "Searching for organization VDC with $($Org.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$aOvdcs = Search-Cloud -QueryType AdminOrgVdc -Filter "org==$($Org.id)";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$aVApps = Search-Cloud -QueryType AdminVApp -Filter "Name==$name";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$VappOrgID = $aVApps.PropertyList.Vdc&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$OrgName = Get-OrgVDC -ID $VappOrgID&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;Write-host "Getting VM information"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$vms = Get-CIVM -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;#$vms = search-cloud -querytype Adminvm -Filter "container==$($vapp.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;foreach ($vm in $vms ){&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$hardware = $vm.ExtensionData.GetVirtualHardwareSection()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$diskMB = (($hardware.Item | where {$_.resourcetype.value -eq "17"}) | %{$_.hostresource[0].anyattr[0]."#text"} |&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;Measure-Object -Sum).sum&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$diskGB = ($diskMB/1024)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$adapters = Get-CINetworkAdapter -VM $vm&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sortadapters = $adapters | Sort-Object&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $OrgName.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.VApp.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $sortadapters[0].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $sortadapters[1].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; $sheet.cells.Item($row,$column) = $sortadapters[2].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.CpuCount&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.memoryGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $diskGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.GuestOSFullName&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$net = Get-CIVAppNetwork -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row = 51&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[0].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[0].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[0].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[1].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[1].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[1].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[2].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[2].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[2].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$objRange = $sheet.UsedRange&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;[void] $objRange.EntireColumn.Autofit()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$filename = "C:\Work\ASB_$name.xlsx"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$workbook.SaveAs($filename)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$excel.Quit()&lt;SPAN style="white-space:pre;"&gt; &lt;/SPAN&gt;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;catch {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp; Write-Warning $_.Exception.Message&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;connect-ciserver XXXXXXXX -User XXXXXXX -Password XXXXXXXX&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;exportTRS&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 24 Oct 2018 09:09:04 GMT</pubDate>
    <dc:creator>MrSiddiqui</dc:creator>
    <dc:date>2018-10-24T09:09:04Z</dc:date>
    <item>
      <title>Script modification to ADD MAC Address against respective NICs_ vCloud Director</title>
      <link>https://communities.vmware.com/t5/vSphere-Command-Line-Interface/Script-modification-to-ADD-MAC-Address-against-respective-NICs/m-p/1857447#M856</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear Friends,&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;&lt;STRONG&gt;Need some help to modify\update below script to &lt;/STRONG&gt;&lt;SPAN style="text-decoration: underline;"&gt;add a MAC Address Column &lt;/SPAN&gt;&lt;STRONG&gt;in front of each NICs IP.&lt;/STRONG&gt;&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;It is a simple script which connects to &lt;SPAN style="text-decoration: underline;"&gt;vCloud Director&lt;/SPAN&gt;, asks for VAPP and provides details abut it like VM info, Org Networks etc etc.&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;Attached please find the CSV generated by the script and also sample what i am looking forward to add in it.&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;Below is the the script which i am using so far to update my CMDB.&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;P&gt;===========================================================&lt;/P&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;function exportTRS{&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;try {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;# $date = (Get-Date).ToString("s").Replace(":","-")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$excel = New-Object -ComObject Excel.Application&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$excel.Visible = $false&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$workbook = $excel.Workbooks.Add()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet = $workbook.ActiveSheet&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Name = 'AS Built'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1 = $sheet.range("1:1")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range1.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,1) = 'OrgVDC Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,2) = 'vApp Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,3) = 'Server Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,4) = 'eth0'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,5) = 'eth1'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,6) = 'eth2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,7) = 'vCPU'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,8) = 'Memory'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,9) = 'Storage'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(1,10) = 'Guest OS Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3 = $sheet.range("2:2")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3.Cells.Interior.ColorIndex = 56&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3.Cells.Font.ColorIndex = 2&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range3.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(2,4) = 'Prod'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(2,5) = 'Nic2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(2,6) = 'Nic3'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2 = $sheet.range("50:50")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$range2.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(50,1) = 'OrgVDCs networks connected'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(50,2) = 'Gateway'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.Cells.Item(50,3) = 'Subnet Mask'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;#$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row = 3&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$nume_VAPP = read-host "Please Enter the Name of the VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;write-host "Getting vApp Properties for $nume_VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$vapp = Get-CIVApp -Name $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$orgtemp = $vapp.Org.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$name = $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$date = (Get-Date).ToString("d")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;write-host "Searching for organization $orgtemp"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$Org = Search-Cloud -QueryType Organization -Name "$orgtemp";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;write-host "Searching for organization VDC with $($Org.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$aOvdcs = Search-Cloud -QueryType AdminOrgVdc -Filter "org==$($Org.id)";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$aVApps = Search-Cloud -QueryType AdminVApp -Filter "Name==$name";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$VappOrgID = $aVApps.PropertyList.Vdc&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$OrgName = Get-OrgVDC -ID $VappOrgID&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;Write-host "Getting VM information"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$vms = Get-CIVM -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;#$vms = search-cloud -querytype Adminvm -Filter "container==$($vapp.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;foreach ($vm in $vms ){&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$hardware = $vm.ExtensionData.GetVirtualHardwareSection()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$diskMB = (($hardware.Item | where {$_.resourcetype.value -eq "17"}) | %{$_.hostresource[0].anyattr[0]."#text"} |&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;Measure-Object -Sum).sum&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$diskGB = ($diskMB/1024)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$adapters = Get-CINetworkAdapter -VM $vm&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sortadapters = $adapters | Sort-Object&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $OrgName.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.VApp.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $sortadapters[0].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $sortadapters[1].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; $sheet.cells.Item($row,$column) = $sortadapters[2].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.CpuCount&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.memoryGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $diskGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $vm.GuestOSFullName&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$net = Get-CIVAppNetwork -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row = 51&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[0].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[0].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[0].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[1].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[1].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[1].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[2].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[2].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$sheet.cells.Item($row,$column) = $net[2].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$objRange = $sheet.UsedRange&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;[void] $objRange.EntireColumn.Autofit()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$filename = "C:\Work\ASB_$name.xlsx"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$workbook.SaveAs($filename)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;$excel.Quit()&lt;SPAN style="white-space:pre;"&gt; &lt;/SPAN&gt;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;catch {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;&amp;nbsp; Write-Warning $_.Exception.Message&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;connect-ciserver XXXXXXXX -User XXXXXXX -Password XXXXXXXX&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV&gt;exportTRS&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;function exportTRS{&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;try {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;# $date = (Get-Date).ToString("s").Replace(":","-")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$excel = New-Object -ComObject Excel.Application&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$excel.Visible = $false&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$workbook = $excel.Workbooks.Add()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet = $workbook.ActiveSheet&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Name = 'AS Built'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1 = $sheet.range("1:1")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range1.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,1) = 'OrgVDC Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,2) = 'vApp Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,3) = 'Server Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,4) = 'eth0'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,5) = 'eth1'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,6) = 'eth2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,7) = 'vCPU'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,8) = 'Memory'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,9) = 'Storage'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(1,10) = 'Guest OS Name'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3 = $sheet.range("2:2")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3.Cells.Interior.ColorIndex = 56&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3.Cells.Font.ColorIndex = 2&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range3.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(2,4) = 'Prod'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(2,5) = 'Nic2'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(2,6) = 'Nic3'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2 = $sheet.range("50:50")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.Interior.ColorIndex =1&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.font.bold = $true&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.Font.ColorIndex = 46&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$range2.Cells.HorizontalAlignment = -4108&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(50,1) = 'OrgVDCs networks connected'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(50,2) = 'Gateway'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.Cells.Item(50,3) = 'Subnet Mask'&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;#$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row = 3&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$nume_VAPP = read-host "Please Enter the Name of the VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;write-host "Getting vApp Properties for $nume_VAPP"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$vapp = Get-CIVApp -Name $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$orgtemp = $vapp.Org.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$name = $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$date = (Get-Date).ToString("d")&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;write-host "Searching for organization $orgtemp"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$Org = Search-Cloud -QueryType Organization -Name "$orgtemp";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;write-host "Searching for organization VDC with $($Org.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$aOvdcs = Search-Cloud -QueryType AdminOrgVdc -Filter "org==$($Org.id)";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$aVApps = Search-Cloud -QueryType AdminVApp -Filter "Name==$name";&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$VappOrgID = $aVApps.PropertyList.Vdc&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$OrgName = Get-OrgVDC -ID $VappOrgID&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;Write-host "Getting VM information"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$vms = Get-CIVM -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;#$vms = search-cloud -querytype Adminvm -Filter "container==$($vapp.id)"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;foreach ($vm in $vms ){&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$hardware = $vm.ExtensionData.GetVirtualHardwareSection()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$diskMB = (($hardware.Item | where {$_.resourcetype.value -eq "17"}) | %{$_.hostresource[0].anyattr[0]."#text"} |&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;Measure-Object -Sum).sum&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$diskGB = ($diskMB/1024)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$adapters = Get-CINetworkAdapter -VM $vm&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sortadapters = $adapters | Sort-Object&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $OrgName.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.VApp.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $sortadapters[0].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $sortadapters[1].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; $sheet.cells.Item($row,$column) = $sortadapters[2].IPAddress.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.CpuCount&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.memoryGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $diskGB&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $vm.GuestOSFullName&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$net = Get-CIVAppNetwork -VApp $nume_VAPP&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row = 51&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[0].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[0].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[0].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[1].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[1].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[1].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$row++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[2].Name&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[2].Gateway.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column++&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$sheet.cells.Item($row,$column) = $net[2].Netmask.IPAddressToString&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$column = 1&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$objRange = $sheet.UsedRange&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;[void] $objRange.EntireColumn.Autofit()&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$filename = "C:\Work\ASB_$name.xlsx"&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$workbook.SaveAs($filename)&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;$excel.Quit()&lt;SPAN style="white-space:pre;"&gt; &lt;/SPAN&gt;&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;catch {&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;&amp;nbsp; Write-Warning $_.Exception.Message&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;}&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;connect-ciserver XXXXXXXX -User XXXXXXX -Password XXXXXXXX&lt;/DIV&gt;&lt;SPAN&gt;&lt;/SPAN&gt;&lt;DIV style="position: absolute; top: -397px; width: 1px; height: 637px; overflow: hidden; margin: 0px; padding: 0px; left: -1000px;"&gt;exportTRS&lt;/DIV&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 24 Oct 2018 09:09:04 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/vSphere-Command-Line-Interface/Script-modification-to-ADD-MAC-Address-against-respective-NICs/m-p/1857447#M856</guid>
      <dc:creator>MrSiddiqui</dc:creator>
      <dc:date>2018-10-24T09:09:04Z</dc:date>
    </item>
    <item>
      <title>Re: Script modification to ADD MAC Address against respective NICs_ vCloud Director</title>
      <link>https://communities.vmware.com/t5/vSphere-Command-Line-Interface/Script-modification-to-ADD-MAC-Address-against-respective-NICs/m-p/1857448#M857</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Guys,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can anyone guide me how to make it work.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 28 Oct 2018 04:48:12 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/vSphere-Command-Line-Interface/Script-modification-to-ADD-MAC-Address-against-respective-NICs/m-p/1857448#M857</guid>
      <dc:creator>MrSiddiqui</dc:creator>
      <dc:date>2018-10-28T04:48:12Z</dc:date>
    </item>
  </channel>
</rss>

