Is there a way to run RVTools against a specific data center within Virtual Center?
Also, is there a way to export just specific data to Excel?
I basically need about 20 columns from the million that RVTools spits out.
I've also tried using Powershell to extract just the columns I need but, RVTools creates Excel files with two row 1's. So I get "Duplicate Header" errors whenever I try to manipulate things with Powershell. 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)
If you hadn't found it yet, this blog post help? - not mine, found on a quick inter-webs search
RVTools: Parse Multiple Outputs Using Powershell – VirtJunkie
You may not even need any scripts, or third party tools.
Please see whether "RVToolsMergeExcelFiles" (in the RVTools documentation) is what you are looking for.
André
That's actually one of the blogs that I was using. My problem is that as soon as I try to do Import-excel, it fails because the spreadsheet RvTools generates had duplicate headers.
I'm using that command too. I have a spreadsheet for 3 different virtual centers. The "RVToolsMergeExcelFiles" works great to put them all into one spreadsheet. It's just getting rid of unneeded columns that I'm having an issue with.
The ImportExcel module has a cmdlet Merge-MultipleSheets that allows you to merge multiple XLSX files.
The cmdlet has an ExcludeProperty parameter, that allows you to specify which columns to leave out.
Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference