Zabbix integration with a reporting engine

[bioposi]

Hello,

From the forum, I noticed that there are many people that have the same need as I have to produce automated, custom reports for my company.

In the waiting for a report exportation directly from Zabbix (pdf, excel, graphics), many members of the community exploit the database directly with reporting engine like JasperReport (personnally, I target Eclipse/BIRT reporting engine). To do so, they had to explore and understand the Zabbix database structure and table relations.

Would it be possible that this knowledge of the database structure be shared and published, so the community can develop around the integration of Zabbix with external reporting engines ?
That would be a great help for departments like IT Delivery (SLA monitoring and reporting) or Corporate Operations (Support and maintenance).

Thanks in advance.
Cheers.
Biposi

[stalione]

I second this notion. I am also struggling to get some good automated reporting going. Zabbix as a community will benefit tremendously by publishing the database schema and explaining the relationship.

[Calimero]

I find zabbix' schema quite easy to understand.

The most interesting tables for reporting probably are:
- hosts
- items
- events
- triggers
- history_*
- trends_*

[tighep]

I also have found the schema relatively easy to understand, and have some automated reports running via Crystal Reports. If anyone needs help building queries, I'm sure there are some of us that will be happy to help out.

[aviperp]

Linking an Event to a Host

Running on with this thread...
I would like to report on how many times in a week, a give Host has rebooted.
I cannot see how the Triggers table relates to the Hosts table (in particular the host name). The way i understand it is, the trigger ID in the Triggers table is a list of unique identifiers for a trigger applied to a host. That is, if several triggers are applied to the same host, the each of those trigger-host relationships is given a TriggerID.

Can anyone suggest a way of relating to the "host" field of the Hosts table from the Triggers Table? Can you elaborate on the schema you have figured out?

Thanks,
aviperp

[Calimero]

trigger.triggerid <=> functions.triggerid / functions.itemid <=> items.itemid / items.hostid <=> hosts.hostid

Plus you should take a look at events.