Export all Problems in once

[sycoweb]

Hi,
is it a way to export CSV file for all the selected problems ?
I mean : not export successively on each page of the set, but instead clicking only once.
We have a large park (about 20 000 hosts). So, when a problem affects thousends of hosts, it's not possible to export page per page to obtain datas about the massive impact.
Also, automatic extract through API is not really easy ...
Has anyone experiment this ?
Thanks.
Syco.

[Viktors Fomics]

When encountering similar task in Zabbix 7.4.x, this SQL did the trick for me:

SELECT p.name, p.eventid, p.clock, h.host
FROM problem p
INNER JOIN triggers t
ON p.objectid = t.triggerid
INNER JOIN functions f
ON t.triggerid = f.triggerid
INNER JOIN items i
ON f.itemid = i.itemid
INNER JOIN hosts h
ON i.hostid = h.hostid
ORDER BY p.clock DESC;

Of course it can be modified to add more columns depending on what is required to have in the report. Time should be additionally modified from the linux time, but the exact way to do it is dependant on the database time, also the commands for csv export depends on it.