Here is a list of the key resources and measurement table structure for the vRealize Hyperic database.

EAM_PLATFORM

The table contains a row for each platform in inventory.

Table 1. EAM_PLATFORM Table Fields

Field

Type

Description

ID

int4

An ID for the platform, unique among platforms.

VERSION_COL

int8

Version of the row. Increments when the row is modified. increments with any change to configuration of this row.

FQDN

varchar(200)

Fully qualified domain name of the platform.

CERTDN

varchar(200)

SSL Certificate for the agent which is monitoring this platform.

CID

int4

Not used.

DESCRIPTION

varchar(256)

Description of platform.

CTIME

int8

Creation time of platform.

MTIME

int8

Last modification time of the platform.

MODIFIED_BY

varchar(100)

Last modification user.

LOCATION

varchar(100)

String entered by user, optionally.

COMMENT_TEXT

varchar(256)

String entered by user, optionally.

CPU_COUNT

int4

Number of CPUs on this platform.

PLATFORM_TYPE_ID

int4

ID for the platform type. Points to EAM_PLATFORM_TYPE table.

CONFIG_RESPONSE_ID

int4

Link to configuration string in plug-in XML file.

AGENT_ID

Int4

A unique identifier to the agent which is monitoring this platform.

RESOURCE_ID

int4

Uniquely identifies the resource, unique across platforms, servers, services. Points to the EAM_RESOURCE table.

EAM_PLATFORM_TYPE

The table contains a row table for each vRealize Hyperic-supported platform type.

EAM_SERVER

The table contains a row for each server in the vRealize Hyperic inventory.

Table 2. EAM_SERVER Table Fields

Field

Type

Description

ID

int4

A unique identifier of the server.

VERSION_COL

int8

A column which increments with any change to configuration of this row.

CID

int4

DESCRIPTION

varchar(300)

Description of server.

CTIME

int8

Creation time of server.

MTIME

int8

Last modification time of the server.

MODIFIED_BY

varchar(100)

Last modification user.

LOCATION

varchar(100)

PLATFORM_ID

int4

The Unique ID of the platform on which this server is installed.

AUTOINVENTORYIDENTIFIER

varchar(250)

A unique ID describing this server via the plug-in XML.

RUNTIMEAUTODISCOVERY

bool

Is runtime auto discovery enabled on this server?

WASAUTODISCOVERED

bool

Was this server auto discovered?

SERVICESAUTOMANAGED

bool

Not used

AUTODISCOVERY_ZOMBIE

bool

Were there deletions on the client side for this server?

INSTALLPATH

varchar(200)

Install path of this server on the platform.

SERVER_TYPE_ID

int4

Unique ID of the server type that describes this server.

CONFIG_RESPONSE_ID

int4

Link to configuration string in plug-in XML file.

RESOURCE_ID

int4

Uniquely identifies the resource, unique across platforms, servers, services. Points to the EAM_ RESOURCE table.

EAM_SERVICE

The table contains a row for for each service in the vRealize Hyperic inventory.

Table 3. EAM_SERVICE Table Fields

Field

Type

Description

ID

int4

An ID for the service, unique among services.

VERSION_COL

int8

A column which increments with any change to configuration of this row.

CID

int4

DESCRIPTION

varchar(200)

Description of service.

CTIME

int8

Creation time of service.

MTIME

int8

Last modification time of the service.

MODIFIED_BY

varchar(100)

Last modification user.

LOCATION

varchar(100)

Not used.

AUTODISCOVERY_ZOMBIE

bool

Were there deletions on the client side for this service?

SERVICE_RT

bool

Is response time enabled for this service?

ENDUSER_RT

bool

Is end user response time enabled for this service?

PARENT_SERVICE_ID

int4

Unique ID into the parent service for this service.

SERVER_ID

int4

Were there deletions on the client side for this server?

AUTOINVENTORYIDENTIFIER

varchar(500)

A unique ID describing this server via the plug-in XML.

SERVICE_TYPE_ID

int4

Unique ID of service type for this service.

CONFIG_RESPONSE_ID

int4

Link to configuration string in plug-in XML file.

RESOURCE_ID

int4

Uniquely identifies the resource, unique across platforms, servers, services. Points to the EAM_ RESOURCE table.

EAM_RESOURCE

This table contains a row for each type in the vRealize Hyperic inventory, and a row for each instance of each type in the vRealize Hyperic database, including:

  • Basic inventory types: platforms, servers, and services

  • Configurable inventory types: groups and applications

  • Users and roles

  • Escalations

Table 4. EAM_RESOURCE Table Fields

Field

Type

Description

ID

int4

Uniquely identifies a type or an instance of a type.

VERSION_COL

int8

Increments with any change to configuration of this row.

RESOURCE_TYPE_ID

int4

Identifies a type in the vRealize Hyperic inventory model.

INSTANCE_ID

int4

Uniquely identifies a type or an instance of a particular type in the inventory model. For a type, corresponds to the ID column in one of the following tables: EAM_PLATFORM_TYPE, EAM_SERVER_TYPE&, EAM_SERVICE_TYPE, EAM_APPLICATION_TYPE, or EAM_RESOURCE_TYPE. For an instance of a type, corresponds to the ID column in one of the following tables: EAM_PLATFORM, EAM_SERVER, EAM_SERVICE, EAM_RESOURCE_GROUP, EAM_APPLICATION, EAM_ROLE, EAM_SUBJECT. EAM_ESCALATION

SUBJECT_ID

int4

Identifies the vRealize Hyperic user who owns the resource

PROTO_ID

int4

For a type, value is zero.

For an instance of a type, contains the value of the ID column for the type in this table.

NAME

varchar(500)

Display name for a resource, for example, "My-Office-MacBook-Pro-15.local JBoss 4.2 default ServiceManager Stateless Session EJB".

SORT_NAME

varchar(500)

Same as the NAME column but all in upper case, for example, "MY-OFFICE-MACBOOK-PRO-15.LOCAL JBOSS 4.2 DEFAULT SERVICEMANAGER STATELESS SESSION EJB".

FSYSTEM

boolean

MTIME

int8

Last modification time of the resource.

EAM_MEASUREMENT

Each row contains information about a measurement for a resource under management.

EAM_MEASUREMENT_TEMPL

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

Table 5. EAM_MEASUREMENT_TEMPL Table Fields

Field

Type

Description

ID

int4

A unique identifier of a measurement template for a metric for a resource.

VERSION_COL

int8

A column which increments with any change to configuration of this row.

NAME

varchar(100)

Name of this measurement template.

ALIAS

varchar(100)

String that describes the alias portion of XML file.

UNITS

varchar(50)

Units of this measurement.

COLLECTION_TYPE

int4

Static/dynamic data.

DEFAULT_ON

bool

Does this measurement collect by default?

DEFAULT_INTERVAL

int8

The default collection interval of this metric.

DESIGNATE

bool

Is this metric on the indicator page by default?

TEMPLATE

varchar(2048)

Template string from plug-in XML.

PLUGIN

varchar(250)

Name of the plug-in which houses this measurement template.

CTIME

int8

Creation time of server.

MTIME

int8

Last modification time of the server.

MONITORABLE_TYPE_ID

int4

Key into the monitorable type data.

CATEGORY_ID

int4

Key into the category ID table.