Porblems SQL Query

[Heodrene]

Hi All,

I use Zabbix and Grafana : I created a map with Latitude and Longitude to locate all my sites.. That works greatly.
By default, the sites are displayed with a green point to say "Everything is OK".
I wish to use the SQL query to get problem by host to display on this map the sites with a problem.

I used debug options but I don't understand which SQL query to use

My Zabbix version is 4.0 with CentOS v7.5

Thank you for your help,

Heodrene

[kloczek]

Zabbix web frontend is written in php and it is open source code. Do whatever you want with this code.

[Heodrene]

Hi,

Certainly you're right and I thank you for your answer.
But I'm not a developer.
I just need to write a SQL query, not rewriting a new code

Regards,

Heodrene