Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides

Search the VMware Knowledge Base (KB)

View by Article ID

Running SQL commands on the PostgreSQL database bundled with vFabric Hyperic (2020200)

Symptoms

VMware technical support asks you to execute a SQL command against your database, and you are using the PostgreSQL database bundled with vFabric Hyperic.

Purpose

This article provides the steps to execute a SQL command against the PostgreSQL database bundled with vFabric Hyperic.

Resolution

Hyperic has a built in SQL GUI command window which is used to execute SQL statements.

To access the command window, use this URL instead of the usual URL for your Hyperic server:

http://localhost:7080/admin/sql.jsp

A command window with a text box and an Execute SQL button appears.
Paste or type the SQL statement into the text box, then click Execute SQL to run the query.

For example, copy and paste this statement to test functionality:

select count(*) from EAM_AIQ_PLATFORM;

This example retrieves the number of platforms in the Auto Inventory queue.

After running the query, follow the instructions from the technical support agent for further steps.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

1 2 3 4 5
0 Ratings

1 2 3 4 5
0 Ratings

Actions

Bookmark Document

KB:

Did this article help you?
This article resolved my issue. This article did not resolve my issue. This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)