vmware inventory report script

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
Who is Participating?
Carlos IjalbaConnect With a Mentor Senior SysadminCommented:
-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!)
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Will RV Tools not provide you with all the information you require ?


I would check it out, and have a look at ALL the information it provides you with across multiple tabs in Excel!
izharkhanAuthor Commented:
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.
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
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


izharkhanAuthor Commented:
i already checked these options but cant use in my case as i have to provide reports to the customers.
All Courses

From novice to tech pro — start learning today.