zabbix full queue content from cache / db into csv

zabbix_full_queue.md

Issue

"Queue Details" in Zabbix web interface is capped to 500 items.

Workaround

To obtain full queue (Zabbix web interface):

• change value QUEUE_DETAIL_ITEM_COUNT in file frontends\php\include\defines.inc.php

More details:

• enable "debug" for your user
• open the "Queue Details" web page and save it (because it autorefreshes and you probably need more than 30 seconds)
• take the SQL query from the HTML
• add h.name and INNER JOIN (see below)
• execute on DB and save

TO DO:

• add timestamp and delay

Example:

SELECT i.itemid,i.hostid,i.name,h.name,i.key_ FROM items i 
inner join hosts h on h.hostid=i.hostid
WHERE i.flags IN (0,4) AND (i.itemid BETWEEN '69299' AND '69306')
INTO OUTFILE '/var/lib/mysql-files/output-20190529.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

# mysql zabbix < select.sql

works_on_my_machine.png