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_Sch...
...that first I need to look for platform id:
I found it in EAM_PLATFORM table - I'm interested in 10001.
Than I had to look for measurements associated with this id.
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
MEASUREMENT_ID for TEMPLATE_ID 11280 is 10001
SELECT *
FROM EAM_MEASUREMENT
WHERE TEMPLATE_ID='10844' AND INSTANCE_ID='10001';
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';
At the end I checked in Hyperic if the availability data is gathered and found that it is:
Does anyone have idea where availability data is stored and how to get it?