DX Infrastructure Manager

Expand all | Collapse all

SQL query to get VM powerstatus

Jump to Best Answer
  • 1.  SQL query to get VM powerstatus

    Posted 04-20-2017 01:36 PM

    Whether it is possible to get the vm guest power status using SQL query for all vm's which are discovered by vmware probe.

     

    We can get the info  in dashboard but i need the whole vm's which are discovered by vmware probe in excel format ,hope it will not support. 



  • 2.  Re: SQL query to get VM powerstatus
    Best Answer

    Posted 04-20-2017 08:39 PM

    I dont have the SQL query but I can suggest a workaround to get the information you are looking for in a excel.

     

    Create a group of the VM's for which you want to report the VM Power State and run a TopN report at the group level , just make sure you set the Top N number to be above the number of VM's in the group. This will give you a report of VM Power state which can be exported into excel 

     

    Hope this helps