Zabbix Database Information

[Manuel Deschambault]

Zabbix server 7.4, Grafana server 12.3.0

I have a PostgreSQL 18 database under the hood, both for Zabbix and Grafana

I have a PostgreSQL datasource setup in Grafana using a read-only user I have setup in the Zabbix PostgreSQL database.

The problem I have is the 'host' table does not have an field containing the host name (at least in readable format), and I can't seem to find the other table that would have this information (that I could do a SQL join query on).

Is there a complete map of the Database available somewhere, or does someone have some exploration steps documented?

[cyber]

You need to look better... hosts table contains multiple fields
host -> "Host name" in UI
name -> "Visual name" in UI
name_upper -> same as host, but in all caps...

[Manuel Deschambault]

Strange, the 'host' field was giving me a list of templates, then I refreshed my search, and it then gave me host names, then I refreshed again, and it gave me a list of templates again... But the name field works, sorry I missed that, thanks for the help.

[Manuel Deschambault]

It there a map of the entire database available?

[Manuel Deschambault]

Ok, now I also have the 'name' field returning a list of template names... But not always. I will look into it more