Generate Reports

[abhi238]

Hi,

I am using zabbix 1.5.1 (beta) version but still I could not see the generate reports feature added yet.

I have been usiing zabbix for almost 2 years now in production and the work you guys have done is great, but I always felt that we need to have the generate report feature (something similar to how zenoss has ) in zabbix


the custom reports tool (PDF generation) does not work now with the 1.5 versions as the table schema has changed. ie there is no alarms table.

I am really looking for this cool feature ...generate reports in excel or pdf format.


thanks
Abhi.


>>
my configs:
Zabbix version: 1.5.1 (beta)
Mysql server: 5.x

[Niels]

The roadmap (http://www.zabbix.com/next.php) doesn't mention reports, so I don't think they'll be in 1.6.

Maybe we could try to flesh out what we'd like from reports?

[Palmertree]

JasperReports is a good alternative for now. This is what I am using with JasperServer.

[bbrendon]

JasperReports is a good alternative for now. This is what I am using with JasperServer.

Do you have some exmaple xml files for jasper and zabbix?

[Palmertree]

Really depends on what type of report you are trying to run. To create the xml files use "ireports" which will generate the XML files, via a GUI, that are custom for the report. You will have to setup the data connection in ireports to point to the Zabbix database. I usually query the trends, history and item tables for my reports. There is a plugin for ireports that will allow you to talk the JasperServer directly. Reports can be ran from ireports directly or they can be setup on jasperserver to email the reports on a scheduled basis.

[Niels]

Thank you for the pointers, this sound interesting.

[abhi238]

Thanks !

Let me try with JasperReports, hope its opensource...

[Palmertree]

All of it is open source.

Use "ireports" which is a Gui interface for jasperreports. After you get a couple of reports going use JasperServer to maintain them.

[shohn]

Post the goods!

Okay, would you be willing to share some of your jxml scripts or whatever from Ireport? Trying not to reinvent the wheel here. Please please please!

[Niels]

IReport looks fine, but I'm having problems with including graphs from Zabbix. Not static, local files, but from my Zabbix webserver. The URL method in iReports apparently doesn't work. Any pointers on that?

[Palmertree]

I am using the graphs from ireports which is using the jfreechart library This is the same engine (Part of rdtool) zabbix uses for it's graphs. You will have import your sql query into the graph element in ireports. There is a very good manual for ireports that you can buy online for about $45 on the ireports web site. It was worth it for me. The manual has examples on how to create reports and graphs. I will see if I can create some example reports to help everyone out. Make sure you check out JasperServer. It will allow you to setup a Web Server so that your clients can run reports on the fly or schedule reports to be email to them in pdf, Excel, word or RTF format. JasperServer will allow the client to pick a range of dates or search criteria for the report before it is generated using the {PARAMETERS} variables. Also, checkout the JasperServer plugin for ireports on the jasperserver web site. It makes dropping reports right from IReports onto the JasperServer a breeze.

[shohn]

Schema

Is there documentation about the database schema anywhere that would be useful for pulling together such reports?

[Niels]

@Palmertree:

I see what you mean. So the problem is that we have to create to same graphs (more or less) in both the Zabbix UI and again in iReports. Maybe it's possible to get Zabbix to show the sql it's using when showing a graph?

A working example or two from you would be very welcome!

[abhi238]

Hi,

ireports looks good for generating reports for zabbix but there does not seem to be much documentation on the database schema it uses.

Suppose I want to geenrate the last weeks most heavily loaded servers then which tables I could query to get this data?

I referred the zabbix server logs and seems like its updating the history,history_unit tables.

has any one tried to get such a report, can someone please help me with the query needed to get this data

cheers,
abhi

[nelsonab]

Data comes from two tables this is the order they are linked.

Hosts -> Items -> (History | History_uint)

history is for floating point
history_uint is for integer

Here's where it gets interesting. When you change the data type in the Items table the data still remains in the previous table. Thus if you've changed the data recently you'll need to do a union of some sort on both history tables for the itemid you're looking for.

The other tables, history_log and so forth are pretty self explanatory given an understanding of the above.

I'm currently working on getting Jasper Reports to work too.

If you check out your local bookstore you might find the iReport book cheaper than online, and in dead tree form. With discount it was about $8 cheaper at Barnes n Noble.