Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Back to discussions
Expand all | Collapse all

SQL query for VMware vCenter

  • 1.  SQL query for VMware vCenter

    Posted 12/01/15 06:57 PM
      |   view attached

    Attached is a SQL query that can be run against VCenter and used for LUN to VM, LUN to Datastore, and LUN to HOST mapping.

    Here's the columns created and populated with this query.

     

    nameDatastoreHostdevice_nameHOST_IDSCSI_LUN_IDLUN_ID_VALKEY_VALLINK_KEYSATP_POLICYpath_statelink_keypath_name

     

    This is fully functional, tested on ESX5.8 and ready to be added to the VMWare connector in Datalink.








    #Datalink

    Attachment(s)

    zip
    LUN_Path_Query.txt.zip   432 B 1 version


  • 2.  Re: Week 3&4 TBM Data Connect Contest is Closed.

    Posted 12/02/15 12:30 AM

    Nice! Thanks Josh!

    Ken


    #Datalink


Related Content