Exporting 30 day alert history for all hosts

[matt_shep]

Hello,

I'm running we Zabbix 6.2 on a postgresql database, I'm attempting to export all triggered alerts for the last 30 days for all hosts, I'm querying the postgres database directly however being new to the Zabbix world I'm not entirely sure what tables i need to query to retrieve the information above.

[LenR]

I would recommend using the API, not DB queries.

Here is a sample API program that gets daily alerts: https://github.com/rugenl/zabbix-api..._alerts_all.py