Hello. Can someone explain to me how triggers status store in database?
I want to make mysql query to get number of all triggers with 'problem' status.
I have 2 servers with Zabbix 2. and0 there is no problem with that query:
I'm always get correct value.
But on server with Zabbix 1.8 I get incorrect value.
For example I have 2 triggers with 'problem' status and i get value '216'
and if I'll have 3 triggers with 'problem' status then i get value '217'. 4 triggers and '218' value and so on.
I checked this query with phpmyadmin and i see too many triggers with 'value=1', but they really not 'active'
What is that? Some old triggers or what? How I can the correct number with Zabbix 1.8 like in Zabbix 2.0 ?
Thanks!
I want to make mysql query to get number of all triggers with 'problem' status.
I have 2 servers with Zabbix 2. and0 there is no problem with that query:
mysql -u zabbix -pMegaPass zabbix -N -s -e 'select count(*) from triggers where value=1'
But on server with Zabbix 1.8 I get incorrect value.
For example I have 2 triggers with 'problem' status and i get value '216'
and if I'll have 3 triggers with 'problem' status then i get value '217'. 4 triggers and '218' value and so on.
I checked this query with phpmyadmin and i see too many triggers with 'value=1', but they really not 'active'
What is that? Some old triggers or what? How I can the correct number with Zabbix 1.8 like in Zabbix 2.0 ?
Thanks!