VMware vSphere

 View Only
  • 1.  Extract VCenter Data

    Posted Feb 04, 2010 08:07 PM

    Is there a way for me to extract the names of my virtual machines and their folder names within virtual center? Any type of tools which do this? I would like to extract this to a excel document if possible.



  • 2.  RE: Extract VCenter Data

    Broadcom Employee
    Posted Feb 04, 2010 09:24 PM

    Something like this?

    Or did you mean the folder in which the VM is stored in?

    =========================================================================

    William Lam

    VMware vExpert 2009

    VMware ESX/ESXi scripts and resources at:

    Twitter: @lamw

    VMware Code Central - Scripts/Sample code for Developers and Administrators

    VMware Developer Comuunity

    If you find this information useful, please award points for "correct" or "helpful".



  • 3.  RE: Extract VCenter Data

    Posted Feb 05, 2010 10:02 AM

    Or this:

    RVTools



  • 4.  RE: Extract VCenter Data

    Posted Feb 05, 2010 12:31 PM

    I know it's prob not the best or supported way but the folder names are stored in the VPX_VM table in the VC database. You could run a simple select statement on that and copy into excel




    Thanks,

    Neil



  • 5.  RE: Extract VCenter Data

    Posted Feb 05, 2010 02:54 PM

    Basically just looking to extract the "name of the virtual machine" and the "folder the virtual machine resides" under the template and folder view. Then extracting that information into excel.



  • 6.  RE: Extract VCenter Data

    Posted Feb 05, 2010 02:55 PM

    Neil,

    Are the names of the vm in that table as well?



  • 7.  RE: Extract VCenter Data

    Posted Feb 05, 2010 09:00 PM

    Why not highlight your Datacenter and click on the Virtual Machine tab. Next go to File >Export->Export list. Choose Save as type Microsoft Excel.

    -Mike