0 Replies Latest reply on Apr 9, 2015 5:15 PM by vmSpecDaniel

    How to get vm availability from Hyperic DB

    vmSpecDaniel Novice

      Hi,

      I want to get vm availability from Hyperic DB.

       

      I checked in documentation (https://pubs.vmware.com/vfabric5/index.jsp#com.vmware.vfabric.hyperic.4.6/Hyperic_Database_Table_Schemas.html)

      ...that first I need to look for platform id:

      screen1.png

       

      I found it in EAM_PLATFORM table - I'm interested in 10001.

      Than I had to look for measurements associated with this id.

      screen2.png

       

      I found them in EAM_MEASUREMENT table.

      Than I had to find which measurement is responsible for availability so I had to join EAM_MEASUREMENT and EAM_MEASUREMENT_TEMPL on TEMPLATE_ID

      SELECT *

      FROM

      EAM_MEASUREMENT

      INNER JOIN EAM_MEASUREMENT_TEMPL

      ON EAM_MEASUREMENT.TEMPLATE_ID=EAM_MEASUREMENT_TEMPL.ID

      WHERE instance_id='10001';

      I found that I'm interested in TEMPLATE_ID 11280 or 10844

      screen3.png

      screen4.png

       

       

      MEASUREMENT_ID for TEMPLATE_ID 11280 is 10001

      SELECT *

      FROM EAM_MEASUREMENT

      WHERE TEMPLATE_ID='10844' AND INSTANCE_ID='10001';

       

      screen5.png

      I read in documentation that " Metric data is stored in the EAM_MEASUREMENT_DATA_1H,  EAM_MEASUREMENTt_DATA_6H, and EAM_MEASUREMENT_DATA_1D tables" so I looked for all rows with MEASUREMENT_ID='10001' in the table and found nothing.

      SELECT *

      FROM EAM_MEASUREMENT_DATA_1H

      WHERE measurement_id='10001';

      screen6.png

       

      At the end I checked in Hyperic if the availability data is gathered and found that it is:

       

      screen7.png

      Does anyone have idea where availability data is stored and how to get it?