solve, automate, speed up
Zabbix DB Query
Hosts having most problems, slow frontend, triggers in problem state
How many metrics received per item
Show unsupported items, transfer hostid into human readable name
Make sure case sensitivity is respected inside database tables, respect
Relation between problem and events, what can possibly go wrong?
Show SNMP OID registred in tamplate
select event / trigger names from specific proxy
Show session count opened per each user
Count of all active events or only new events
Combine two queries together from different tables
Show database charset and collation
select from hosts where status in (0,1)
Show itemid which contains reprocessing
Show all MySQL live variables
Manually remove history data based on timestamp
select * from zabbix.sessions; delete from sessions;
List all events based on Zabbix trigger ID