Database schema questions

[heikki_hyperic]

I am working on a UI plugin, and want to display some information that the agents and plugins have collected. To that end I of course need to get some data out from the database.

So assuming I have an IP address, how would I then be able to get:

- currently available and maximum RAM
- currently available and maximum disk space

for the machine at that IP address?

I am also looking for a way to get the CPU type in a more robust way. Currently I get it by parsing the eam_resource.name values (they have strings like "localhost Linux CPU 1 (2000MHz Intel Pentium 4)".

PS. The partial schema document at http://support.hyperic.com/display/DOC/HQ+Database+Table+Schemas seems to be partially out of date (not all of the documented columns seem to exist in 4.x), and the formatting of that doc is out of whack.

[excowboy]

Heikki,

I've created a Wiki page on HyperForge with a documenation of the latest database schema:
http://support.hyperic.com/display/hypcomm/HQ+database+schema

I can't help you with your queries, but I think eam_platform, eam_resources and the eam_measurement tables are your friends 😉

Cheers,
Mirko