vmware inventory report script

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
izharkhanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
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
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.
0
Andrew Hancock (VMware vExpert / EE MVE^2)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
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
izharkhanAuthor Commented:
i already checked these options but cant use in my case as i have to provide reports to the customers.
0
Carlos IjalbaSenior 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!)
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.