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

EAM_RESOURCE Table

The EAM_RESOURCE table contains information about the types in the vRealize Hyperic inventory model and instances of those types in the database. This table has a row for every managed resource in the vRealize 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.

Tables for Inventory Resources

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.

Tables for Platform, Server, and Service Types

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

EAM_PLATFORM_TYPE

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

EAM_SERVER_TYPE

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

EAM_SERVICE_TYPE

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

Tables for Measurement Information

The following tables have information about the measurements that vRealize 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.