Hi,
I am trying to create a trigger that will look at the same item from 4 hosts and if the value is above 2000 for five or more times within a 1 minute period on any combination of the 4 monitored hosts then trigger should be true.
Its needs to be a trigger so I can use it in a map afterwards.
In SQL I can get the number I need to check against with the sql below, but I would much rather not have an external script running to do this if I can do it nativly via zabbix ( 1.6 )
SELECT
count(*)
AS
'FAILED_COUNT'
FROM
history_uint
WHERE
(itemid=42825 OR
itemid=42826 OR
itemid=42827 OR
itemid=42828)
AND clock >unix_timestamp()-60
AND value > 2000
Any suggestions would be appreciated.
Many Thanks
Tony
I am trying to create a trigger that will look at the same item from 4 hosts and if the value is above 2000 for five or more times within a 1 minute period on any combination of the 4 monitored hosts then trigger should be true.
Its needs to be a trigger so I can use it in a map afterwards.
In SQL I can get the number I need to check against with the sql below, but I would much rather not have an external script running to do this if I can do it nativly via zabbix ( 1.6 )
SELECT
count(*)
AS
'FAILED_COUNT'
FROM
history_uint
WHERE
(itemid=42825 OR
itemid=42826 OR
itemid=42827 OR
itemid=42828)
AND clock >unix_timestamp()-60
AND value > 2000
Any suggestions would be appreciated.
Many Thanks
Tony