The key vCenter Hyperic database tables include information about resources, metric collection, and measurements.

The EAM_RESOURCE table contains information about the types in the vCenter Hyperic inventory model and instances of those types in the database. This table has a row for every managed resource in the vCenter Hyperic database, including

Operating system platforms, and the servers and services that run on them.

Virtual or network host platforms, and the servers and services that run on them.

Groups and applications.

Roles and users.

Escalations.

The following tables have information about resource instances of a particular inventory type:

EAM_PLATFORM

Contains a row for each platform in inventory.

EAM_SERVER

Contains a row for each server in inventory.

EAM_SERVICE

Contains a row for each service in inventory.

EAM_RESOURCE_GROUP

Contains a row for each group in inventory.

The following tables have information about resource types for an inventory type.

EAM_PLATFORM_TYPE

Contains a row for every platform type that vCenter Hyperic can manage.

EAM_SERVER_TYPE

Contains a row for every server type that vCenter Hyperic can manage.

EAM_SERVICE_TYPE

Contains a row for every service type that Hyperic can manage.

The following tables have information about the measurements that vCenter Hyperic can collect.

These tables do not store metric values. Metric data is stored in the EAM_MEASUREMENT_DATA_1H, EAM_MEASUREMENTt_DATA_6H, and EAM_MEASUREMENT_DATA_1D tables.

EAM_ MEASUREMENT_TEMPL

Contains a row for a every metric available for every inventory resource type with its metric template and default metric collection settings.

EAM_MEASUREMENT

Contains a row for every metric available for every resource in inventory, with metric collection configuration information: whether collection is enabled and the collection interval for enabled metrics.