Writing Custom Reports

[GoogleCodeExporter]

Hi,

Again, I'm filing here in the absence of a mailing list - is there an IRC room 
or something that I could use instead?

I'm after a guide to writing custom reports.  I've got a number of servers that 
will (hopefully!) be reporting into a central server (see issue 13) and I want 
to create a report that only shows certain metrics but for multiple servers on 
the same page.

Is there a way of integrating the system_report queries into custom reports?

Thanks,

Matt

Original issue reported on code.google.com by mattMacW...@gmail.com on 19 Aug 2010 at 9:15

[GoogleCodeExporter]

What are the "system_report queries"?
There is currently no built in report mechanism which aggregates data from 
multiple servers.
But if you want to, you can always do it SQL-wise! Take a look at 
[http://code.openark.org/forge/mycheckpoint/documentation/generating-google-char
ts generating google charts] and 
[http://code.openark.org/forge/mycheckpoint/documentation/querying-for-data 
querying for data]

Original comment by shlomi.n...@gmail.com on 22 Aug 2010 at 6:11

• Changed state: WontFix

[GoogleCodeExporter]

Hi,

By "System report queries", I meant anything that is not a custom query... :)

I want to create a report page that shows (for example) the query_cache results 
for multiple servers (even if I need to take them from multiple databases!) on 
a single page.

Basically, I don't need all the metrics for all the servers, I just want to 
create a summary report with the metrics I am interested in (most of which are 
already existing graphs on the built in reports) - is this possible?

Thanks,

Matt

Original comment by mattMacW...@gmail.com on 22 Aug 2010 at 3:47

[GoogleCodeExporter]

It is possible via the fact you can get all the metrics you want, including 
full featured charts, and build your own HTML page with them.
This isn't a CMS (yet). I have no immediate plans to make this happen.

Original comment by shlomi.n...@gmail.com on 24 Aug 2010 at 12:37