Which table contains template names???

[simonquentel]

I am about to get mentally ill trying to find which table from zabbix database is containing the template names.

Table 'hosts_templates' and 'optemplate' have only BIGint columns and I cannot find which contains the names!

Any help?

Thanks in advance,

Simon

[steveboyson]

It's the "hosts" table. Templates have a "status" of "3" while (active) hosts have "0".

[simonquentel]

Thank you very much, I would never have found that without help!

Simon