I want to query the Zabbix database for the count of events (all source types) from the events table that were added over the last 24 hours. Anyone have any suggestions on how to accomplish this?
A possible query would look something like:
However, I can’t see to figure out how to select what I need since the clock column uses unix_time.
A possible query would look something like:
Code:
select count(*) from events where source = 3 and clock ……