"Queue Details" in Zabbix web interface is capped to 500 items.
To obtain full queue (Zabbix web interface):
- change value
QUEUE_DETAIL_ITEM_COUNT
in filefrontends\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