Searching and Aggregating Trigger data

[moshikoy]

Hi,
I'd like to show statistics about triggers that were fired for hosts and host groups.
is there some way for me to query the MySQL database and pull triggers by hostname or time-range ?

How can I achieve that?

- Moshe