1.8.3 Schema help for Events reporting

[drose12]

Hey all, I'm looking to do some filtering on events, and the current filtering isn't sophisticated enough. I basically have two kinds of monitoring, regular items that come in via the agents with the associated triggers mostly HIGH and DISASTER, as well as web monitoring again with triggers of HIGH and DISASTER. Since the web monitoring has no templating, I've essentially hand duplicated everything to look the same for multiple servers. What I'm trying to do is gather some metrics for reporting upstream. I'm hoping to to be able to count the number of events that are "similar" using some sort of MySQL query, but I could not for the life of me figure out the schema and couldn't find any schema documentation. If someone has some, please forward me a link.

So essentially I'm looking to gather events with grouped by description and severity.

ie) I'll have something like Event Description: application 1 failed check on server x

where x could be one of 10 servers

Thus for a given date range, lets say one week, I'm hoping to count all of the HIGH events for any of the 10 servers matching that description.

Same would go for DISASTER.

I think if someone could point me to the right tables to be using or even a few pointers/examples I could get started.

I tried using the MySQL Workbench to data model the schema, but there doesn't appear to be any foreign key relationships to help with building an ERD.

Thanks for your help!