Ad Widget

Collapse

SQL Query to show zabbix alerts

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • moshikoy
    Member
    • Aug 2017
    • 56

    #1

    SQL Query to show zabbix alerts

    Hi,
    I'd like to be able to query my Zabbix V3.4 MySQL server for statistics

    For example, I'd like to be able to get all the triggers that alerted (created events) on the past week

    In the query I'd like to have the following columns: hostname, trigger name, eventid, event start time, event close time, acknowledge status, item name

    Can someone assist with this allegedly simple sql query

    Thanks,
    - Moshe
Working...