<?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 Re: RVTools - Run against a specific data center in VMware PowerCLI Discussions</title>
    <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2892441#M105220</link>
    <description>&lt;P&gt;I'm using that command too.&amp;nbsp; I have a spreadsheet for 3 different virtual centers. The&amp;nbsp;&lt;SPAN&gt;"RVToolsMergeExcelFiles" works great to put them all into one spreadsheet.&amp;nbsp; It's just getting rid of unneeded columns that I'm having an issue with.&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Mon, 07 Feb 2022 16:15:26 GMT</pubDate>
    <dc:creator>Bruticusmaximus</dc:creator>
    <dc:date>2022-02-07T16:15:26Z</dc:date>
    <item>
      <title>RVTools - Run against a specific data center</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2891707#M105152</link>
      <description>&lt;P&gt;Is there a way to run RVTools against a specific data center within Virtual Center?&lt;/P&gt;&lt;P&gt;Also, is there a way to export just specific data to Excel?&lt;/P&gt;&lt;P&gt;I basically need about 20 columns from the million that RVTools spits out.&amp;nbsp;&lt;/P&gt;&lt;P&gt;I've also tried using Powershell to extract just the columns I need but, RVTools creates Excel files with two row 1's.&amp;nbsp; So I get "Duplicate Header" errors whenever I try to manipulate things with Powershell.&amp;nbsp; It's more like there's 2 copies of the whole spreadsheet. If you unfreeze the top row, when you expand it, it's two spreadsheets. (See screenshot)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 03 Feb 2022 00:42:29 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2891707#M105152</guid>
      <dc:creator>Bruticusmaximus</dc:creator>
      <dc:date>2022-02-03T00:42:29Z</dc:date>
    </item>
    <item>
      <title>Re: RVTools - Run against a specific data center</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2891708#M105153</link>
      <description>&lt;P&gt;If you hadn't found it yet, this blog post help? - not mine, found on a quick inter-webs search&lt;BR /&gt;&lt;BR /&gt;&lt;A href="https://www.virtjunkie.com/2019/08/11/powershell-parse-rvtools/" target="_blank"&gt;RVTools: Parse Multiple Outputs Using Powershell – VirtJunkie&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Thu, 03 Feb 2022 00:59:06 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2891708#M105153</guid>
      <dc:creator>kwhornlcs</dc:creator>
      <dc:date>2022-02-03T00:59:06Z</dc:date>
    </item>
    <item>
      <title>Re: RVTools - Run against a specific data center</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2891925#M105174</link>
      <description>&lt;P&gt;You may not even need any scripts, or third party tools.&lt;BR /&gt;Please see whether "RVToolsMergeExcelFiles" (in the RVTools documentation) is what you are looking for.&lt;/P&gt;
&lt;P&gt;André&lt;/P&gt;</description>
      <pubDate>Thu, 03 Feb 2022 18:36:13 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2891925#M105174</guid>
      <dc:creator>a_p_</dc:creator>
      <dc:date>2022-02-03T18:36:13Z</dc:date>
    </item>
    <item>
      <title>Re: RVTools - Run against a specific data center</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2892440#M105219</link>
      <description>&lt;P&gt;That's actually one of the blogs that I was using.&amp;nbsp; My problem is that as soon as&amp;nbsp; I try to do Import-excel, it fails because the spreadsheet RvTools generates had duplicate headers.&lt;/P&gt;</description>
      <pubDate>Mon, 07 Feb 2022 16:13:48 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2892440#M105219</guid>
      <dc:creator>Bruticusmaximus</dc:creator>
      <dc:date>2022-02-07T16:13:48Z</dc:date>
    </item>
    <item>
      <title>Re: RVTools - Run against a specific data center</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2892441#M105220</link>
      <description>&lt;P&gt;I'm using that command too.&amp;nbsp; I have a spreadsheet for 3 different virtual centers. The&amp;nbsp;&lt;SPAN&gt;"RVToolsMergeExcelFiles" works great to put them all into one spreadsheet.&amp;nbsp; It's just getting rid of unneeded columns that I'm having an issue with.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 07 Feb 2022 16:15:26 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2892441#M105220</guid>
      <dc:creator>Bruticusmaximus</dc:creator>
      <dc:date>2022-02-07T16:15:26Z</dc:date>
    </item>
    <item>
      <title>Re: RVTools - Run against a specific data center</title>
      <link>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2892449#M105221</link>
      <description>&lt;P&gt;The &lt;A href="https://www.powershellgallery.com/packages/ImportExcel/7.4.1" target="_blank" rel="noopener"&gt;ImportExcel&lt;/A&gt; module has a cmdlet &lt;STRONG&gt;Merge-MultipleSheets&lt;/STRONG&gt; that allows you to merge multiple XLSX files.&lt;BR /&gt;The cmdlet has an &lt;STRONG&gt;ExcludeProperty&lt;/STRONG&gt; parameter, that allows you to specify which columns to leave out.&lt;/P&gt;</description>
      <pubDate>Mon, 07 Feb 2022 16:45:40 GMT</pubDate>
      <guid>https://communities.vmware.com/t5/VMware-PowerCLI-Discussions/RVTools-Run-against-a-specific-data-center/m-p/2892449#M105221</guid>
      <dc:creator>LucD</dc:creator>
      <dc:date>2022-02-07T16:45:40Z</dc:date>
    </item>
  </channel>
</rss>

