<?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>TheVMinator Tracker</title>
    <link>https://communities.vmware.com/wbsdv95928/tracker</link>
    <description>TheVMinator Tracker</description>
    <pubDate>Wed, 15 Nov 2023 07:46:50 GMT</pubDate>
    <dc:date>2023-11-15T07:46:50Z</dc:date>
    <item>
      <title>Re: How to vMotion during tape backup</title>
      <link>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270075#M14774</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;We want to use virtual servers rather than physical.&amp;nbsp; That is one of the main goals here.&amp;nbsp; This being a VMware forum, I trust that it is not necessary to defend why someone might want to use a virtual machine rather than a physical machine.&amp;nbsp; Nevertheless that is a goal.&amp;nbsp; The goal is to find a solution that both takes advantages of the benefits of virtualization, but still provides backup capabilities to tape, or replaces it with similar functionality that allows the compute side of the design to take advantage of the benefits of virtualization.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 06 Aug 2019 19:50:55 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270075#M14774</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-08-06T19:50:55Z</dc:date>
    </item>
    <item>
      <title>Re: How to vMotion during tape backup</title>
      <link>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270073#M14772</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;it seems to me that someone must have approached this type of problem and come up with a solution....what if we replace our tape drive with something else?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 06 Aug 2019 18:58:48 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270073#M14772</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-08-06T18:58:48Z</dc:date>
    </item>
    <item>
      <title>Re: How to vMotion during tape backup</title>
      <link>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270071#M14770</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks for your input.&amp;nbsp; However usb over IP doesn't require passing through an esxi host.&amp;nbsp;&amp;nbsp; It exposes an IP address that can live on the same network as the IP of the OS on the VM.&amp;nbsp; That's the point of what I was asking - what are the options for creating connectivity from a VM to a tape backup wtihout having to use passthrough?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 06 Aug 2019 15:31:03 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270071#M14770</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-08-06T15:31:03Z</dc:date>
    </item>
    <item>
      <title>How to vMotion during tape backup</title>
      <link>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270069#M14768</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I need to figure out a solution for a VMs that are connected to a tape backup.&amp;nbsp; Currently the solution uses a physical server with a scsi connection another physical server uses a usb connection to a tape backup.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For example - for the USB connected tape backup - if I install a usb-over-ip hub - would that work?&amp;nbsp; Will it allow the Vm to connect to the IP and be able to vmotion without making the backup job fail?&amp;nbsp; If not is there a better solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For the scsi connected tape backup - is there a similar or better solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I want the Vm to be able to move among all physical servers in the cluster and be able to restart on any new server.&amp;nbsp; I don't want to have to hardwire the VM to scsi passthrough on any single physical server.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks for your ideas!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 06 Aug 2019 15:12:23 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/Backup-Recovery-Discussions/How-to-vMotion-during-tape-backup/m-p/2270069#M14768</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-08-06T15:12:23Z</dc:date>
    </item>
    <item>
      <title>Re: Find VM Name from OS Hostnsme</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Find-VM-Name-from-OS-Hostnsme/m-p/1827323#M60311</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Perfect thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 23 Feb 2019 22:19:12 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Find-VM-Name-from-OS-Hostnsme/m-p/1827323#M60311</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-02-23T22:19:12Z</dc:date>
    </item>
    <item>
      <title>Re: Merge VMware and NetApp VM information</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Merge-VMware-and-NetApp-VM-information/m-p/1827429#M60314</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Luc thanks so much. This is very close to what I’m trying to do.&amp;nbsp;&amp;nbsp; However it is slightly different. In the script you posted, it is associating VMFS data store Objects in Vcenter with LUNs in NetApp.&amp;nbsp;&amp;nbsp; What I’m actually trying to do is associate operating system drives in an operating system within windows with iSCSI LUNs In the NetApp controller.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;For example in Windows you can use the NetApp Snapdrive software to connect the operating system to a NetApp iSCSI LUN and mount it say as a &lt;img class="lia-deferred-image lia-image-emoji" src="https://communities.vmware.com/html/@B699825BEA7B9353BA12C688F8C7000B/emoticons/1f627.png" alt=":anguished_face:" title=":anguished_face:" /&gt; drive to windows.&amp;nbsp; Windows then formats the LUN with the NTFS file system and then it can become a &lt;img class="lia-deferred-image lia-image-emoji" src="https://communities.vmware.com/html/@B699825BEA7B9353BA12C688F8C7000B/emoticons/1f627.png" alt=":anguished_face:" title=":anguished_face:" /&gt; drive the OS can use.&amp;nbsp; vCenter isn’t aware This happened.&amp;nbsp; However if VMware tools are installed, then Whatever view inside the OS was available about a D drive could be picked up by VMware tools.&amp;nbsp; Somehow I’ve got to be able to associate the OS drive with the iSCSI LUN that backs it, and list for each VM in vCenter this info in the format of the table I posted above.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;(i think SnapDrive, the NetApp software that installs in Windows and creates these Os level iSCSI connections to NetApp might have its own management server as well - not sure if PowerShell could connect to it to help merge these pieces of data) &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any suggestions?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 23 Feb 2019 22:15:32 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Merge-VMware-and-NetApp-VM-information/m-p/1827429#M60314</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-02-23T22:15:32Z</dc:date>
    </item>
    <item>
      <title>Find VM Name from OS Hostnsme</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Find-VM-Name-from-OS-Hostnsme/m-p/1827321#M60309</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Assuming that I know only the operating system host name, and I know that the virtual machine name is completely different from the OS host name, how can I query vcenter and find the virtual machine name that is associated with this operating system host name?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;i.e &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$hostname = ”windowshostname”&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;get-vm | where-object{$_.something? -eq $hostname}&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 23 Feb 2019 03:15:47 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Find-VM-Name-from-OS-Hostnsme/m-p/1827321#M60309</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-02-23T03:15:47Z</dc:date>
    </item>
    <item>
      <title>Merge VMware and NetApp VM information</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Merge-VMware-and-NetApp-VM-information/m-p/1827427#M60312</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have a report that lists information for virtual machines in vCenter:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;get-vm | select name, numcpu, memorygb, provisionedspacegb&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;However, each VM is also connecting to an iSCSI LUN on NetApp at the OS level using an iSCSI initiator&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need to figure out the size of the iSCSI LUN that this VM connects to at the OS level, then merge that with my existing columns.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When I'm done I need to have a report like this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(198, 198, 198); width: 100%;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;Name&lt;/STRONG&gt;&lt;/TH&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;NUMCPU&lt;/STRONG&gt;&lt;/TH&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;MemoryGB&lt;BR /&gt;&lt;/STRONG&gt;&lt;/TH&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;ProvisionedSpaceGB&lt;BR /&gt;&lt;/STRONG&gt;&lt;/TH&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;iSCSI LUN Size&lt;BR /&gt;&lt;/STRONG&gt;&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I've got the Netapp PowerShell toolkit installed &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="https://community.netapp.com/t5/Microsoft-Virtualization-Discussions/NetApp-PowerShell-Toolkit-4-7-released/td-p/144805" title="https://community.netapp.com/t5/Microsoft-Virtualization-Discussions/NetApp-PowerShell-Toolkit-4-7-released/td-p/144805"&gt;NetApp PowerShell Toolkit 4.7 released! - NetApp Community&lt;/A&gt; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Has anyone successfully done something like this - taken VM data from vCenter and data from NetApp, and combined them into a single report that pulls data both from vCenter and from NetApp?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 23 Feb 2019 00:05:58 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Merge-VMware-and-NetApp-VM-information/m-p/1827427#M60312</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2019-02-23T00:05:58Z</dc:date>
    </item>
    <item>
      <title>Re: Import Data with Extra Spaces</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Data-with-Extra-Spaces/m-p/2746458#M96576</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I can upload it but I've got to sanitize it first and remove all sensitive data and I'm just heading out for the day so need to work on this tomorrow - but note this - I'm not sure exactly how to describe the problem, but for the columns that have the issue, when I click on the cell with the column name in Excel, the cursor jumps to one space after the column name.&amp;nbsp; For the columns that don't have the issue, when I click on the cell with the column name in Excel, the cursor jumps to the character immediately after the column name.&amp;nbsp; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I think I could solve the problem by inputting the input file and removing all spaces BEFORE or AFTER the column name, then writing a new input file with the spaces removed from the column headings.&amp;nbsp; But I need to do this without removing spaces from the actual data in the columns.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Any way to do this?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Jul 2018 23:49:47 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Data-with-Extra-Spaces/m-p/2746458#M96576</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-07-11T23:49:47Z</dc:date>
    </item>
    <item>
      <title>Import Data with Extra Spaces</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Data-with-Extra-Spaces/m-p/2746456#M96574</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm running this script to input a csv and get VM data:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;#Simplified version&lt;/P&gt;&lt;P&gt;$report = @()&lt;/P&gt;&lt;P&gt;Import-Csv -path c:\inputfile.csv -UseCulture | foreach{&lt;/P&gt;&lt;P&gt;$vmname = $_.vmname &lt;/P&gt;&lt;P&gt;$report += $vmname&lt;/P&gt;&lt;P&gt;}&lt;/P&gt;&lt;P&gt;$report | select vmname |&amp;nbsp; export-csv c:\outputfile.csv -notypeinformation -useculture&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The problem is that if the input file has a column called VMName with no spaces AFTER the column title, everything works fine, but if there are spaces after the column title, it won't pick up the vmnames in the input file.&amp;nbsp; Every time someone different creates the input file, they may add an extra space before or after the column title, and mess up the results.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How can I make the import-csv statement read the column titles even if there are spaces before or after the column title?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Jul 2018 19:22:40 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Data-with-Extra-Spaces/m-p/2746456#M96574</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-07-11T19:22:40Z</dc:date>
    </item>
    <item>
      <title>Re: Input csv File to PowerCLI Script and Retain all Data</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Input-csv-File-to-PowerCLI-Script-and-Retain-all-Data/m-p/2744974#M96397</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;OK great - thanks again&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 11 Jul 2018 19:15:35 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Input-csv-File-to-PowerCLI-Script-and-Retain-all-Data/m-p/2744974#M96397</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-07-11T19:15:35Z</dc:date>
    </item>
    <item>
      <title>Re: Input csv File to PowerCLI Script and Retain all Data</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Input-csv-File-to-PowerCLI-Script-and-Retain-all-Data/m-p/2744972#M96395</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;This is great - I don't quite start off with two csv's though that I'm merging - what I've got is this:&lt;/P&gt;&lt;P&gt;### I start with one input file like this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$report = @()&lt;/P&gt;&lt;P&gt;import-csv vmlist.csv -useculture | foreach{&lt;/P&gt;&lt;P&gt;$vmname = $_.vmname&lt;/P&gt;&lt;P&gt;$datacenter = $_.datacenter&lt;/P&gt;&lt;P&gt;$owner = $_.owner&lt;/P&gt;&lt;P&gt;$numcpu = (get-vm $vmname).numcpu&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$properties = @{'vmname' = $vmname;&lt;/P&gt;&lt;P&gt;'datacenter' = $datacenter;&lt;/P&gt;&lt;P&gt;'owner' = $owner;&lt;/P&gt;&lt;P&gt;'numcpu' = $numcpu;&lt;/P&gt;&lt;P&gt;}&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; $object = New-Object -TypeName PSObject -Property $properties&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; $report += $object &lt;/P&gt;&lt;P&gt;}&lt;/P&gt;&lt;P&gt;$report | select vmname,datacenter,owner,numcpu | export-csv report.csv -useculture -notypeinformation&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;##so the goal is that if vmlist.csv has ANY other columns beside vmname, datacenter and owner, that the report.csv file that this report creates includes all those extra columns, whatever they might ##be.&amp;nbsp; Each new vmlist.csv file always has the "vmname" column, so that I can count on - but they may have 5 - 40 other columns also, which I can't predict that need to be preserved.&lt;/P&gt;&lt;P&gt;##&amp;nbsp; THanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sat, 07 Jul 2018 03:26:30 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Input-csv-File-to-PowerCLI-Script-and-Retain-all-Data/m-p/2744972#M96395</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-07-07T03:26:30Z</dc:date>
    </item>
    <item>
      <title>Input csv File to PowerCLI Script and Retain all Data</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Input-csv-File-to-PowerCLI-Script-and-Retain-all-Data/m-p/2744970#M96393</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have a powerCLI script that does the following:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Imports a csv (vmlist.csv) that looks like this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(198, 198, 198); width: 100%;"&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;VMname&lt;/STRONG&gt;&lt;/TH&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;Datacenter&lt;/STRONG&gt;&lt;/TH&gt;&lt;TH style="text-align: left; background-color: #f2f2f2; color: #505050; padding: 6px;" valign="middle"&gt;&lt;STRONG&gt;Owner&lt;/STRONG&gt;&lt;/TH&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD style="padding: 6px;"&gt;vm1&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;paris&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;john&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD style="padding: 6px;"&gt;vm2&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;london&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;jim&lt;/TD&gt;&lt;/TR&gt;&lt;TR&gt;&lt;TD style="padding: 6px;"&gt;vm3&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;new york&lt;/TD&gt;&lt;TD style="padding: 6px;"&gt;joe&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;then I import the csv and add the CPU count as an additional row.&amp;nbsp; The problem is that multiple providers of input files provide info with different additional column names that all need to be preserved in the final output file.&amp;nbsp; The additional columns could be different based on the source and there could be any number of new columns with new data&amp;nbsp; in them in each new input file, all which need to be preserved in the output file.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How can I create a report that both adds a "NumCPU" column to the csv, and PRESERVES any other columns that are in the input file, and creates a new .csv with all the original data plus the numcpu count?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 05 Jul 2018 22:12:38 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Input-csv-File-to-PowerCLI-Script-and-Retain-all-Data/m-p/2744970#M96393</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-07-05T22:12:38Z</dc:date>
    </item>
    <item>
      <title>Re: Import Lists of VMs with Different Column Titles</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741949#M96107</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;ok thanks - to clarify - you used the variable $row - &lt;/P&gt;&lt;P&gt;it seems these are actually columns - would you agree?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Jun 2018 18:33:16 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741949#M96107</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-06-21T18:33:16Z</dc:date>
    </item>
    <item>
      <title>Re: Import Lists of VMs with Different Column Titles</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741948#M96106</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;ok thanks again - much appreciated!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Jun 2018 18:05:56 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741948#M96106</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-06-21T18:05:56Z</dc:date>
    </item>
    <item>
      <title>Re: Import Lists of VMs with Different Column Titles</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741946#M96104</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;yes - that is the complete list of possible values, and those values are only used for that one column name. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks again&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Jun 2018 17:39:27 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741946#M96104</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-06-21T17:39:27Z</dc:date>
    </item>
    <item>
      <title>Import Lists of VMs with Different Column Titles</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741944#M96102</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I need to run scripts against multiple csv input files and get lists of VMs.&amp;nbsp; However I'm running an issue.&amp;nbsp; My script is like this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$path = "c:\inputfile.csv"&lt;/P&gt;&lt;P&gt;Import-Csv -Path $path -UseCulture | foreach{&lt;/P&gt;&lt;P&gt;$vmname = $_.vmname&lt;/P&gt;&lt;P&gt;get-vm $vmname}&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;However the problem is that the input files have multiple different column names for &lt;STRONG&gt;VMname&lt;/STRONG&gt;. Some input files have VMname, some have Systemname, hostname, servername, server or VM as the column title for the VM name.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How can I modify my script so that I assign the $vmname to whichever of these column titles is used?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 21 Jun 2018 17:24:48 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/Import-Lists-of-VMs-with-Different-Column-Titles/m-p/2741944#M96102</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-06-21T17:24:48Z</dc:date>
    </item>
    <item>
      <title>Re: How to Convert NumCPU to An int?</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/How-to-Convert-NumCPU-to-An-int/m-p/1839482#M61537</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 15 Jun 2018 16:36:07 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/How-to-Convert-NumCPU-to-An-int/m-p/1839482#M61537</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-06-15T16:36:07Z</dc:date>
    </item>
    <item>
      <title>How to Convert NumCPU to An int?</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/How-to-Convert-NumCPU-to-An-int/m-p/1839480#M61535</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;i need to get the number of vCPUs on a VM and then cast the value into an integer data type.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;$cpus = [int]( get-vm sqlvm1 | select NumCPU)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;However it is telling me it can’t convert the data type of NumCPU to an int.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;any ideas?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 15 Jun 2018 01:51:01 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/How-to-Convert-NumCPU-to-An-int/m-p/1839480#M61535</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-06-15T01:51:01Z</dc:date>
    </item>
    <item>
      <title>"Bound By" indicator not present in vROps 6.6?</title>
      <link>https://communities.vmware.com/t5/VMware-Aria-Operations/quot-Bound-By-quot-indicator-not-present-in-vROps-6-6/m-p/2219072#M13447</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I'm using vROps 6.6.1 and don't see the "bound by" indicator.&amp;nbsp; In 5.x there used to be a screen that showed you whether a VM was bound by CPU, RAM, Storage, etc.&amp;nbsp; Did they take this away in newer versions?&amp;nbsp; If its still there how do I navigate to it in 6.6.1?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 31 Jan 2018 22:30:52 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-Aria-Operations/quot-Bound-By-quot-indicator-not-present-in-vROps-6-6/m-p/2219072#M13447</guid>
      <dc:creator>TheVMinator</dc:creator>
      <dc:date>2018-01-31T22:30:52Z</dc:date>
    </item>
  </channel>
</rss>

