search

ikzelf / zbxdb

Zabbix database monitoring, the easy and extendable way
GNU General Public License v3.0
94 stars 45 forks source link

Need ZabDash queries #33

Closed rlfink closed 4 years ago

rlfink commented 4 years ago

What are the SQL queries used to populate the ZabDash dashboard, ie Triggers by host - Top 10 and Triggers by Severity? I am having trouble identifying why I have numbers displayed when I have no active issues. Also, from what script are these queries executed? Thank you

ikzelf commented 4 years ago

The queries van be found in etc/zbxdb_checks/{db_engine}/primary.{version}.cfg zbxdb.py uses the configfile to find them. After zbxdb.py connects to the instance it finds what version the instance has and loads the corresponding version file.

rlfink commented 4 years ago

My mistake. I am looking for the queries which read the Zabbix tables, not the database performance stats.

rlfink commented 4 years ago

I found what I needed. It was in triggers_severity_tab.inc.php.