Recreate events
Hi,
We using Zabbix 2.0 + Mysql 5.5 on Linux OpenSuse 12.2
Just started use Zabbix couple months and have this need:
I loaded the historical data using zabbix_sender where become very easy and useful (all data can be seen with graphs).
But the reports and SLA outputs appear to be based on events occurred (which depends from triggers...)
What I want : Recreate the events based on the historical loaded and using a simple rule (history_uint table , trigger).
I not considering the "history -> trends" an issue for now because I believe is easy to workaround (disabling the housingkeeper during my process of load historical data and recreate the events).
My rule (witch today is a trigger) is simple , if the value of the item = 1 is UP , value = 0 is DOWN.
What I plan to do:
Considering I do everything right... is there some other table to populate or I need to worry, besides the events table?
What is the risk to "break" the integrity of my Zabbix database doing this?
Regards
Cesar
We using Zabbix 2.0 + Mysql 5.5 on Linux OpenSuse 12.2
Just started use Zabbix couple months and have this need:
- Identify our % of availability since jan/1/2013 (IT Services, Reports).
I loaded the historical data using zabbix_sender where become very easy and useful (all data can be seen with graphs).
But the reports and SLA outputs appear to be based on events occurred (which depends from triggers...)
What I want : Recreate the events based on the historical loaded and using a simple rule (history_uint table , trigger).
I not considering the "history -> trends" an issue for now because I believe is easy to workaround (disabling the housingkeeper during my process of load historical data and recreate the events).
My rule (witch today is a trigger) is simple , if the value of the item = 1 is UP , value = 0 is DOWN.
What I plan to do:
- create a procedure at mysql to read chronologically the history_uint table filtering the host->item and when the value was changed, include a event into the events table (linking it with the trigger already set in the environment).
Considering I do everything right... is there some other table to populate or I need to worry, besides the events table?
What is the risk to "break" the integrity of my Zabbix database doing this?
Regards
Cesar