Topics marked with * relate to features available only in vFabric Hyperic.

Feedback is welcome. Click Add Comment at the bottom of the page.

Key Resource and Measurement Tables

This page has information about key HQ database tables that contain information about resources, metric collection, and measurements.

EAM_RESOURCE Table - All Resource Types and Instances

The EAM_RESOURCE table contains information about the types in the HQ Inventory Model and instances of those types in the database. This table has a row for every managed resource in the HQ 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.
• EAM_APPLICATION - Contains a row for each application 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 HQ can manage.
• EAM_SERVER_TYPE - Contains a row for every server type that HQ can manage.
• EAM_SERVICE_TYPE - Contains a row for every service type that HQ can manage.

Tables for Measurement Information

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

Note:  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.

Table Documentation

The sections below document the structure for key resource and measurement tables in the HQ database.

EAM_PLATFORM

Contains a row for each platform in inventory. Click the thumbnail to see example column data.

EAM_PLATFORM_TYPE

Contains a row table for each HQ-supported platform type. Click the thumbnail to see column names and example column data.

EAM_SERVER

Contains a row for each server in HQ inventory.

EAM_SERVICE

Contains a row for each service in HQ inventory

EAM_RESOURCE

This table contains a row for each type in the HQ inventory and access control model, and a row for each instance of each type in the HQ database, including:

• basic inventory types - Platforms, Servers, and Services
• configurable inventory types - Groups and Applications
• Users and Roles
• Escalations

Click the thumbnail to see example column data.

EAM_MEASUREMENT

Each row contains information about a measurement for a resource under management. Click the thumbnail to see example column data.

EAM_MEASUREMENT_TEMPL

Contains a row for a every measurement that HQ can collect, for every resource type it can manage, with information about the default metric collection settings.