Solved

vmware inventory report script

Posted on 2014-10-06
5
1,131 Views
Last Modified: 2014-10-27
Hello,
i have multiple vcenter.
i want a script that will give me following vcenter inventory output in excel,
schedule task,
merge multiple excel sheet in one with different tabs (or generate different tabs for different vcenter) and
report in email

1) vm names
2) # of CPUs Allocated
3) Ghz of CPU Allocated
4) Memory GB Allocated
5) CPU Reservations Set
6) CPU Limit Set
7) Memory Reservations Set
8) Memory Limiter Set
9) host
10) OS
0
Comment
Question by:izharkhan
  • 2
  • 2
5 Comments
 
LVL 119
ID: 40364161
Will RV Tools not provide you with all the information you require ?

http://www.robware.net/

I would check it out, and have a look at ALL the information it provides you with across multiple tabs in Excel!
0
 

Author Comment

by:izharkhan
ID: 40364421
Hello Andrew,
Thanks for quick reply.
i can get all the information from rvtools. i can save the the tab into excel but problem is  i don't want all the columns.

actually till now i was running scheduled report from rvtools with rvtools script every month and then modify excel file manually.

 but now we have to manage more then 10 vcenters. and we need to provide report every month.  i am looking some automated solution.

if i can get a powershell script, i can schedule it to run every month. which can give me output in one excel workbook with different tabs for different vcenters at least i don't need to modify it.
0
 
LVL 119

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 40364462
I'm not aware of a Powershell script, which is as comprehensive as the RV Tools for Excel output.

It would need to be written.

Have you checked

VMware Community PowerPack
http://www.virtu-al.net/featured-scripts/vmware-powerpack/

http://www.virtu-al.net/vcheck-pluginsheaders/vcheck/

https://communities.vmware.com/docs/DOC-9842
0
 

Author Comment

by:izharkhan
ID: 40365066
i already checked these options but cant use in my case as i have to provide reports to the customers.
0
 
LVL 9

Accepted Solution

by:
Carlos Ijalba earned 250 total points
ID: 40367177
-And won't it be easier to make a VBA Macro in Excel that loads the 10 CSV files exported by RVTools, and process them one by one deleting the unwanted columns and pages???

-I have used on the past such macros to process multiple files and reformat them, delete columns, etc. if you don't know PowerShell, it's probably easier to make than a script from scratch.

-Basically because RVTools is quite comprehensive, and you know it already (well, it is Nicetohaveware!)
1

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Install VMware Tools for Windows on a VMware Windows virtual machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, using the VMware Host Client. The virtual machine has Windows Server 2016 instal…
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
Teach the user how to use configure the vCenter Server storage filters Open vSphere Web Client:  Navigate to vCenter Server Advanced Settings: Add the four vCenter Server storage filters: Review the advanced settings: Modify the values of the four v…
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question