VMware Cloud Community
pcopeland
Contributor
Contributor

Custom Reports - Database Schema documentation

Hi,

I want to write some custom (SQL) reports. Where can I find some documentation that explains the database schema?

Thanks

Philip
Reply
0 Kudos
5 Replies
admin
Immortal
Immortal

Philip,

Here's a reporting overview:
http://support.hyperic.com/display/DOC/Reporting+Overview#ReportingOverview-respond

For some reason it tells you to contact sales to learn about the db schema, so here's the relevant tables:
http://support.hyperic.com/display/DOC/Useful+Database+Schemas

Here's some test queries that will show you the structure:
http://support.hyperic.com/display/DOC/Test+Queries

We use JasperReports, so it's good to know their iReport stuff as well:
http://jasperforge.org/website/ireportwebsite/IR%20Website/iReport_documentation.html?group_id=243&h...

--jeremy
Reply
0 Kudos
pcopeland
Contributor
Contributor

Perfect - very helpful.

We use the Eclipse BIRT reporting tool. These days I think this is much nicer than Jasper.

Thanks

Philip
Reply
0 Kudos
magawake
Contributor
Contributor

nice post indeed.
Reply
0 Kudos
pcopeland
Contributor
Contributor

Hi,

In testing out some of my queries that I am developing for my reports - I've been getting some strange results - that I am confused about. It relates to how you join eam_measurement.instance_id?

In one case (a specific platform) I am finding that I get very weird results when I join eam_measurement.instance_id = eam_service.id. Looking at the data it appears that the id that has been used is the platform ID not the ID for the service (for Monitorable_Types win32, CPU & HQAgent).

This only seems to be happening for 1 specific platform. Is it possible that this platform was configured incorrectly somehow?


Thanks
Reply
0 Kudos
gsooda
Contributor
Contributor

Hi ,

We have a requirement where in we need to have Hyperic Custom reports which will pull out the CPU usage and JVM memory usage for the Plaforms?

if you could please share the Query(Which will help write one as per our requirement) it will be very helpful.

Thanks,

Guru.

Reply
0 Kudos